SQLite Tutorial in PHP
SQLite Tutorial in PHP
SQLite is an SQL database manager used locally or on a website, and compatible
in particularly with PHP.
Summary
Installing SQLite and creating a database
.
Installing SQLite. Verifying the installation by creating a base.
Creating and using a SQLite table
.
Creating a table. Deleting a table. Adding a record. Reading a record.
How to find and update a post
.
Filling a database. Dump of the whole base. Finding a record by ID. Searching a post. Updating a post.
Download
The complete source code of the scripts
in a ZIP archive.
More
SQLite and multi-users. How to treat concurrency issue with SQLite
.
Ïà¹ØÎĵµ£º
ƽʱÓà htmlspecialchars() À´¹ýÂËhtml, µ«ÊǰÑhtmlµÄ×Ö·ûתÒåÁË,×îºóÏÔʾ³öÀ´µÄ¾ÍÊÇhtmlÔ´´úÂë, ÀûÓÃstrip_tags()¾Í¿ÉÒÔ°Ñhtml±êǩȥ³ýµô.
[php]
$str = 'harryxu
‘;
echo(htmlspecialchars($str) . ‘
‘);
echo(strip_tags($str));
// output:
// harryxu
// harryxu
?>
......
Èç¹ûËùÓеÄClass¶¼Ó¦¸Ã´æÔÚÓÚÒ»¸öĬÈϵIJ㼶Öеϰ£¬ÄÇô×î¶¥²ãÓ¦¸ÃÊÇ×îΪһ°ãµÄClass£¬Ò²¾ÍÊÇ˵¼«Îª³éÏóµÄ£¬Ã¿Ò»¸öϲãµÄClass¾ù±ÈÆäÉϲã
µÄClass£¨¼´¸¸Àࣩ¸ü¼ÓרÃÅ»¯¡£»ùÓÚ¸Ã˼Ï룬ÔÚPHPÖУ¬Õâ¸ö¶¥²ãµÄClass±»ÃüÃûΪ“stdClass”£¬ÇÒ×÷Ϊһ¸ö“Standard
Class”£¬Äã¿ÉÒÔ°ÑËü¿´³ÉÊÇÒ ......
function get_web_page( $url )
{
$options = array(
CURLOPT_RETURNTRANSFER => true, // return web page ·µ»ØÍøÒ³
CURLOPT_HEADER => false, // ²»·µ»ØÍ·ÐÅÏ¢
CURLOPT_FOLLOWLOCATION => true, ......
PHPµÄ·¢Õ¹
PHP Ô±¾µÄ¼ò³ÆÎª Personal Home Page£¬ÊÇRasmus Lerdorf ΪÁËҪά»¤¸öÈËÍøÒ³£¬¶øÓÃcÓïÑÔ¿ª·¢µÄһЩCGI¹¤¾ß³ÌÐò¼¯£¬À´È¡´úÔÏÈʹÓÃµÄ Perl ³ÌÐò¡£×î³õÕâЩ¹¤¾ß³ÌÐòÓÃÀ´ÏÔʾ Rasmus Lerdorf µÄ¸öÈËÂÄÀú£¬ÒÔ¼°Í³¼ÆÍøÒ³Á÷Á¿¡£Ëû½«ÕâЩ³ÌÐòºÍһЩ±íµ¥Ö±ÒëÆ÷ÕûºÏÆðÀ´£¬³ÆÎª PHP ......