Category Archives: Information Technology

My IT consulting fields.

PHP Tutorial -2 (Data type and array)

Posted on by
Reply

PHP tags
<?php ?>
Text Output
echo "something";
Variable
echo "something"; //$ in front, can not begin with a number, case sensitive
Constant
define("name", "value");
Format number
echo sprintf("%01.2f", 25); //25-->25.00
echo number_format(25000, 2); //25000-->25,000.00
Single-quoted Vs double-quoted strings
$age=12; $result1="age"; $result2='age'; //resut1:12 resutl2: $age
Joining string, or concatenation (dot . or .=). To get Hello World!
echo 'Hello'." ".'World';
Format a date ( August 10, 2006 –> 2006/08/10)
echo date("Y/m/d");
Array-Create. index starts with 0, use one of the following ways to create.
$pets[0]="unicorn"
$pets = array("dragon", "unicorn", "tiger");
$pets[] ="dragon"; $pets[] ="unicorn"; $pets[] ="tiger";
$capitals =array("CA" => "Sacramento", "TX" => "Austin", "OR" => "Salem" );
Array-Viewing.
print_r($pets);
var_dump($pets);
Array-Removing.
$pets[2]="";
unset ($pets[4]);
Array-Sorting.
sort("pets"); //To sort an array that has numbers as keys and reassign keys
asort("pets"); //To sort an array that has strings as keys
Array-Getting Values.
list ($firstvar, $secondvar)=$pets;
//To get value from an array that has numbers as keys and put them in variables
extract("pets");
//To copy all the values from an array into variables named from the corresponding keys. The sample from the book is wrong, since no key was assigned in $shirtInfo
current($arrayname) next($arrayname) previous($arrayname) end($arrayname) reset($arrayname);
//Manually iterate through an array
foreach($capitals as $state =>$city)
//walks through the array one value at a time.

PHP Tutorial -1

Posted on by
Reply

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 listed along with my study progress.

Chapter 2: Connect to mysql

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.

Check MySQL connection

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

Check MySQL revision

<?php
$host="fdb2.host-ed.net";
$user="username";
$password="password";
$link = mysql_connect($host,$user,$password);if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL server version: %sn", mysql_get_server_info());
?>