التعامل مع قواعد بيانات MySQL بإستخدام php : إنشاء قاعدة بيانات MySQL

bool mysql_query( sql, connection );

<?php

   




$dbhost = 'localhost:3036';

   $dbuser = 'root';

   $dbpass = 'rootpassword';

   $conn = mysql_connect($dbhost, $dbuser, $dbpass);

   

   if(! $conn ) {

      die('Could not connect: ' . mysql_error());

   }

   

   echo 'Connected successfully';

   

   $sql = 'CREATE Database test_db';

   $retval = mysql_query( $sql, $conn );

   

   if(! $retval ) {

      die('Could not create database: ' . mysql_error());

   }

   

   echo "Database test_db created successfully\n";

   mysql_close($conn);

?>

bool mysql_select_db( db_name, connection );

<?php

   $dbhost = 'localhost:3036';

   $dbuser = 'guest';

   $dbpass = 'guest123';

   $conn = mysql_connect($dbhost, $dbuser, $dbpass);

   

   if(! $conn ) { 

      die('Could not connect: ' . mysql_error());

   }

   

   echo 'Connected successfully';

   

   mysql_select_db( 'test_db' );

   mysql_close($conn);

   

?>

<?php

   

   $dbhost = 'localhost:3036';

   $dbuser = 'root';

   $dbpass = 'rootpassword';

   $conn = mysql_connect($dbhost, $dbuser, $dbpass);

   

   if(! $conn ) {

      die('Could not connect: ' . mysql_error());

   }

   

   echo 'Connected successfully';

   

   $sql = 'CREATE TABLE employee( '.

      'emp_id INT NOT NULL AUTO_INCREMENT, '.

      'emp_name VARCHAR(20) NOT NULL, '.

      'emp_address  VARCHAR(20) NOT NULL, '.

      'emp_salary   INT NOT NULL, '.

      'join_date    timestamp(14) NOT NULL, '.

      'primary key ( emp_id ))';

   mysql_select_db('test_db');

   $retval = mysql_query( $sql, $conn );

   

   if(! $retval ) {

      die('Could not create table: ' . mysql_error());

   }

   

   echo "Table employee created successfully\n";

   

   mysql_close($conn);

?>

CREATE TABLE employee(

   emp_id INT NOT NULL AUTO_INCREMENT,

   emp_name VARCHAR(20) NOT NULL,

   emp_address  VARCHAR(20) NOT NULL,

   emp_salary   INT NOT NULL,

   join_date    timestamp(14) NOT NULL,

   primary key ( emp_id ));

<?php

   $dbhost = 'localhost:3036';

   $dbuser = 'root';

   $dbpass = 'rootpassword';

   $conn = mysql_connect($dbhost, $dbuser, $dbpass);

   

   if(! $conn ) {

      die('Could not connect: ' . mysql_error());

   }

   

   $query_file = 'sql_query.txt';

   

   $fp = fopen($query_file, 'r');

   $sql = fread($fp, filesize($query_file));

   fclose($fp); 

   

   mysql_select_db('test_db');

   $retval = mysql_query( $sql, $conn );

   

   if(! $retval ) {

      die('Could not create table: ' . mysql_error());

   }

   

   echo "Table employee created successfully\n";

   mysql_close($conn);

?>