📄 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 + -