?? sql.php
字號:
<?php
//$course_title=$_POST['course_title'];
//$length=$_POST['length'];
$mysql_server_name='co-project.lboro.ac.uk';
$mysql_username='group04';
$mysql_password='grp55dnv';
$mysql_database='group04';
$conn=mysql_connect ($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
//$sql = 'SELECT * FROM `course_info` WHERE `length` = CONVERT(_utf8 \'"$length"\' USING latin1) COLLATE latin1_swedish_ci';
$sql = 'select * from course_info where length =\"{$_post['length']}"';
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
while($rs=mysql_fetch_object($result))
{
echo "<table \"1\"><tr><td>Name:".$rs->course_code."</td></tr>";
echo "<tr><td>Comments:".$rs->course_title."</td></tr></table><br/>";
}
print '<p> </p>';
mysql_close($conn);
echo "Hello!";
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -