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>&nbsp;</p>';
mysql_close($conn);
echo "Hello!"; 
?>