MySQL Forums
Forum List  »  PHP

sample mysqli_query( Create table ... needed
Posted by: Gerald James
Date: September 19, 2013 05:54PM

I am trying to convert away from MySQL to mysqli and I can find no example to create my table using mysqli coding. Thanks for your help.

<code>
$qry = "Create Table $this->case_c_table (".
"c_id INT NOT NULL AUTO_INCREMENT ,".
"c_match VARCHAR( 8 ) ,".
"c_flag VARCHAR( 1 ) ,".
"c_username VARCHAR( 16 ) ,".
"c_element VARCHAR( 50 ) ,"
"PRIMARY KEY ( c_id )".
")";
if(!mysql_query($qry,$this->connection))
{
$this->HandleDBError("Error creating the table \nquery was\n $qry");
return false;
}
</code>

Options: ReplyQuote


Subject
Written By
Posted
sample mysqli_query( Create table ... needed
September 19, 2013 05:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.