别被忽悠了！一个简单数据库php代码，就能让网站活起来

就那些熟悉做网站的人而言, 若想把网站做成动态的, 必然得有数据库加以支持, 借助特定的脚本去跟数据库相连, 接着从数据库里提取资料, 再往数据库里添加资料, 还要对资料库进行删除资料的操作等。在此, 我借由一个实例来讲明怎样运用php去连接到数据库的。我打算着手去构建一个处于简单状态的通讯录, 其数据库所拥有的名字是txl, 这个数据库仅仅存在着一个被称作表的对象, 在该表之中有着5个字段。pi_id首先我们要创建数据库txl;然后我们建立表TABLE (pi_id (20) NOT NULL , (50) NOT NULL, (15) NULL,pi_qq (15) NULL, (50) NULL,KEY (pi_id)) utf8 4 ;上面的sql语句很简单通过字面都能猜出什么意思。下面是连接到数据库并且显示表的所有字段信息// .phpphp$mysql_server_namelocalhost;//数据库服务器名称$mysql_usernameroot;//连接数据库用户名$mysql_passwordroot;//连接数据库密码$mysql_databaselxr;//数据库的名字 // 连接到数据库$connmysql_connect($mysql_server_name,$mysql_username,$mysql_password);//从表中提取信息的sql语句$strsqlselect * from personal_info;//执行sql查询$resultmysql_db_query($mysql_database,$strsql,$conn);//获取查询结果$rowmysql_fetch_row($result);echo;echo[PROTECTED_3a1ba65fb5bfbce73bdbf075b9a284ff]/n;echo;//释放资源 hovertree.commysql_free_result($result);//关闭连接mysql_close();?下面是运行结果pi_id12 Lisi3虽说“万变不离其宗”, 可再繁杂的操作, 皆是依据上面而来的, 都离不开上面那些基本的步骤, 一旦有需要, 去查阅一下相关的手册, 便可将其解决。附参考代码插入操作phpif(!isset($_POST[submit])){//如果没有表单提交显示一个表单?动物名称英文动物名称中文php } else { //如果提交了表单 hovertree.com //数据库连接参数 $host localhost; $user root; $pass zq19890319; $db phpdev; //取得表单中的值检查表单中的值是否符合标准并做适当转义防止SQL注入 $country empty($_POST[country])? die(请输入名称): mysql_escape_string($_POST[country]); $animal empty($_POST[animal])? die(请输入英文名): mysql_escape_string($_POST[animal]); $cname empty($_POST[cname])? die(请输入中文名): mysql_escape_string($_POST[cname]); //打开数据库连接 何问起 $connection mysql_connect($host, $user, $pass) or die(Unable to connect!); //选择数据库 mysql_select_db($db) or die(Unable to select database!); //构造一个SQL查询 $query INSERT INTO symbols(country, animal, cname) VALUE($country, $animal, $cname); //执行该查询 $result mysql_query($query) or die(Error in query: $query. .mysql_error()); //插入操作成功后显示插入记录的记录号 echo 记录已经插入 mysql_insert_id() .mysql_insert_id(); //关闭当前数据库连接 mysql_close($connection); } ?WWw.BdX3.cN/pdds/25148.htmlWWw.BdX3.cN/pdds/25149.htmlWWw.BdX3.cN/pdds/25150.htmlWWw.BdX3.cN/pdds/25151.htmlWWw.BdX3.cN/pdds/25152.htmlWWw.BdX3.cN/pdds/25153.htmlWWw.BdX3.cN/pdds/25154.htmlWWw.BdX3.cN/pdds/25155.htmlWWw.BdX3.cN/pdds/25156.htmlWWw.BdX3.cN/pdds/25157.htmlWWw.BdX3.cN/pdds/25158.htmlWWw.BdX3.cN/pdds/25159.htmlWWw.BdX3.cN/pdds/25160.htmlWWw.BdX3.cN/pdds/25161.htmlWWw.BdX3.cN/pdds/25162.htmlWWw.BdX3.cN/pdds/25163.htmlWWw.BdX3.cN/pdds/25164.htmlWWw.BdX3.cN/pdds/25165.htmlWWw.BdX3.cN/pdds/25166.htmlWWw.BdX3.cN/pdds/25167.htmlWWw.BdX3.cN/pdds/25168.htmlWWw.BdX3.cN/pdds/25169.htmlWWw.BdX3.cN/pdds/25170.htmlhttp://WWw.BdX3.cN/pdsWWw.BdX3.cN/pdds/25171.htmlWWw.BdX3.cN/pdds/25172.htmlWWw.BdX3.cN/pdds/25173.htmlWWw.BdX3.cN/pdds/25174.htmlWWw.BdX3.cN/pdds/25175.htmlWWw.BdX3.cN/pdds/25176.htmlWWw.BdX3.cN/pdds/25177.htmlWWw.BdX3.cN/pdds/25178.htmlWWw.BdX3.cN/pdds/25179.htmlWWw.BdX3.cN/pdds/25180.htmlWWw.BdX3.cN/pdds/25181.htmlWWw.BdX3.cN/pdds/25182.htmlWWw.BdX3.cN/pdds/25183.htmlWWw.BdX3.cN/pdds/25184.htmlWWw.BdX3.cN/pdds/25185.htmlWWw.BdX3.cN/pdds/25186.htmlWWw.BdX3.cN/pdds/25187.htmlWWw.BdX3.cN/pdds/25188.htmlWWw.BdX3.cN/pdds/25189.htmlWWw.BdX3.cN/pdds/25190.htmlWWw.BdX3.cN/pdds/25191.htmlWWw.BdX3.cN/pdds/25192.htmlWWw.BdX3.cN/pdds/25193.htmlWWw.BdX3.cN/pdds/25194.htmlWWw.BdX3.cN/pdds/25195.htmlWWw.BdX3.cN/pdds/25196.htmlWWw.BdX3.cN/pdds/25197.htmlWWw.BdX3.cN/pdds/25198.htmlWWw.BdX3.cN/pdds/25199.htmlWWw.BdX3.cN/pdds/25200.htmlWWw.BdX3.cN/pdds/25201.htmlWWw.BdX3.cN/pdds/25202.htmlWWw.BdX3.cN/pdds/25203.htmlWWw.BdX3.cN/pdds/25204.htmlWWw.BdX3.cN/pdds/25205.htmlWWw.BdX3.cN/pdds/25206.htmlWWw.BdX3.cN/pdds/25207.htmlWWw.BdX3.cN/pdds/25208.htmlWWw.BdX3.cN/pdds/25209.htmlWWw.BdX3.cN/pdds/25210.htmlWWw.BdX3.cN/pdds/25211.htmlWWw.BdX3.cN/pdds/25212.htmlWWw.BdX3.cN/pdds/25213.htmlWWw.BdX3.cN/pdds/25214.htmlWWw.BdX3.cN/pdds/25215.htmlWWw.BdX3.cN/pdds/25216.htmlWWw.BdX3.cN/pdds/25217.htmlWWw.BdX3.cN/pdds/25218.htmlWWw.BdX3.cN/pdds/25219.htmlWWw.BdX3.cN/pdds/25220.htmlWWw.BdX3.cN/pdds/25221.htmlWWw.BdX3.cN/pdds/25222.htmlWWw.BdX3.cN/pdds/25223.htmlWWw.BdX3.cN/pdds/25224.htmlWWw.BdX3.cN/pdds/25225.htmlWWw.BdX3.cN/pdds/25226.htmlWWw.BdX3.cN/pdds/25227.htmlWWw.BdX3.cN/pdds/25228.htmlWWw.BdX3.cN/pdds/25229.htmlWWw.BdX3.cN/pdds/25230.htmlWWw.BdX3.cN/pdds/25231.htmlWWw.BdX3.cN/pdds/25232.htmlWWw.BdX3.cN/pdds/25233.htmlWWw.BdX3.cN/pdds/25234.htmlWWw.BdX3.cN/pdds/25235.htmlWWw.BdX3.cN/pdds/25236.htmlWWw.BdX3.cN/pdds/25237.htmlWWw.BdX3.cN/pdds/25238.htmlWWw.BdX3.cN/pdds/25239.htmlWWw.BdX3.cN/pdds/25240.htmlWWw.BdX3.cN/pdds/25241.htmlWWw.BdX3.cN/pdds/25242.htmlWWw.BdX3.cN/pdds/25243.htmlWWw.BdX3.cN/pdds/25244.htmlWWw.BdX3.cN/pdds/25245.htmlWWw.BdX3.cN/pdds/25246.htmlWWw.BdX3.cN/pdds/25247.htmlWWw.BdX3.cN/pdds/25248.htmlWWw.BdX3.cN/pdds/25249.htmlWWw.BdX3.cN/pdds/25250.htmlWWw.BdX3.cN/pdds/25251.htmlWWw.BdX3.cN/pdds/25252.htmlWWw.BdX3.cN/pdds/25253.htmlWWw.BdX3.cN/pdds/25254.htmlWWw.BdX3.cN/pdds/25255.htmlWWw.BdX3.cN/pdds/25256.htmlWWw.BdX3.cN/pdds/25257.htmlWWw.BdX3.cN/pdds/25258.htmlWWw.BdX3.cN/pdds/25259.htmlWWw.BdX3.cN/pdds/25260.htmlWWw.BdX3.cN/pdds/25261.htmlWWw.BdX3.cN/pdds/25262.htmlWWw.BdX3.cN/pdds/25263.htmlWWw.BdX3.cN/pdds/25264.htmlWWw.BdX3.cN/pdds/25265.htmlWWw.BdX3.cN/pdds/25266.htmlWWw.BdX3.cN/pdds/25267.htmlWWw.BdX3.cN/pdds/25268.htmlWWw.BdX3.cN/pdds/25269.htmlWWw.BdX3.cN/pdds/25270.htmlWWw.BdX3.cN/pdds/25271.htmlWWw.BdX3.cN/pdds/25272.htmlWWw.BdX3.cN/pdds/25273.htmlWWw.BdX3.cN/pdds/25274.htmlWWw.BdX3.cN/pdds/25275.htmlWWw.BdX3.cN/pdds/25276.htmlWWw.BdX3.cN/pdds/25277.htmlWWw.BdX3.cN/pdds/25278.htmlWWw.BdX3.cN/pdds/25279.htmlWWw.BdX3.cN/pdds/25280.htmlWWw.BdX3.cN/pdds/25281.htmlWWw.BdX3.cN/pdds/25282.htmlWWw.BdX3.cN/pdds/25283.htmlWWw.BdX3.cN/pdds/25284.htmlWWw.BdX3.cN/pdds/25285.htmlWWw.BdX3.cN/pdds/25286.htmlWWw.BdX3.cN/pdds/25287.htmlWWw.BdX3.cN/pdds/25288.htmlWWw.BdX3.cN/pdds/25289.htmlWWw.BdX3.cN/pdds/25290.htmlWWw.BdX3.cN/pdds/25291.htmlWWw.BdX3.cN/pdds/25292.htmlWWw.BdX3.cN/pdds/25293.htmlWWw.BdX3.cN/pdds/25294.htmlWWw.BdX3.cN/pdds/25295.htmlWWw.BdX3.cN/pdds/25296.htmlWWw.BdX3.cN/pdds/25297.htmlWWw.BdX3.cN/pdds/25298.htmlWWw.BdX3.cN/pdds/25299.htmlWWw.BdX3.cN/pdds/25300.htmlWWw.BdX3.cN/pdds/25301.htmlWWw.BdX3.cN/pdds/25302.htmlWWw.BdX3.cN/pdds/25303.htmlWWw.BdX3.cN/pdds/25304.htmlWWw.BdX3.cN/pdds/25305.htmlWWw.BdX3.cN/pdds/25306.htmlWWw.BdX3.cN/pdds/25307.htmlWWw.BdX3.cN/pdds/25308.htmlWWw.BdX3.cN/pdds/25309.htmlWWw.BdX3.cN/pdds/25310.htmlWWw.BdX3.cN/pdds/25311.htmlWWw.BdX3.cN/pdds/25312.htmlWWw.BdX3.cN/pdds/25313.htmlWWw.BdX3.cN/pdds/25314.htmlWWw.BdX3.cN/pdds/25315.htmlWWw.BdX3.cN/pdds/25316.htmlWWw.BdX3.cN/pdds/25317.htmlWWw.BdX3.cN/pdds/25318.htmlWWw.BdX3.cN/pdds/25319.htmlWWw.BdX3.cN/pdds/25320.htmlWWw.BdX3.cN/pdds/25321.htmlWWw.BdX3.cN/pdds/25322.htmlWWw.BdX3.cN/pdds/25323.htmlWWw.BdX3.cN/pdds/25324.htmlWWw.BdX3.cN/pdds/25325.htmlWWw.BdX3.cN/pdds/25326.htmlWWw.BdX3.cN/pdds/25327.htmlWWw.BdX3.cN/pdds/25328.htmlWWw.BdX3.cN/pdds/25329.htmlWWw.BdX3.cN/pdds/25330.htmlWWw.BdX3.cN/pdds/25331.htmlWWw.BdX3.cN/pdds/25332.htmlWWw.BdX3.cN/pdds/25333.htmlWWw.BdX3.cN/pdds/25334.htmlWWw.BdX3.cN/pdds/25335.htmlWWw.BdX3.cN/pdds/25336.htmlWWw.BdX3.cN/pdds/25337.htmlWWw.BdX3.cN/pdds/25338.htmlWWw.BdX3.cN/pdds/25339.htmlWWw.BdX3.cN/pdds/25340.htmlWWw.BdX3.cN/pdds/25341.htmlWWw.BdX3.cN/pdds/25342.htmlWWw.BdX3.cN/pdds/25343.htmlWWw.BdX3.cN/pdds/25344.htmlWWw.BdX3.cN/pdds/25345.htmlWWw.BdX3.cN/pdds/25346.htmlWWw.BdX3.cN/pdds/25347.htmlWWw.BdX3.cN/pdds/25348.htmlWWw.BdX3.cN/pdds/25349.htmlWWw.BdX3.cN/pdds/25350.htmlWWw.BdX3.cN/pdds/25351.htmlWWw.BdX3.cN/pdds/25352.htmlWWw.BdX3.cN/pdds/25353.htmlWWw.BdX3.cN/pdds/25354.htmlWWw.BdX3.cN/pdds/25355.htmlWWw.BdX3.cN/pdds/25356.htmlWWw.BdX3.cN/pdds/25357.htmlWWw.BdX3.cN/pdds/25358.htmlWWw.BdX3.cN/pdds/25359.htmlWWw.BdX3.cN/pdds/25360.htmlWWw.BdX3.cN/pdds/25361.htmlWWw.BdX3.cN/pdds/25362.htmlWWw.BdX3.cN/pdds/25363.htmlWWw.BdX3.cN/pdds/25364.htmlWWw.BdX3.cN/pdds/25365.htmlWWw.BdX3.cN/pdds/25366.htmlWWw.BdX3.cN/pdds/25367.htmlWWw.BdX3.cN/pdds/25368.htmlWWw.BdX3.cN/pdds/25369.htmlWWw.BdX3.cN/pdds/25370.htmlWWw.BdX3.cN/pdds/25371.htmlWWw.BdX3.cN/pdds/25372.htmlWWw.BdX3.cN/pdds/25373.htmlWWw.BdX3.cN/pdds/25374.htmlWWw.BdX3.cN/pdds/25375.htmlWWw.BdX3.cN/pdds/25376.htmlWWw.BdX3.cN/pdds/25377.htmlWWw.BdX3.cN/pdds/25378.htmlWWw.BdX3.cN/pdds/25379.htmlWWw.BdX3.cN/pdds/25380.htmlWWw.BdX3.cN/pdds/25381.htmlWWw.BdX3.cN/pdds/25382.htmlWWw.BdX3.cN/pdds/25383.htmlWWw.BdX3.cN/pdds/25384.htmlWWw.BdX3.cN/pdds/25385.htmlWWw.BdX3.cN/pdds/25386.htmlWWw.BdX3.cN/pdds/25387.htmlWWw.BdX3.cN/pdds/25388.htmlWWw.BdX3.cN/pdds/25389.htmlWWw.BdX3.cN/pdds/25390.htmlWWw.BdX3.cN/pdds/25391.htmlWWw.BdX3.cN/pdds/25392.htmlWWw.BdX3.cN/pdds/25393.htmlWWw.BdX3.cN/pdds/25394.htmlWWw.BdX3.cN/pdds/25395.htmlWWw.BdX3.cN/pdds/25396.htmlWWw.BdX3.cN/pdds/25397.htmlWWw.BdX3.cN/pdds/25398.htmlWWw.BdX3.cN/pdds/25399.htmlWWw.BdX3.cN/pdds/25400.htmlWWw.BdX3.cN/pdds/25401.htmlWWw.BdX3.cN/pdds/25402.htmlWWw.BdX3.cN/pdds/25403.htmlWWw.BdX3.cN/pdds/25404.htmlWWw.BdX3.cN/pdds/25405.htmlWWw.BdX3.cN/pdds/25406.htmlWWw.BdX3.cN/pdds/25407.htmlWWw.BdX3.cN/pdds/25408.htmlWWw.BdX3.cN/pdds/25409.htmlWWw.BdX3.cN/pdds/25410.htmlWWw.BdX3.cN/pdds/25411.htmlWWw.BdX3.cN/pdds/25412.htmlWWw.BdX3.cN/pdds/25413.htmlWWw.BdX3.cN/pdds/25414.htmlWWw.BdX3.cN/pdds/25415.htmlWWw.BdX3.cN/pdds/25416.htmlWWw.BdX3.cN/pdds/25417.htmlWWw.BdX3.cN/pdds/25418.htmlWWw.BdX3.cN/pdds/25419.htmlWWw.BdX3.cN/pdds/25420.htmlWWw.BdX3.cN/pdds/25421.htmlWWw.BdX3.cN/pdds/25422.htmlWWw.BdX3.cN/pdds/25423.htmlWWw.BdX3.cN/pdds/25424.htmlWWw.BdX3.cN/pdds/25425.htmlWWw.BdX3.cN/pdds/25426.htmlWWw.BdX3.cN/pdds/25427.htmlWWw.BdX3.cN/pdds/25428.htmlWWw.BdX3.cN/pdds/25429.htmlWWw.BdX3.cN/pdds/25430.htmlWWw.BdX3.cN/pdds/25431.htmlWWw.BdX3.cN/pdds/25432.htmlWWw.BdX3.cN/pdds/25433.htmlWWw.BdX3.cN/pdds/25434.htmlWWw.BdX3.cN/pdds/25435.htmlWWw.BdX3.cN/pdds/25436.htmlWWw.BdX3.cN/pdds/25437.htmlWWw.BdX3.cN/pdds/25438.htmlWWw.BdX3.cN/pdds/25439.htmlWWw.BdX3.cN/pdds/25440.htmlWWw.BdX3.cN/pdds/25441.htmlWWw.BdX3.cN/pdds/25442.htmlWWw.BdX3.cN/pdds/25443.htmlWWw.BdX3.cN/pdds/25444.htmlWWw.BdX3.cN/pdds/25445.htmlWWw.BdX3.cN/pdds/25446.htmlWWw.BdX3.cN/pdds/25447.htmlWWw.BdX3.cN/pdds/25448.htmlWWw.BdX3.cN/pdds/25449.htmlWWw.BdX3.cN/pdds/25450.htmlWWw.BdX3.cN/pdds/25451.htmlWWw.BdX3.cN/pdds/25452.htmlWWw.BdX3.cN/pdds/25453.htmlWWw.BdX3.cN/pdds/25454.htmlWWw.BdX3.cN/pdds/25455.htmlWWw.BdX3.cN/pdds/25456.htmlWWw.BdX3.cN/pdds/25457.htmlWWw.BdX3.cN/pdds/25458.htmlWWw.BdX3.cN/pdds/25459.htmlWWw.BdX3.cN/pdds/25460.htmlWWw.BdX3.cN/pdds/25461.htmlWWw.BdX3.cN/pdds/25462.htmlWWw.BdX3.cN/pdds/25463.htmlWWw.BdX3.cN/pdds/25464.htmlWWw.BdX3.cN/pdds/25465.htmlWWw.BdX3.cN/pdds/25466.htmlWWw.BdX3.cN/pdds/25467.html