PHP操作mysql資料庫

標籤：php   mysql   

1）串連mysql

<?php

  $con = mysql_connect("localhost","root","12345");

  if(!$con){

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

  }

  mysql_close($con);

?>

2）php mysql建立資料庫和表

<?php

  $con=mysql_connect("localhost","root","123456");

  if(!$con){

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

  }

 

  if(mysql_query("create database my_db",$con));

  {

   echo "database created";

  }else

  {

   echo "Error create database: ‘". mysql_error();

  }

 

  mysql_close($con);

?>

3）php mysql建立資料庫和表

<?php

$con = mysql_connect("localhost","root","123456");

if(!$con){

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

}

if(mysql_query("crate database my_db",$con)){

 echo "database careated";

}else{

 echo "Error create database:" .mysql_error();

}

mysql_select_db("my_db",$con);

$sql = "CREATE TABLE Persons 

(

FirstName varchar(15),

LastName varchar(15),

Age int

)";

mysql_query($sql,$con);

mysql_close($con);

?>

3）php mysql建立資料庫和表

<?php

$con=mysql_connect("localhost","root","123456");

if($con){

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

}

if(mysql_query("create database my_db",$con));

  {

   echo "database created";

  }else

  {

   echo "Error create database: ‘". mysql_error();

  }

mysql_select_db("my_db"，$con);

mysql_query("INSERT INTO Persons (FirstName, LastName, Age) 

VALUES (‘Peter‘, ‘Griffin‘, ‘35‘)");

    mysql_query("NSERT INTO Persons (FirstName, LastName, Age) 

VALUES (‘Glenn‘, ‘Quagmire‘, ‘33‘)");

mysql_close($con);

?>

4）php mysql建立表

<?php

  $con = mysql_connect("loaclhost","root","123456");

  if(!$con){

   die(‘could not conenct:‘ .mysql_error());

  }

  //建立資料庫

  if(mysql_query("create database my_db",$con));

  {

   echo "database created";

  }else

  {

   echo "Error create database: ‘". mysql_error();

  }

  //選擇建立的資料庫my_db

  

  mysql_select_db("my_db",$con);

  

  //建立表

  mysql_select_db("my_db",$con);

$sql = "CREATE TABLE Persons 

(

FirstName varchar(15),

LastName varchar(15),

Age int

)";

mysql_query($sql,$con);

//插入資料

$sql_in ="INSERT INTO Persons (FirstName, LastName, Age)

VALUES

(‘$_POST[firstname]‘,‘$_POST[lastname]‘,‘$_POST[age]‘)";

    if(!mysql_query($sql_n,$con)){

      die(‘Error:‘ .mysql_error());

    }

    echo "1 row added";

    

    mysql_close($con);

?>

5）php 查詢mysql資料

<?php

$con = mysql_connect("localhost","peter","abc123");

if (!$con)

  {

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

  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Persons");

echo "<table border=‘1‘>

<tr>

<th>Firstname</th>

<th>Lastname</th>

</tr>";

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row[‘FirstName‘] . "</td>";

  echo "<td>" . $row[‘LastName‘] . "</td>";

  echo "</tr>";

  }

echo "</table>";

mysql_close($con);

?>

PHP操作mysql資料庫