function func2() { //system("ln -s ./html5/oceans.mp4 ./tron.rmvb",$ret); $conn = MYSQL_connect("localhost", "root", "") or die("connect err: " . MYSQL_error()); echo "连接mysql数据库成功<br>"; sleep(1); MYSQL_close($conn); echo "关闭数据库成功<br>"; }
return false; } $_SESSION["timez"] += 1; if ($_SESSION["timez"] > 5) { echo "<script type=\"text/javascript\">alert(\"login failed!\")</script>"; echo "<script>window.close();</script>"; } if (is_null($_POST[user])) { } else { $succ = 0; if (check_verf() == false) { echo "<script type=\"text/javascript\">alert(\"验证码错误!\")</script>"; } else { $conn = MYSQL_connect($L_HOST, $L_USER, $L_PASSWORD); if (!$conn) { die("connect err: " . MYSQL_error()); } MYSQL_select_db($L_DBNAME, $conn); $result = mysql_query("select * from usrtab", $conn); if (!$result) { die("valid error"); } // echo "<table>"; // echo "<tr><td>姓名</td></tr>"; while ($row = mysql_fetch_row($result)) { //echo "<tr><td>$row[0]</td></tr>"; if ($row[0] == $_POST[user] && $row[1] == $_POST[password]) { $succ = 1; break; } }
/** * Updates a row in table cardio by id * * @param int $cardio_id * @param String $exercise The name of the exercise * @param int $time Time in minutes * @param double $distance Distance in miles * @param double $level Represents intensity * @param String $date * */ public function update_cardio($cardio_id, $exercise, $time, $distance, $level, $date) { $query = "UPDATE cardio\n SET exercise = '{$exercise}', time = '{$time}',\n distance = '{$distance}', level = '{$level}', date = '{$date}'\n WHERE cardio_id = '{$cardio_id}' "; MYSQL_query($query) or die('Problem updating cardio.' . MYSQL_error()); }