IF ELSE ELSEIF

[FT3]

vjg parbaudes kodu

 

 

pirms ievietošanas datubaze parbauda

ja tads nosaukums(field) jau eksiste - nepievieno

ja nosaukums(field) neeksiste tad veidojas mysql insert

 

Cerams sapratat :)

[daGrevis]

if( mysql_num_rows( $query ) !== 0 ) {

// Cool stuff comes here... ^__^

}

[bubu]

Nevis mysql_num_rows, bet gan SELECT COUNT(*) ...

[FT3]

nejau taja zina :)

 

piem

 

table sastav no

 

=================

id

homepage

ip

=================

 

es padodu homepage=http://nosukums.lv posts viņš parbauda , ja taja homepage tabula jau ir http://nosukums.lv viņš neko nedara :)

[mefisto]

Nuuuu ... uzliec lai 'homepage' ieraksi ir UNIQUE ( sql pusē ).

[FT3]

what ? ^_^

[EdgarsK]

a nevar vienkarshi insert ignore ?

bet nu ..

 

$query = mysql_fetch_object(mysql_query("select count(id) as cnt from tabula where homepage='http://www.php.lv'"));
if($query->cnt == 0){
mysql_query("insert into table (homepage,ip) values('http://www.php.lv','127.0.0.1')");
}

Edited November 30, 2010 by EdgarsA

[FT3]

$adress = $_SERVER['HTTP_HOST'];
$link = $_SERVER['PHP_SELF'];


$query = mysq_fetch_object(mysql_query("select count(id) as cnt from clients where adress='$adress'"));
if($query->cnt == 0){
mysql_query("insert into clients (adress,link) values ('$adress','$link')");
}

 

Fatal error: Call to undefined function mysq_fetch_object()

[EdgarsK]

$adress = $_SERVER['HTTP_HOST'];
$link = $_SERVER['PHP_SELF'];


$query = mysq_fetch_object(mysql_query("select count(id) as cnt from clients where adress='$adress'"));
if($query->cnt == 0){
mysql_query("insert into clients (adress,link) values ('$adress','$link')");
}

 

 

 

ak dievs.. ak dievs.. bērniņ mīļo, ēd tak no rokām...

cerēju jau ka pats tiksi galā ar šo.

[nikidijs]

Varbūt šādi...

 

$jau_ir=mysql_fetch_array(mysql_query("SELECT * FROM clients WHERE adress=$adress OR link=$link"));
if (!$jau_ir){
mysql_query("INSERT INTO clients(adress,link) VALUES('$adress','$link')"); 
} else {
echo"Šāds lauks jau eksistē !";
}

[Maris-S]

Paskaties šo te:

 

http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

 

domāju ka varēsi pielāgot, ja tas Tev derēs.