Inscrieri in DB la fiecare reload
Last Updated: Aug 02 2016 15:44, Started by
Dima1994
, Aug 02 2016 14:17
·
0
#1
Posted 02 August 2016 - 14:17
Salut baieti ! Va descriu problema apoi mai jos va da materialul. Am facut o pagina web ep care este o forma ce transmite inscrierile catre baza de date. Dar nustiu de ce la fiecare reload page datele se tranmit in baza , fara a apasa butonul trimite.
codul formei : <form name="rezervare" method="POST"> <h2>Rezervari Bilete Online</h2> <select name="oras_plecare"> <option value="0" selected>Orasul de Plecare</option> <option value="CHISINAU" name="oras_pornire">CHISINAU</option> <option value="ROSTOCK" name="oras_pornire">ROSTOCK</option> <option value="STRALSUND" name="oras_pornire">STRALSUND</option> <option value="LUBECK" name="oras_pornire">LUBECK</option> <option value="BREMEN" name="oras_pornire">BREMEN</option> <option value="HANNOVER" name="oras_pornire">HANNOVER</option> <option value="LEIPZIG" name="oras_pornire">LEIPZIG</option> <option value="FRANKFURT" name="oras_pornire">FRANKFURT</option> <option value="STUTTGART" name="oras_pornire">STUTTGART</option> <option value="SCHWERIN" name="oras_pornire">SCHWERIN</option> <option value="MUNICH" name="oras_pornire">MUNICH</option> <option value="TEPLICE" name="oras_pornire">TEPLICE</option> <option value="KARLOVY VARY" name="oras_pornire">KARLOVY VARY</option> <option value="PILSEN" name="oras_pornire">PILSEN</option> <option value="SALZBURG" name="oras_pornire">SALZBURG</option> <option value="BUCURESTI" name="oras_pornire">BUCURESTI</option> <option value="PRAGA" name="oras_pornire">PRAGA</option> </select> <select name="oras_destinatie"> <option value="0" selected>Orasul de Destinatie</option> <option value="CHISINAU">CHISINAU</option> <option value="ROSTOCK">ROSTOCK</option> <option value="STRALSUND">STRALSUND</option> <option value="LUBECK">LUBECK</option> <option value="BREMEN">BREMEN</option> <option value="HANNOVER">HANNOVER</option> <option value="LEIPZIG">LEIPZIG</option> <option value="FRANKFURT">FRANKFURT</option> <option value="STUTTGART">STUTTGART</option> <option value="SCHWERIN">SCHWERIN</option> <option value="MUNICH">MUNICH</option> <option value="TEPLICE">TEPLICE</option> <option value="KARLOVY VARY">KARLOVY VARY</option> <option value="PILSEN">PILSEN</option> <option value="SALZBURG">SALZBURG</option> <option value="BUCURESTI">BUCURESTI</option> <option value="PRAGA"">PRAGA</option> </select> <input type="text" maxlength="10" id="datepicker" name="data_plecare" value="Data de Plecare"> <select name="numar_persoane"> <option value="0" selected>Numarul de Persoane</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5+</option> </select> <input type="text" maxlength="60" name="nume_prenume" value="Numele dvs. Complet"> <input type="text" maxlength="60" name="telefon" value="Telefonul dvs. de Contact"> <input type="text" maxlength="60" name="email" value="E-mail"> <button type="submit">» REZERVA ACUM «</button> </form> Si mai jos urmeaza portiunea de cod php : <?php $oras_plecare = $_REQUEST['oras_plecare']; $oras_destinatie = $_REQUEST['oras_destinatie']; $data_plecare = $_REQUEST['data_plecare']; $numar_persoane = $_REQUEST['numar_persoane']; $nume_prenume = $_REQUEST['nume_prenume']; $telefon = $_REQUEST['telefon']; $email = $_REQUEST['email']; $insert_sql = "INSERT INTO Rezervari (Oras_Pornire, Oras_Destinatie, Data_Pornire, Numar_Persoane, Nume_Prenume, Telefon, Email)" . "VALUES('{$oras_plecare}', '{$oras_destinatie}', '{$data_plecare}', '{$numar_persoane}', '{$nume_prenume}', '{$telefon}', '{$email}');"; mysql_query($insert_sql); ?> |
#2
Posted 02 August 2016 - 14:35
Pai pentru ca se executa acel script care asta face.
De ce nu ai name si value la butonul de submit? De ce nu pui conditie? <?php if (isset $_POST['aici pui name de la butonul de submit']) { ... ... } Daca ai erori, le afisezi. Daca nu-s erori, atunci sa faca insertul (numai cand se apasa butonul). |
#3
Posted 02 August 2016 - 14:37
Acel reload page, il faci cumva dupa ce ai dat un submit?
De ce nu adaugi un header location sa te duca in alta pagina, asa nu mai face iarasi submit. |
#4
Posted 02 August 2016 - 14:58
Kriogen, on 02 august 2016 - 14:37, said:
Acel reload page, il faci cumva dupa ce ai dat un submit? De ce nu adaugi un header location sa te duca in alta pagina, asa nu mai face iarasi submit. colombo2003, on 02 august 2016 - 14:35, said:
Pai pentru ca se executa acel script care asta face. De ce nu ai name si value la butonul de submit? De ce nu pui conditie? <?php if (isset $_POST['aici pui name de la butonul de submit']) { ... ... } Daca ai erori, le afisezi. Daca nu-s erori, atunci sa faca insertul (numai cand se apasa butonul). |
#5
Posted 02 August 2016 - 15:44
Nu ne spui si noua url-ul , sa-ti facem un sql injection de mai mare dragul ?
|
Anunturi
Bun venit pe Forumul Softpedia!
▶ 0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users