一、先链接数据库
二、再做数据库操作。
$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>