¼¸ÖÖ³£ÓÃPHPÁ¬½ÓÊý¾Ý¿âµÄ´úÂë
PHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓMYSQLÊý¾Ý¿â´úÂë < ?php
$mysql_server_name='localhost';
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿â·þÎñÆ÷
$mysql_username='root';
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÓû§Ãû
$mysql_password='12345678';
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÃÜÂë
$mysql_database='mycounter';
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÃû
$conn=mysql_connect($mysql_server_name,
$mysql_username,$mysql_password,
$mysql_database);
$sql='CREATE DATABASE mycounter
DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
';
mysql_query($sql);
$sql='CREATE TABLE `counter`
(`id` INT(255) UNSIGNED NOT NULL
AUTO_INCREMENT ,`count` INT(255)
UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY
( `id` ) ) TYPE = innodb;';
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
//echo $sql;
mysql_close($conn);
echo "Hello!Êý¾Ý¿âmycounterÒѾ³É¹¦½¨Á¢£¡";
?>
¸´ÖÆ´úÂëPHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓACCESSÊý¾Ý¿â´úÂë·½·¨ < ?
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft
Access Driver (*.mdb)};
DBQ=". realpath("data/db.mdb");
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select *
from szd_t",$conn,1,1);
while(! $rs->eof) {
$f = $rs->Fields(1);
echo $f->value;
$rs->MoveNext();
}
?>
¸´ÖÆ´úÂëPHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓMS SQLÊý¾Ý¿â´úÂë·½·¨
1.°²×°SQL·þÎñÆ÷²¢Ìí¼ÓPHPµÄMSSQLÀ©Õ¹
2.ʹÓÃÒÔÏ´úÂëÁ¬½Ó²¢²âÊÔ < ?php
$myServer = localhost; //Ö÷»ú
$myUser = sa; //Óû§Ãû
$myPass = password; //ÃÜÂë
$myDB = Northwind; //MSS
Ïà¹ØÎĵµ£º
¡¡¡¡“¼¼ÊõÎÊÌâ¶¼ÊÇ¿ÉÒÔ½â¾öµÄ£¬¼¼ÊõÎÊÌâ²»ÊÇ×î×îÖØÒªµÄ”
¡¡¡¡ ×î½ü°ï¹ýһЩÈ˽â¾ö¼¼ÊõÎÊÌ⣬·¢ÏÖÒ»¸öºÜÑÏÖØµÄÎÊÌ⣬ËûÃǵÄ×ö·¨ºÍÎÒ×ʼд³ÌÐòµÄʱºòÊÇÒ»ÑùµÄ£¬ÕâÑùÏÂÈ¥»á×ߺöàµÄÍä·¡£ÏÖÔÚÓÐÒ»Àà³ÌÐòԱ̫¶à£¬ËûÃÇ×ÜÊÇһζµÄ×·Çó“ËùνµÄ¼¼ÊõÄѵ㔣¬×ÜÊǰÑÐÄÊ·ÅÔÚһЩ±ß±ß½Ç½ÇµÄ“³ÌÐò´úÂë ......
1 ÔÚSQLÓï¾äÖпÉͨ¹ýÌí¼ÓÏÞÖÆÌõ¼þ:left(text,20)ֻȡtextÎı¾µÄǰ20¸ö×Ö;
¡¡¡¡2 ¿ÉÒÔÓÃlimit fromRecord, RecordNum À´×÷Ϊ·ÖҳʹÓÃ,±ÈÈçlimit 0,30±íʾ´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼±éÀú30¸ö¼Í¼;
¡¡¡¡3 Á½¸ö±íµÄÁ¬½Ó¿ÉÒÔÊÇ£ºtable1 join table2 using x(xΪÁ½¸ö±íµÄ¹«¹²×Ö¶Î),»òÕßÊÇtable1 join table2 on table1.x = table2.x
¡¡¡ ......
HTML:
<META HTTP-EQUIV="pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache, must-revalidate">
<META HTTP-EQUIV="expires" CONTENT="Wed, 26 Feb 1997 08:21:57 GMT">
<META HTTP-EQUIV="expires" CONTENT="0">
PHP£º
header("Expires: Mon, 26 Jul 1997 ......
1. ´´½¨Ë÷Òý
$ sudo /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf --all
Sphinx 0.9.7
Copyright (c) 2001-2007, Andrew Aksyonoff
using config file '/usr/local/etc/sphinx.conf'...
indexing index 'catalog'...
collected 8 docs, 0.0 MB
sorted 0.0 Mhits, 82.8% done
total 8 docs, 149 byt ......
PHPÌṩÁ½¸ö·½±ãÎÒÃÇÒýÓÃÊý¾ÝµÄħ·¨ÒýÓú¯Êýmagic_quotes_gpcºÍmagic_quotes_runtime£¬ÕâÁ½¸öº¯ÊýÈç¹ûÔÚphp.iniÉèÖÃΪONµÄʱºò£¬¾Í»áΪÎÒÃÇÒýÓõÄÊý¾ÝÅöµ½µ¥ÒýºÅ'ºÍË«ÒýºÅ"ÒÔ¼°·´Ð±Ïß \ ÊÇ×Ô¶¯¼ÓÉÏ·´Ð±Ïߣ¬°ïÎÒÃÇ×Ô¶¯×ªÒë·ûºÅ£¬È·±£Êý¾Ý²Ù×÷µÄÕýÈ·ÔËÐУ¬¿ÉÊÇÎÒÃÇÔÚphp²»Í¬µÄ°æ±¾»òÕß²»Í¬µÄ·þÎñÆ÷ÅäÖÃÏ£¬ÓеÄmagic_quotes_g ......