php操作mysql數(shù)據(jù)庫
<?php
$link=mysql_connect("localhost","root","root");
if($link){
? }else{
?echo?"連接失敗";
?exit;
??? }
mysql_select_db("test");
$sql="create table shops(id int auto_increment not null,name varchar(30) not null, price double not null default '0.00', num int not null default '0', primary key(id),key(name,price))";
//$sql2="alter table shops add desn varchar(64) after price";
$sql2="insert into shops(name,price,desn,num)values('php',10,'php hello',5)";
$sql3="delete from shops where id<15";
$res=mysql_query($sql3);
if($res){
? }else{
?echo?mysql_errno().":".mysql_error()."/n";
??? }
if(mysql_affected_rows()>0){
?echo?"執(zhí)行成功:"."影響行數(shù)".mysql_affected_rows()."最后自動增長的ID=".mysql_insert_id();
? }else{
?echo?"記錄沒有改變";
??? }
mysql_close();
?>
從結(jié)果集將記錄取出來
mysql_fetch_row($res)?索引數(shù)組
mysql_fetch_assoc($res)?關(guān)聯(lián)數(shù)據(jù)
mysql_fetch_array($res)?索引和關(guān)聯(lián)
mysql_fetch_object($res)?對象
自我復制
insert into products(cid,name,price,num,desn,ptime)select cid,name,price,num,desn,ptime from products;
