bogdaniel Posted September 24, 2008 Share Posted September 24, 2008 hello please can someone help me with this code.. it doesn't give any error it doesn't says something on var_dump says NULL NULL... <? function formular($stare = 1) { if ($stare == 1) { $x = ''; $y = ''; } else { $x = $_POST['x']; $y = $_POST['y']; } $formular = '<table width="100%" border="0" cellpadding="0" cellspacing="1"> <tr> <td><form name="form1" method="post" action="' . $_SERVER['PHP_SELF'] . '"> </td> </tr> <tr> <td><input name="x" type="text" value="' . $x . '" maxlength="3"> </td> </tr> <tr> <td><input name="y" type="text" value="' . $y . '" maxlength="3"> </td> </tr> <tr> <td><input type="submit" name="Submit" value="Rezerva"> </td> </tr>'; return $formular; } if (!isset($_POST['x'])) { echo formular(1); } else { $x = $_POST['x']; $y = $_POST['y']; $verificare = 0; if (empty($x)) { $verificare = 1; echo '<br>Nu A fost Specificat coordonatul X.'; } if (strlen($x) < 1) { $verificare = 1; echo '<br>Minim 2 caractere.'; } elseif (!eregi('[0-9]{1}', $x)) { $verificare = 1; echo '<br>Coordonatul trebuie sa contima minim 2 caractere.'; } if (empty($y)) { $verificare = 1; echo '<br>Nu A fost Specificat coordonatul X.'; } if (strlen($y) < 1) { $verificare = 1; echo '<br>Minim 2 caractere.'; } elseif (!eregi('[0-9]{1}', $y)) { $verificare = 1; echo '<br>Coordonatul trebuie sa contima minim 2 caractere.'; } if ($verificare == 1) { echo formular(0); } else { $userid = $_SESSION['id']; $result = mysql_query("SELECT DISTINCT x, y FROM ".TBL_REZERVARI." WHERE x = '$x' AND y = '$y' "); if (mysql_numrows($result) >= 1) { exit(); } else { $sql = mysql_query("INSERT INTO ".TBL_REZERVARI." (`user_id`, `x`, `y`, `data`, `expira`, `time`) VALUES ('$userid', '$x', '$x', NOW(), CURDATE() + INTERVAL 3 DAY, CURTIME())") or die('Nu am putut adauga nimic. ' . mysql_error()); //var_dump($_SESSION); $q = mysql_query("SELECT * FROM ".TBL_REZERVARI.""); $num_rows = mysql_num_rows($q); echo "$num_rows Rows\n"; } } } ?> Link to comment https://forums.phpfreaks.com/topic/125666-not-inserting-in-mysql/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.