尝试 PHP
来源:互联网 发布:易语言json解析 编辑:程序博客网 时间:2024/06/04 19:12
<?php$conn = mysql_connect("localhost","test","123456");if (!$con){die('Could not connect: ' . mysql_error());}mysql_select_db("mydb", $con);$result = mysql_query("select * from persons", $con);echo "<table border='1'><tr> <th>Firstname</th> <th>Lastname</th></tr>";while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row[0] . "</td>"; echo "<td>" . $row[1] . "</td>"; echo "</tr>";}echo "</table>";mysql_close($con);?><?php$json_arr = json_encode(array("webname", "webname.org"));echo "<br />";print_r(json_decode($json_arr));?><?php$my = new mysqli("localhost", "test", "123456", "mydb");if (mysqli_connect_errno()) { printf("error: %d\n", mysqli_connect_error()); exit();}if ($my->query("insert into persons(first_name, last_name) values('don', 'self')")) { echo "affected_rows: ".$my->affected_rows."<br />"; echo "insert_id: ".$my->insert_id."<br />";}?><?php echo strpos("heloloworld", "world"); $email = "helloworld@qq.com"; $mail_array = explode("@", $email); print_r($mail_array); $arr = array("a", "bb", "ccc", "dddd"); $test = implode("-", $arr); print_r($test);?><?php $mail_to = "qs8607@qq.com"; $mail_subject = "Test"; $message = "hello, not time no see"; $mail_from = "qs8607@qq.com"; $headers = "from: $mail_from"; mail($mail_to, $mail_subject, $message, $headers); echo "mail sent...";?><?php $conn = mysql_connect("localhost", "test", "123456"); if (!$conn) die('could not connect: '.mysql_error()); mysql_select_db("test", $conn); $result = mysql_query("select * from work"); while ($row = mysql_fetch_array($result)) { echo $row['id']." ".$row['name']; echo "<br />"; } mysql_close($conn);?><?php $conn = mysql_connect("localhost", "test", "123456");if (!$conn) die("could not connect: ".mysql_error());mysql_select_db("mydb", $conn);$sql = "select * from persons";$result = mysql_query($sql, $conn);while ($row = mysql_fetch_array($result)) { echo $row['first_name']." ".$row['last_name']; echo "<br />";}mysql_close($conn);?><?php try {$db = new PDO("mysql:host=localhost;dbname=mydb", 'test', '123456');$sql = "insert into persons values('john', 'smith', '13')";echo $db->exec($sql);$db = null;} catch (PDOException $e) { echo "error !";}?>