Accupressure Points Info System
";
echo " $menu[$index]
";
$server = 'localhost';
$user = '----';
$pass = '----';
$mydb = '----';
$table_name = 'points';
print "
";
// print "Table $table_name Data
";
$connect = mysqli_connect($server, $user, $pass);
if( !$connect )
{ die ("Can't connect to $server using $user");
}
else
{
$SQLcmd = "SELECT name, cname FROM $table_name
where ($menu[$index]=1)";
// echo "The query is $SQLcmd";
mysqli_select_db($connect, $mydb);
$results_id = mysqli_query ( $connect, $SQLcmd);
if($results_id)
{ // p.178
print "
";
print "| Point Name | Chinese Name";
while($row=mysqli_fetch_row($results_id))
{ print " | ";
foreach ($row as $field) print "| $field | ";
print "
";
}
}
else echo ( "Search failed");
mysqli_close($connect);
}
?>