尝试 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 !";}?>

原创粉丝点击