Re: Re: Different approach?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



John Taylor-Johnston wrote:
Sorry to bother. I was hoping for inspiration. The code works. I wonder if there is a cleaner way?

what is the context of the code you posted? ... in a function? class? part of an app? whats its purpose?

why do you need to check/create the table dynamically?
why do you think the way its done now is 'bad'?

rgds, Jochem

John Taylor-Johnston wrote:
Hi,

I've read:


http://dev.mysql.com/doc/mysql/en/create-table.html

Would anyone code/approach this differently?

#################################################
$server = "localhost";
$user = "myname";
$pass = "mypass";
$db = "mydb";
$table = "demo_assignment1";

#################################################
$myconnection = mysql_connect($server,$user,$pass);

#################################################
$sql = "CREATE TABLE IF NOT EXISTS `demo_assignment1` (
`StudentNumber` varchar(8) NOT NULL default '',
`Exercise1` varchar(100) NOT NULL default '',
`Exercise2` varchar(100) NOT NULL default '',
`TimeStamp` timestamp(14) NOT NULL,
PRIMARY KEY  (`TimeStamp`)
) TYPE=MyISAM COMMENT='place something here';";

mysql_select_db($db,$myconnection);
mysql_query($sql) or die(print mysql_error());

#################################################
$sql = "INSERT INTO $table
(StudentNumber,Exercise1,Exercise2) values
('$StudentNumber','$Exercise1','$Exercise2')";

mysql_select_db($db,$myconnection);
mysql_query($sql) or die(print mysql_error());

mysql_close($myconnection);


-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux