{"id":74,"date":"2009-11-26T22:45:37","date_gmt":"2009-11-27T03:45:37","guid":{"rendered":"http:\/\/wukenny.host-ed.net\/?p=74"},"modified":"2009-11-26T22:45:37","modified_gmt":"2009-11-27T03:45:37","slug":"php-tutorial","status":"publish","type":"post","link":"http:\/\/kennywu.info\/?p=74","title":{"rendered":"PHP Tutorial -1"},"content":{"rendered":"

PHP & MySQL for Dummies<\/a><\/h4>\n

This is the book I am going to start with learning PHP. I am using MS SQL server at work, so MySQL part is not a problem. The basic PHP commands and functions will be listed along with my study progress.<\/p>\n

Chapter 2: Connect to mysql<\/h4>\n

The provided mysql_up.php used mysqli_query function, which due to unknown reason does not work. MySQL revision at my website is 5.1.30 verified with mysql_get_server_info. But mysql_up-4.php works, it used mysql_query.<\/p>\n

Check MySQL connection<\/h4>\n

<?php
\n\/* Program: mysql_up.php
\n* Desc: Connects to MySQL Server and
\n* outputs settings.
\n*\/
\necho \"<html>
\n<head><title>Test MySQL<\/title><\/head>
\n<body>\";
\n$host=\"fdb2.host-ed.net\";
\n$user=\"username\";
\n$password=\"password\";
\n$cxn = mysql_connect($host,$user,$password);
\n$sql=\"SHOW STATUS\";
\n$result = mysql_query($sql);
\nif($result == false)
\n{
\necho \"<h4>Error: \".mysql_error($cxn).\"<\/h4>\";
\n}
\nelse
\n{
\n\/* Table that displays the results *\/
\necho \"<table border='1'>
\n<tr><th>Variable_name<\/th>
\n<th>Value<\/th><\/tr>\";
\nfor($i = 0; $i < mysql_num_rows($result); $i++)
\n{
\necho \"<tr>\";
\n$row_array = mysql_fetch_row($result);
\nfor($j = 0;$j < mysql_num_fields($result);$j++)
\n{
\necho \"<td>\".$row_array[$j].\"<\/td>n\";
\n}
\n}
\necho \"<\/table>\";
\n}?>
\n<\/body><\/html> <\/code><\/p><\/blockquote>\n

Check MySQL revision<\/h4>\n

<?php
\n$host=\"fdb2.host-ed.net\";
\n$user=\"username\";
\n$password=\"password\";
\n$link = mysql_connect($host,$user,$password);if (!$link) {
\ndie('Could not connect: ' . mysql_error());
\n}
\nprintf(\"MySQL server version: %sn\", mysql_get_server_info());
\n?><\/code><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

PHP & MySQL for Dummies This is the book I am going to start with learning PHP. I am using MS SQL server at work, so MySQL part is not a problem. The basic PHP commands and functions will be … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[43,47],"class_list":["post-74","post","type-post","status-publish","format-standard","hentry","category-lamp","tag-mysql","tag-php"],"_links":{"self":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=74"}],"version-history":[{"count":0,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/74\/revisions"}],"wp:attachment":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}