Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

php+mysqlÖеÄһЩÓï¾ä

mysql½¨Á¢Ò»¸ö±í¸ñ£º
create table hyhtbsc(
id int(4) primary key auto_increment,
username varchar(20),
password varchar(20)
);
²éѯÊý¾Ý¿âÄÚÈÝ£º
<?php
$conn = mysql_connect("localhost","root","pass");
mysql_select_db("mydb",$conn);
$sql = "select * from mytable";
$result = mysql_query($sql,$conn);
while($row = mysql_fetch_array($result)){
echo "<td>".$row['myfield']."</td>";
}
mysql_free_result($result);
mysql_close($conn);
?>
Ìí¼ÓÊý¾Ý¿âÄÚÈÝ£º
<?php
$id=trim($_POST['id']);
$conn = mysql_connect("localhost","root","pass");
mysql_select_db("mydb", $conn);
if($id != ''){
$sql="INSERT INTO ggs_chapter (id) VALUES ('".$book_id."')";
mysql_query($sql,$conn);

echo 'Ìí¼Ó³É¹¦£¡';
}
?>
<form name="add_book" action="" method="post">
<table>
<tr><td>
<select name="id">
<?php
$sql="select * from table";
$result=mysql_query($sql,$conn);
while($row = mysql_fetch_array($result)){
echo "<option value=\"".$row['id']."\">".$row['name']."</option>";
}
mysql_free_result($result);
mysql_close($conn);
?>


Ïà¹ØÎĵµ£º

²éѯmysqlµ±Ç°Á¬½ÓÊý

1.show status
   Threads_connected  µ±Ç°µÄÁ¬½ÓÊý
   Connections  ÊÔͼÁ¬½Óµ½(²»¹ÜÊÇ·ñ³É¹¦)MySQL·þÎñÆ÷µÄÁ¬½ÓÊý¡£
   Max_used_connections  ·þÎñÆ÷Æô¶¯ºóÒѾ­Í¬Ê±Ê¹ÓõÄÁ¬½ÓµÄ×î´óÊýÁ¿¡£
2.set GLOBAL max_connections=Á¬½ÓÊý; 
   flush privilege ......

MYSQLÒýÇæ

×òÌìºÍͬѧÏÐÁÄʱ,̸µ½ÁËÊý¾Ý¿âµÄÒýÇæÊÇʲô,½ñÌìÔÚÍøÉÏËÑË÷Á˺ܾÃ,ҲûÓз¢ÏֱȽÏÈ«ÃæµÄ˵Ã÷¸÷¸öÊý¾Ý¿âµÄËÑË÷ÒýÇæ·½ÃæµÄ.
MySQLÒýÇæÊÇʲô,
MySQLÊÇÎÒÃDZȽϳ£ÓõÄÒ»ÖÖÊý¾Ý¿âÈí¼þ¡£ËüÓÐ×ÅÖî¶àµÄÓŵ㣬È翪ԴµÄ£¬Ãâ·ÑµÄµÈµÈ¡£ÆäʵËü»¹ÓÐÒ»¸öºÜºÃµÄÌØµã£¬ÄǾÍÊÇÓжàÖÖÒýÇæ¿ÉÒÔ¹©ÄãÑ¡Ôñ¡£Èç¹ûÈü³µÊÖÄܸù¾Ý²»Í¬µÄ·¿ö£¬µØÐÎ ......

mysql´ò¿ªÂý²éѯÈÕÖ¾

±à¼­my.cnfÎļþ£¬¼ÓÈ룺
log-slow-queries[=file]    #ĬÈÏΪdataĿ¼ÏµÄhostname-slow.logÎļþ
long_query_time=10   (seconds)   #Âý²éѯµÄthreshold
log-queries-not-using-indexes   #¼Ç¼²»Ê¹ÓÃË÷ÒýµÄ²éѯ
mysqldumpslowÃüÁî»ñµÃÈÕÖ¾ÖÐÏÔʾµÄ²éѯժҪÀ´´¦ÀíÂý²éÑ¯È ......

PHP×Ö·û´®½Ì³Ì_trimº¯Êý

 
PHP trim() º¯Êý
¶¨ÒåºÍÓ÷¨
trim() º¯Êý´Ó×Ö·û´®µÄÁ½¶Ëɾ³ý¿Õ°××Ö·ûºÍÆäËûÔ¤¶¨Òå×Ö·û¡£
Óï·¨
trim(str,charlist)
 ²ÎÊý 1 strΪ´ý²Ù×÷µÄ×Ö·û´®£¬²ÎÊý 2 charlist ¿ÉÑ¡£¬Ö¸¶¨ÁËÏëҪȥ³ýµÄÌØÊâ·ûºÅ¡£
Èç¹ûµÚ¶þ¸ö²ÎÊýû¸øÖµ£¬Ô¤Éè»áÈ¥³ýÏÂÁÐÕâЩ×ÖÔª£º 
" " (ASCII 32&nbs ......

PHPÊý¾Ý¿âµÄ²Ù×÷


1. ½¨Á¢ºÍ¹Ø±ÕÁ¬½Ó
1) mysql_connect()
    resource mysql_connect([string hostname [:port][:/path/to/socket][,string username] [,string password]])
    ËùÓвÎÊý¶¼ÊÇ¿ÉÑ¡µÄ
    ¾ÙÀý:
    @mysql_connect("localhost", "user", "password")
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ