Sunday, 28 April 2013
Tuesday, 16 April 2013
PHP MySQL Tutorial: Simple MySQL Config Class
config.php
<?php class Config { // Config variables public $_host = "host"; // eg. localhost public $_username = "username"; public $_password = "password"; public $_dbname = "dbname"; // Database name // Constructor public function __construct(){ } } ?>index.php
<?php // Include config class file include("config.php"); // Create config class $config = new Config(); // Create connection $con = mysqli_connect($config->_host, $config->_username, $config->_password, $config->_dbname); // Check connection if (mysqli_connect_errno($con)) die("Failed to connect to MySQL: " . mysqli_connect_error()); echo "MySQL successfully connected!" ?>
Saturday, 13 April 2013
PHP Basic Calendar Tutorial By UnknownGhost03 Fix!
<html> <head> <title>PHP Basic Calendar</title> <script> function goLastMonth(month, year){ if(month == 1) { --year; month = 13; } --month var monthstring = ""+month+""; var monthlength = monthstring.length; if(monthlength <=1){ monthstring = "0" + monthstring; } document.location.href = "<?php $_SERVER['PHP_SELF'];?>?month="+monthstring+"&year="+year; } function goNextMonth(month, year){ if(month == 12) { ++year; month = 0; } ++month var monthstring = ""+month+""; var monthlength = monthstring.length; if(monthlength <=1){ monthstring = "0" + monthstring; } document.location.href = "<?php $_SERVER['PHP_SELF'];?>?month="+monthstring+"&year="+year; } </script> </head> <body> <?php //get current date or specific month and year if (isset($_GET['day'])){ $day = $_GET['day']; } else { $day = date("d"); } if(isset($_GET['month'])){ $month = $_GET['month']; } else { $month = date("m"); } if(isset($_GET['year'])){ $year = $_GET['year']; }else{ $year = date("Y"); } //get date data for display such as month name $currentTimeStamp = strtotime( "01-$month-$year"); $monthName = date("F", $currentTimeStamp); ?> <table border="1px" cellpadding="0px" cellspacing="0px"> <tr> <td align="center"> <input style='width:50px;' type='button' value='<'name='previousbutton' onclick ="goLastMonth(<?php echo $month.','.$year?>)"> </td> <td align="center" colspan="5"><?php echo $monthName." ".$year; ?></td> <td align="center"> <input style='width:50px;' type='button' value='>'name='nextbutton' onclick ="goNextMonth(<?php echo $month.','.$year?>)"> </td> </tr> <tr> <td align="center" width='100px'>Sunday</td> <td align="center" width='100px'>Monday</td> <td align="center" width='100px'>Tuesday</td> <td align="center" width='100px'>Wednesday</td> <td align="center" width='100px'>Thursday</td> <td align="center" width='100px'>Friday</td> <td align="center" width='100px'>Saturday</td> </tr> <tr> <?php //get the number of days in the current month and year $numDays = date("t", $currentTimeStamp); //keep track of the number of cell created $counter = 0; for($i = 1; $i < $numDays+1; $i++, $counter++){ $timeStamp = strtotime("$year-$month-$i"); //create empty cell until first day of the month if($i == 1) { $firstDay = date("w", $timeStamp); for($j = 0; $j < $firstDay; $j++, $counter++) { echo "<td> </td>"; } } //create new row if($counter % 7 == 0) { echo"</tr><tr>"; } //print day number echo "<td>$i</td>"; } //fill up the leftover cells of the table while($counter % 7 != 0) { echo "<td> </td>"; $counter++; } ?> </tr> </table> </body> </html>
Friday, 5 April 2013
HTML5 Tutorial: Basic Structure
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Website Title Here</title> </head> <body> </body> </html>
Tag lists link:
Subscribe to:
Posts (Atom)