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);
?>
Ïà¹ØÎĵµ£º
¹ØÓÚphpÓ¦¸ÃÔÚºÎʱµ÷ÓÃmysql_close()ÒÔ¼°pconnect·½Ê½ºÍ´«Í³·½Ê½ÓкÎÖÖÇø±ðÊÕ²Ø
ÒÔǰÎÒÒ»Ö±ÈÏΪ£¬µ±phpµÄÒ³ÃæÖ´ÐнáÊøÊ±£¬»á×Ô¶¯ÊͷŵôÒ»ÇС£ÏàÐźܶàÈ˶¼¸úÎÒÏëµÄÒ»Ñù¡£µ«ÊÂʵ֤Ã÷²¢²»ÊÇÕâÑù¡£±ÈÈçsession¾Í²»»áËæ×ÅÒ³ÃæÖ´ÐÐÍê±Ï¶øÊÍ·Å¡£
phpµÄÀ¬»ø»ØÊÕ»úÖÆ£¬ÆäʵֻÕë¶ÔÓÚphp±¾Éí¡£¶ÔÓÚmysql£¬phpûȨÀûÈ¥×Ô¶¯È¥ÊÍ·ÅËüµÄ ......
Ïà¹Ø²ÎÊý£º<textarea name=content>
Ä£°åµ÷Ó÷û£º$
¡¡¡¡Ìá½»ÐÂ±íµ¥µÄʱºòÓÃÈçÏ´úÂ룬½á¹ûÍêÈ«Õý³££º
<form name="frm_HelpMessageAdd" id="frm_HelpMessageAdd" action="manage.php" method="POST" enctype="multipart/form-data">
<input name="content" type="hidden" id="shopProduct_Intro"& ......
¼ò ½é
PHPÈ¡µÃ³É¹¦µÄÒ»¸öÖ÷ÒªÔÒòÖ®Ò»ÊÇËýÓµÓдóÁ¿µÄ¿ÉÓÃÀ©Õ¹¡£web¿ª·¢ÕßÎÞÂÛÓкÎÖÖÐèÇó£¬ÕâÖÖÐèÇó×îÓпÉÄÜÔÚPHP·¢ÐаüÀïÕÒµ½¡£PHP·¢Ðаü°üÀ¨Ö§³Ö¸÷ÖÖÊý¾Ý¿â£¬Í¼ÐÎÎļþ¸ñʽ£¬Ñ¹Ëõ£¬XML¼¼ÊõÀ©Õ¹ÔÚÄÚµÄÐí¶àÀ©Õ¹¡£
À©Õ¹APIµÄÒýÈëʹPHP3È¡µÃÁ˾޴óµÄ½øÕ¹£¬À©Õ¹API»úÖÆÊ¹PHP¿ª·¢ÉçÇøºÜÈÝÒ׵Ŀª·¢³ö¼¸Ê®ÖÖÀ©Õ¹¡£ÏÖÔÚ£¬Á½¸ ......