Файл: phpfile/vstavit_recept.php
Строк: 47
<?php
$querypp = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sqlpp = mysql_query($querypp) or die(mysql_error()) ;
$row = mysql_fetch_assoc($sqlpp) ;
$query = "SELECT *
FROM `rukzak`WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"' and `odeto`='0' and `chit`='recept' and `idrukzak`='" . mysql_real_escape_string($_GET['vesh']) .
"'
LIMIT 1" ;
$sql = mysql_query($query) or die(mysql_error()) ;
$k = mysql_num_rows($sql) ;
if ($k == 0)
{
print "<div class="style_mess_no">Ошибка запроса!(01)</div>" ;
exitt($row,$opredelenie) ;
}
$row_recept = mysql_fetch_assoc($sql) ;
$query00 = "SELECT *
FROM `rukzak`WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"' and `odeto`='0' and `idrukzak`='" . mysql_real_escape_string($_POST['sex1']) .
"' and `vstavlen`='0'
LIMIT 1" ;
$sql00 = mysql_query($query00) or die(mysql_error()) ;
$k = mysql_num_rows($sql00) ;
if ($k == 0)
{
print "<div class="style_mess_no">Ошибка запроса!</div>" ;
exitt($row,$opredelenie) ;
}
$row_vesh = mysql_fetch_assoc($sql00) ;
//выбор рецепта
$queryp = "SELECT * FROM `recept` WHERE `number`='".$row_recept['tip']."' " ;
$sqlp = mysql_query($queryp) or die(mysql_error()) ;
$rowpotroha = mysql_fetch_assoc($sqlp) ;
mysql_query("update `rukzak` set `nazvanie`='".$rowpotroha['name_v']."',`table`='".$rowpotroha['table']."',
`try`='100',`butik`='1',`rus_par`='".$rowpotroha['rus_par']."' where `idrukzak`='".$row_vesh['idrukzak']."' ") or die(mysql_error()) ;
print "<div class="chat_conteiner">Вы создали ".$rowpotroha['name_v']."</div>" ;
/* mysql_query("INSERT INTO `log_recept`(`id` ,
`name` ,
`id_log` ,
`name_log` ,
`if` ,
`result` ,
`new_id_log`
)
VALUES (NULL , '$opredelenie', '".$row_recept['idrukzak']."',
'".$row_recept['nazvanie']."', '', ', '".$row_vesh['idrukzak']."'
);")or die(mysql_error());
*/
mysql_query("DELETE FROM `rukzak` WHERE `idrukzak` = '" .$row_recept['idrukzak']. "' and `name`='" .
mysql_real_escape_string($opredelenie) . "' and `odeto`='0' LIMIT 1 ;") or die(mysql_error
()) ;
exitt($row,$opredelenie);
?>