php / "Красота кода"
$mq = mysql_connect("localhost", "user", "pass");
mysql_select_db("name_db");
$str = "username=vasya; userpass=1234; age=34";
$ex = explode("; ", $str);
foreach ($ex as $exp) {
$expl = explode("=", $exp);
if ($expl[0]=="username") { $username = $expl[1];}
if ($expl[0]=="userpass") { $userpass = $expl[1];}
if ($expl[0]=="age") { $age = $expl[1];}
}
$sql = "SELECT username FROM `name_db` WHERE username='$username'";
$result = mysql_query($sql);
for ($data=array(); $row = mysql_fetch_assoc($result); $data[]=$row);
if (!isset($data['username'])){
$sql_i = "INSERT INTO `name_db` VALUES ('$username', '$userpass', '$age')";
$result_i = mysql_query($sql_i);
} else {
$sql_u = "UPDATE `name_db` SET userpass='$userpass', age='$age' WHERE username='$username'";
$result_u = mysql_query($sql_u);
}
Самое интересное здесь (не для слобонервных)
http://pyha.ru/forum/topic/1483.0
2008-12-05 01:49:56



admin, over 3 years ago