Happy Codings - Programming Code Examples
Html Css Web Design Sample Codes CPlusPlus Programming Sample Codes JavaScript Programming Sample Codes C Programming Sample Codes CSharp Programming Sample Codes Java Programming Sample Codes Php Programming Sample Codes Visual Basic Programming Sample Codes

Php Programming Code Examples

Php > Database Related Code Examples

MySQL Insta-Table

MySQL Insta-Table <?php // 4.0.5 FINAL // // dbinstaller.php // // $username = "xxxx"; $password = "xxxx"; $hostname = "xxxx"; $database = "xxxx"; // this is the name of the table you want to create $tablename = "xxx"; // change this statement to reflect // the database you'd like to create $stmt = "CREATE TABLE $tablename ( ID VARCHAR(200), Name VARCHAR(200))"; function printError($errorMesg) { printf("<br> %s <br>\n",$errorMesg); } // connect to the DB if(!($link = mysql_connect($hostname,$username,$password))) { printError(sprintf("Error connecting to host %s, by user %s",$hostname,$username)); exit(); } // select active db if(!mysql_select_db($database,$link)) { printError(sprintf("Error in selecting %s database",$database)); printError(sprintf("error: %d %s",mysql_errno($link),mysql_error($link))); exit(); } // create my table if(!mysql_query(sprintf($stmt,$tablename), $link)) { printError(sprintf("Error in executing %s stmt",$stmt)); printError(sprintf("error: %d %s",mysql_errno($link),mysql_error($link))); exit(); } printf("<br> Created Table %s.%s <br>\n",$database,$tablename); ?>