http://www.bouthors.com/wikialex/ 2012-06-03T22:07:29+02:00 http://www.bouthors.com/wikialex/ http://www.bouthors.com/wikialex/lib/images/favicon.ico text/html 2007-09-18T13:56:32+02:00 Alexandre Bouthors http://www.bouthors.com/wikialex/doku.php/javascript?rev=1190116592&do=diff status: first draft * My JavaScript reading list Libraries * The Yahoo UI(YUI) library Javascript design and code examples * The Singleton Design Pattern at DHTMLKitchen (heavily used in Yahoo UI examples) text/html 2007-09-04T19:32:20+02:00 Alexandre Bouthors http://www.bouthors.com/wikialex/doku.php/php:storing_date_and_time_in_mysql?rev=1188927140&do=diff Storing date and time in MySQL with PHP First, define a column (let's call it test_column) with the DATETIME forma in MySQL. Then, a sample query to insert the current date and time (let's call the table test_table) would be: // we assume that we are already connected e.g. $mysqli = new mysqli(database connection parameters); $query = "insert INTO test_table (test_column) VALUES ('".date("Y-m-d H:i:s") . "')"; if (($mysqli->query($query)) === TRUE) { echo $result; printf("time successf… text/html 2007-09-04T19:08:30+02:00 Alexandre Bouthors http://www.bouthors.com/wikialex/doku.php/php:magic_quotes?rev=1188925710&do=diff magic_quotes feature (which is 'on' by default) apply the addslashes() function to all gpc data ($_GET, $_POST, $_COOKIE). This is supposed to avoid problem if these datas are inserted in a database later in the code. Although magic_quotes are probably helpful to protect beginning coders against themselve, they becomes quickly annoying. text/html 2007-09-04T19:08:23+02:00 Alexandre Bouthors http://www.bouthors.com/wikialex/doku.php/php?rev=1188925703&do=diff status: draft * mcrypt and encryption with PHP * database functions * Using Swift Mailer to send mails with PHP and a Gmail (or Google Apps for you domain) account * magic quotes * Storing date and time in mysql with PHP Some usefull resources: * The official PHP site. * A PHP Wiki * The phpdeveloper.org website for news and new blog posts about PHP * PHP Freaks text/html 2007-09-04T17:48:37+02:00 Alexandre Bouthors http://www.bouthors.com/wikialex/doku.php/apache:mod_rewrite?rev=1188920917&do=diff (status: first draft) Apache configuration: is mod_rewrite loaded? In your http.conf file, the following line must be uncommented (remove the # at the beginning of the line) LoadModule rewrite_module modules/mod_rewrite.so Note: some Apache configurations may also need an AddModule instruction text/html 2007-08-28T10:05:07+02:00 Alexandre Bouthors http://www.bouthors.com/wikialex/doku.php/php:swift?rev=1188288307&do=diff After trying to send e-mails with my gmail account and gmail smtp server with PHP, I found a very goog PHP mailing library : Swift Mailer. I use version 3.2.6 for PHP5. Here is sample code on how to send e-mail with Swift Mailer and your gmail account: text/html 2007-08-21T17:55:59+02:00 Alexandre Bouthors http://www.bouthors.com/wikialex/doku.php/apache?rev=1187711759&do=diff * A word on httpd.conf file * How to use .htaccess and some examples of .htaccess files * URL rewriting with Apache rewrite module (mod_rewrite)