Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $qurum = explode('|', $qurum1);//1|2|6
- foreach ($qurum as $value) {
- $idareid = 'idare'.$value;
- if (table_exists($idareid)) {
- $sql = "SELECT qurum1 FROM data WHERE id = $id";//1|2|3
- $res = mysql_query($query);
- $get_qur = array();
- $get_qur = mysql_fetch_assoc($res);
- $get_q = explode('|', $get_qur);//1|2|3
- foreach ($get_q as $k => $v) {
- if (in_array($v, $qurum)) {
- $mysql = "UPDATE ".$idareid." SET data_num = '$data_num',
- input_date = '$input_date' WHERE data_id = $id";
- $result = mysql_query($mysql) or die("O ".mysql_error());
- } else {
- $query = "DELETE FROM idare".$v." WHERE data_id = $id";
- $r = mysql_query($query) or die("w ".mysql_error());
- $mysql2 = "INSERT INTO ".$idareid." (data_id, data_num, input_date) VALUES
- ('$id', '$data_num', '$input_date')";
- $result2 = mysql_query($mysql2) or die("i ".mysql_error());
- }
- }
- } else {
- $q = "CREATE TABLE IF NOT EXISTS ".$idareid." ( " . $idareid . "_id tinyint(4)
- UNSIGNED NOT NULL AUTO_INCREMENT, `data_id` int(10) UNSIGNED NOT NULL, `data_num`
- varchar(255) NOT NULL, `input_date` date NOT NULL, PRIMARY KEY(" . $idareid ."_id))
- ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
- $res2 = mysql_query($q) or die("b ".mysql_error());
- $query2 = "INSERT INTO ".$idareid." (data_id, data_num, input_date) VALUES
- ('$id', '$data_num', '$input_date')";
- $res3 = mysql_query($query2) or die("k".mysql_error());
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement