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);
?>
Ïà¹ØÎĵµ£º
Ò»¡¢¿ª·¢³ÉÔ±
a)ÏîÄ¿Ö÷¹Ü
b)Ò³ÃæÃÀ¹¤
c)Ò³Ã濪·¢
d)·þÎñ¶Ë³ÌÐò¿ª·¢
e)ϵͳÓëÊý¾Ý¹ÜÀí
f)²âÊÔÓë°æ±¾¿ØÖÆ
¶þ¡¢ ÍøÕ¾×鿪·¢¼òÃ÷Á÷³Ì
Èý¡¢ ¿ª·¢¹¤¾ßÓë»·¾³
a)·þÎñÆ÷ÅäÖÃ
i. WEB·þÎñÆ÷£º FreeBSD6.1+Apache2.0+PHP5.0£¬SVN°æ±¾¿ØÖÆ·þÎñ(½ö²âÊÔ»ú)¡£
ii.Êý¾Ý¿â·þÎñÆ÷£º WIN2003 server+SQL server 2000+MySQL5.0£¬CLUS ......
1. ½¨Á¢ºÍ¹Ø±ÕÁ¬½Ó
1) mysql_connect()
resource mysql_connect([string hostname [:port][:/path/to/socket][,string username] [,string password]])
ËùÓвÎÊý¶¼ÊÇ¿ÉÑ¡µÄ
¾ÙÀý:
@mysql_connect("localhost", "user", "password")
......
<?php
/*
* Created on 2008-10-25
*
* developer by Alex.do QQ:20779512
* PHP 5.0
*/
class mdbClass {
var $dbPath = 'database/#123123#.mdb'; //Êý¾Ý¿â·¾¶
var $tabName; & ......
PHP Ϊʲôfunction ÔÚÉùÃ÷ʱûÓÐÉùÃ÷²ÎÊý,¶øµ÷ÓÃʱ¼ÓN¸ö²ÎÊýÈ´ÊÇÔÊÐíµÄ
2008-11-13 20:14:38 ÆäËû | ÆÀÂÛ(7) | ä¯ÀÀ(721)
ÈçÌâ
//ÉùÃ÷
function test(){};
$a = '';
$b = '';
$c = '';
//µ÷ÓÃ
test($a,$b,$c,1,2,3);
ÏàÐŲ»ÉÙÐֵܽãÃÃÒ²Ôø¾Óöµ½Í¬ÑùµÄÎÊÌâ¡£
why?
¸Õ¿ªÊ¼ÎÒÒ²Í¦Ó ......
Ïà¹Ø²ÎÊý£º<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"& ......