Temporary Table PhpMyAdmin

[mfredy92]

Hello Everyone,

I have written code to create Temporary Table using PHP script. Now, when I run the script, it seems to have created the temporary table. Now, my problem is when I try to do INSERT statement in PhpMyAdmin into the temporary table I create, I am getting an error message in phpMyAdmin which says table not found. The thing is I do not know if I am creating the temp tables correctly or If I am not writing the code properly. Any help would be appreciated.

<?php
 
error_reporting(E_ALL);
ini_set('display_errors', '1');
 
$hostname = "localhost"; 
$username = "1104107";
$password = "r940c1";
$database = "db1104107";
//echo '24';
 
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password);
$db = mysql_select_db($database, $dbhandle)
  or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
echo '4';
$query_createTemporaryTable = "CREATE TEMPORARY TABLE `Basket`(
temporary_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
ArtistName VARCHAR( 20 ) ,
NAMEOfTheDVD VARCHAR( 30 )
)Engine = MyISAM"; 
 
$result_createtemptable = mysql_query($query_createTemporaryTable); 
echo $result_createtemptable;
$query_insertintotable = "INSERT INTO Basket( ArtistName, NAMEOfTheDVD) VALUES ( 'R', 'SHAWooSHANK')"; 
 
$result_insertintotable = mysql_query($query_insertintotable ) or die(mysql_error()); 
 
$query_selecttemptable = "SELECT ArtistName,NAMEOfTheDVD FROM Basket`"; 
 
$result_selecttemptable = mysql_query( $query_selecttemptable) or die(mysql_error()); 
 
 while($row_selecttemptable = mysql_fetch_array($result_selecttemptable)) 
      echo $row_selecttemptable['ArtistName'] . ' ,' . $row_selecttemptable['NAMEOfTheDVD'];
 
 
 
 
?>

Please note I have tried a couple of forums and I have not been able to resolve this issue. I thank you in advance for helping me. Looking forward for replies

[Luuk]

RTFM ;-)
"Temporary Tables

.... A TEMPORARY table is visible only to the current connection, ...."
( http://dev.mysql.com/doc/refman/5.5/...ate-table.html )

[mfredy92]

Whats RTFM? So, basically what I am doing is right then?

[Luuk]

RTFM is an acronym...
see: http://www.urbandictionary.com/define.php?term=RTFM

For your script, i copied it, and tested it here.
I have query-log enabled on my MySQL server, and it shows:

140105 19:04:52  3506 Connect   test@localhost as anonymous on
                 3506 Init DB   test
                 3506 Query     CREATE TEMPORARY TABLE `Basket`(
    temporary_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    ArtistName VARCHAR( 20 ) ,
    NAMEOfTheDVD VARCHAR( 30 )
    )Engine = MyISAM
                 3506 Query     INSERT INTO Basket( ArtistName, NAMEOfTheDVD) VALUES ( 'R', 'SHAWooSHANK')
                 3506 Query     SELECT ArtistName,NAMEOfTheDVD FROM Basket`
                 3506 Quit
 

so, YES, it looks like its working!
Congratulations!

[mfredy92]

woohoooo i thank you soo much/. I have been working tirelessly on this.. Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu.