直接在PHP中写数据库查询

一、先链接数据库

二、再做数据库操作。

$conn = mysql_connect("localhostt","root","root") or die ("wrong!");

$sel = mysql_select_db("canal_bay",$conn);
$sql="SELECT path FROM cab_picture WHERE ID='22'";
$que = mysql_query($sql);
$str = mysql_fetch_row($que);

var_dump($str);die;

<?php

if (isset( $_POST [ 'submit' ])) {

       $rowID = $_POST [ 'id' ];

       mysql_connect( "mysql153.secureserver.net" , "java2s" , "password" );

       mysql_select_db( "java2s" );

       

       $query = "SELECT * FROM Employee WHERE ID='$id'" ;

       $result = mysql_query( $query );

       list( $name , $productid , $price , $description ) = mysql_fetch_row( $result );

}

 

?>

<form action= "<?php echo $_SERVER['PHP_SELF']; ?>" method= "post" >

    <select name= "id" >

       <option name= "" >Choose a employee:</option>

       <option name= "1" >1</option>

       <option name= "2" >2</option>

       <option name= "3" >3</option>

    </select>

    <input type= "submit" name= "submit" value= "Submit" />

</form>