PHPÖУ¬Ê¹ÓÃmysqlÊý¾Ý¿â,Linuxϵͳ¡£
ÔÚʹÓÃËÑË÷¹¦ÄÜʱ£¬Ö±½ÓÖ´ÐÐÕâÑùµÄÓï¾ä°²È«Âð£¿
$keyword=$_POST["keyword"];
$sql="select * from abc where a_name like '%$keyword%'";
$rs=mysql_query($sql);
.....
Èç¹û²»°²È«£¬Ó¦¸ÃÔõô¹ýÂË£¿Ð»Ð»
²»ÊÇ×ö¿ª·¢µÄ ¶ÔÕâ¸ö²»ÊìϤ
$keyword = trim($ke ......
ÎÒ×¢²áµÄÍøÕ¾Ê¹ÓÃPhpMyadmin×÷Ϊ¹ÜÀíÆ÷
ÏÔʾ ·þÎñÆ÷: hostingdb.limedomains.com via TCP/IP
ÇëÎÊÎÒÔÚPHPÖÐÈçºÎÌîд$server
Õâ¸ö²»¾ÍÊÇÓòÃûÂ𣨿ÉÄÜÊDZ¾µØÓòÃû£©
Ö±½ÓÓÃhostingdb.limedomains.com·ÃÎʾÍÊÇÁË ¾Í¸úÔÚÄã×Ô¼ºµÄ»úÆ÷ÉÏʹÓÃlocalhostÁ¬½ÓÒ»Ñù
ÔÙ˵Äã×¢²áµÄÄǸöÍøÕ¾ ÄãÔõô²»ÎÊһϿͻ§ÔõôÁ¬½ÓÊ ......
PHP code:
<?php
include("config.inc.php");
$db=new db();
echo date('h:i:s') . "<br />";
$db->execute("begin");
$rs=$db->getRs("select * from book where sum>0 and id =1");
sleep(5);
if($rs->rowCount())//Èç¹û´æÔڿɽèµÄÊé¼®
$d ......
int
varchar
text
date
³¤¶È/Öµ1
Õâ¸ö³¤¶ÈÖµÊÇʲôÒâ˼£¿£¿
±ÈÈçÎÒ varchar ÉèÖÃ10000 ÊDz»ÊǾÍÊÇÒ»Íò¸ö×Ö·û£¿£¿£¿
int 10000¾ÍÊǵ½1Íò£¿£¿£¿
Äܲ»ÄÜÏêϸ½âÊÍÏÂ
ÔÎ varchar×ֻÄÜÊÇ255 ÄãÄÜÉèÖÃ10000£¿
¿´¿´Õâ¸ö²©¿Í רÃŽ²Mysql×ֶγ¤¶ÈµÄ
http://blog.csdn.net/abaowu/ ......
ÔÚÒ»¸ö½Ì³ÌÉÏ¿´µ½ÈçÏ´úÂ룺
$db = 'samples';
mysql_select_db($db) or die('Could not select database ('.$db.') because of : '.mysql_error());
echo ' <b>µÚ¶þ²½: </b> ³É¹¦Á¬½Óµ½ ('.$db.') ! <BR>';
......
ÇëÎʸßÊÖ£¬ Perl Á¬½ÓMySQLʱ£¬Óï¾äÈçÏ£º
use DBI;
my $dbh = DBI->connect("dbi:mysql:testsql:localhost,port=3306","root","abc");
print "success";
$dbh->disconnect;
µ«ÊÇÔÚ±àÒëʱ»áÓöµ½ÈçÏ´íÎóÌáʾ£º
install_driver(mysql) failed: C ......