PHP, MySQL, Drupal, .htaccess, Robots.txt, Phponwebsites: Create mysql table using php

6 Mar 2014

Create mysql table using php

                        You can create mysql table using php. The following mysql query is used to create mysql table.
                    CREATE TABLE table_name(field_name datatype(length))

The php script as follows as:

<?php
mysql_connect('localhost','root','');
mysql_select_db('new');
$query=mysql_query("create table table1(id int(5),name varchar(40),img varchar(30))") or die(mysql_error());
if($query)
{
 echo 'Table is created';
}
else
{
 echo'Table is not created';
}
?>

Where,
           - mysql_connect() is used to connect the database.
           - 'localhost' is server name.
           - 'root' is user name of database.
           - '' represent the password of database.
           - mysql_select_db() is used to select the database for use.
           - 'new' is the database new.
           - mysql_query() is used for execute the mysql query.
           - mysql_error() gives error message when the mysql query is not running successfully.

                    Now the mysql table 'table1' is created. You can see it in your mysql database at phpmyadmin.
Your mysql database should be like this:

Create mysql table using CREATE TABLE mysql command in php

Now you created your mysql table.


Related Post:

No comments:

Post a Comment

Note: only a member of this blog may post a comment.