Redirect after mysql insert

Posts: 39

Redirect after mysql insert

Please help me! I have this code but don't redirect to submit2.WHY?

Code: Select all

<!DOCTYPE html> <?php require('layout-submit1.php'); header('Content-type: text/html; charset=utf-8'); session_start(); $mesaj = ''; if(isset($_POST['an']) && strlen($_POST['an'])>0) $s = $_POST['an']; { // Se filtreaza datele pt. eliminare posibile spatii exterioare si tag-uri $_POST = array_map("trim", $_POST); $_POST = array_map("strip_tags", $_POST); // Se verifica daca "magic_quotes_gpc()" este setat ON // Daca e ON, se aplica stripslashes() pentru a nu se adauga de 2 ori '\' cand va fi aplicat "mysql_real_escape_string()" if(get_magic_quotes_gpc()) { $_POST = array_map("stripslashes", $_POST); } \ // Verifica daca adresa de e-mail scrisa corespunde formatului unei adrese de e-mail if(isset($_POST['an']) && strlen($_POST['an'])>0) $s = $_POST['an']; else $eroare[] = 'Select type'; // Verifica daca a fost selectata o valoare pt. 'studii' if(strlen($_POST['manufacturer'])>0) $ma = $_POST['manufacturer']; else $eroare[] = 'Selectati servicii'; // Verifica daca a fost bifat buton pt. 'stare civila' // Daca nu exista nici un mesaj de eroare, filreaza datele cu mysql_real_escape_string() si le adauga in baza de date // Altfel, in cazul vreunei erori, adauga in variabila $mesaj if (!isset($eroare)) { include('conn.php'); // Include fisierul pt. conectare-selectare baza de dat // Se aplica functia de filtrare mysql_real_escape_string() $marca = $_POST['manufacturer']; $locuri = $_POST['locuri']; $an = $_POST['an']; // Acum se adauga mai in siguranta aceste date in MySQL $sql = "INSERT INTO `anunt1` (`marca` ,`locuri`, `an` ) VALUES ('$marca', '$locuri', '$an' )"; if (mysql_query($sql, $conn)) { header('Location:'); } else $mesaj = '<font color="red">Datele nu au putut fi adaugate '. mysql_error(). '</font>'; mysql_close($conn); } else $mesaj = '<font color="red">'. implode('<br />', $eroare). '</font>'; } echo $mesaj; ?> <div class="col-lg-9 col-md-8 col-sm-7 col-xs-6"> <div class="b-submit__main"> <header class="s-headerSubmit s-lineDownLeft wow zoomInUp" data-wow-delay="0.5s"> <h2 class="">Adauga detaliile vehiculului</h2> </header> <form class="s-submit clearfix" action="" method="POST"> <div class="row"> <div class="col-md-6 col-xs-12"> <div class="b-submit__main-element wow zoomInUp" data-wow-delay="0.5s"> <label>Marca <span>*</span></label> <div class='s-relative'> <select name="manufacturer" id="manufacturer" class="m-select"> <option value="">Selecteaza</option> </select> <span class="fa fa-caret-down"></span> </div> </div> <div class="b-submit__main-element wow zoomInUp" data-wow-delay="0.5s"> <label>Anul fabricatiei<span>*</span></label> <div class='s-relative'> <select class="m-select" name="an" id="an"> <option value="0" selected="selected">An min</option> <option value="2016">2016</option> <option value="2015">2015</option> <option value="2014">2014</option> <option value="2013">2013</option> <option value="2012">2012</option> <option value="2011">2011</option> <option value="2010">2010</option> <option value="2009">2009</option> <option value="2008">2008</option> <option value="2007">2007</option> <option value="2006">2006</option> <option value="2005">2005</option> <option value="2004">2004</option> <option value="2003">2003</option> <option value="2002">2002</option> <option value="2001">2001</option> <option value="2000">2000</option> <option value="1999">1999</option> </select> <span class="fa fa-caret-down"></span> </div> </div> <div class="b-submit__main-element wow zoomInUp" data-wow-delay="0.5s"> <label>Numar de locuri <span>*</span></label> <div class='s-relative'> <select class="m-select" name="locuri" id"locuri"> <option value="oricare">oricare</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="altele">Altele</option> </select> <span class="fa fa-caret-down"></span> </div> </div> <div class="b-submit__main-element wow zoomInUp" data-wow-delay="0.5s"> <label>Numar viteze <span>*</span></label> <div class='s-relative'> <select class="m-select" name="select4"> <option value="5">5</option> <option value="6">6</option> </select> <span class="fa fa-caret-down"></span> </div> </div> <div class="b-submit__main-element wow zoomInUp" data-wow-delay="0.5s"> <label>Transmisie <span>*</span></label> <div class='s-relative'> <select class="m-select" name="select5"> <option value="0">Selecteaza</option> <option value="oricare">Oricare</option> <option value="fata">Fata</option> <option value="spate">Spate</option> <option value="4x4(automat)">4x4(automat)</option> <option value="4x4(manual)">4x4(manual)</option> </select>

The code mysql_query($sql, $conn) is incorrect. Maybe the script it uses MySQLi; in this case you should put: $conn->query($sql).
Also, delete the: mysql_close($conn); because it generate error if the mysql connection is with mysqli.

Similar Topics