PHP/MySQL Database/Table Create

Create new table in MySQL

   <source lang="html4strict">

<?php $linkID = mysql_connect("mysql153.secureserver.net", "wbex", "password"); mysql_create_db("new_db", $linkID); mysql_select_db("new_db"); $query = "CREATE TABLE new_table (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, new_col VARCHAR(25))"; $result = mysql_query($query); $axe = mysql_drop_db("new_db"); ?>

      </source>
   
  

Create table and install data

   <source lang="html4strict">

<?
 define("DBName","test");
 define("HostName","localhost");
 define("UserName","root");
 define("Password","");
 
 if(!mysql_connect(HostName,UserName,Password)){ 
   echo "Cannot get connected to the database ".DBName."!
";
   echo mysql_error();
   exit;
 }
 mysql_select_db(DBName);
 // Creating the t table. If it already exists,
 // "@" overrides the error message
 @mysql_query("create table t(id int, a double)");
 // Inserting 10 records into the table
 for($i=0; $i<10; $i++){ 
   $id=time();
   mysql_query("insert into t(id, a) values($id, "$i")");
 }
 
 // Outputting all records
 $r=mysql_query("select * from t");
 
 for($i=0; $i<mysql_num_rows($r); $i++) { 
   $f=mysql_fetch_array($r);
   echo "$f[id] -> $f[a]
\n";
 }

?>

      </source>
   
  

Creating a Table in MySQL

   <source lang="html4strict">

<?php
 $host="mysql153.secureserver.net";
 $uname="wbex";
 $pass="password";
 $database="wbex";
 $tablename="mytable";
 $connection= mysql_connect ($host, $uname, $pass) or die ("Database connection failed!");
 $result=mysql_select_db ($database) or die ("Database could not be selected");
 $query = "create table ". $tablename ." (name varchar (20) Not Null, email varchar (40) Not Null)";
 $result = mysql_query ($query);
 
 if (! $result) {
   die ("Query could not be executed.");
 } else {
   echo $tablename." created in the megabase database.\n";
 }
 ?>
          
      </source>
   
  

Table-Creation Script

   <source lang="html4strict">

<? $db_name = "wbex"; $connection = @mysql_connect("mysql153.secureserver.net", "wbex", "password") or die(mysql_error()); $db = @mysql_select_db($db_name, $connection) or die(mysql_error()); $columnNames = array("col1","col2","col3"); $columnTypes = array("int","Date","double"); $sql = "CREATE TABLE MyTable ("; for ($i = 0; $i < count($columnNames); $i++) {

    $sql .= $columnNames[$i]." ".$columnTypes[$i]. ", ";

} $sql = substr($sql, 0, -2); $sql .= ")"; echo($sql); $result = mysql_query($sql,$connection) or die(mysql_error()); if ($result) {

$msg = "

MyTable has been created!

";

    echo($msg);

} ?>

      </source>