Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host="localhost";
- $db_user = "root";
- $db_password ="";
- $db_name="1_wybory";
- if ( !mysql_connect($host,$db_user,$db_password) ) {
- echo 'Nie moge polaczyc sie z baza danych';
- exit (0);
- }
- if ( !mysql_select_db($db_name) ) {
- echo 'Blad otwarcia bazy danych';
- exit (0);
- }
- SkorygujZmienneZFormularza($title,$type,$area, $beg_date, $beg_time, $end_date, $end_time);
- //$czy_poprawne_dane = SprawdzPoprawnoscDanych ($title,$type,$area, $beg_date, $beg_time, $end_date, $end_time);
- // if ($czy_poprawne_dane == "dane_ok") {
- $zapytanie = "INSERT INTO `elections` (`id_election`, `title`, `type`, `area`, `beg_date`, `beg_time`, `end_date`, `end_time`)";
- $zapytanie .= "VALUES ('', '$title', '$type', '$area', '$beg_date','$beg_time', '$end_date', '$end_time')";
- $wynik_zapytania = mysql_query($zapytanie);
- /* if (!$wynik_zapytania) {
- echo("<br />Nie moge dodać rekordu do bazy!<br /><br />");
- } else {
- echo "Gratulacje!!!";
- echo "<br />Rekord dodany do bazy";
- }
- } else {
- echo "Wprowadziles niepoprawne dane do formularza. Być może nie wszystkie pola sa wypelnione";
- echo "<br />Spróbuj ponownie:";
- }*/
- //}
- //Zamykamy poł±czenie z baz± danych
- if ( !mysql_close() ) {
- echo 'Nie moge zakonczyc polaczenia z baza danych';
- exit (0);
- }
- function SkorygujZmienneZFormularza(&$title,&$type,&$area,&$beg_date,&$beg_time,&$end_date,&$end_time) {
- if ( isset($_POST["title"]) )
- $title = trim($_POST["title"]);
- else
- $title = "";
- if ( isset($_POST["type"][1]) ){
- $type = ($_POST["type"][1]);
- }
- else if(isset($_POST["type"][2])){
- $type = ($_POST["type"][2]);
- }
- else if(isset($_POST["type"][3])){
- $type = ($_POST["type"][3]);
- }
- if ( isset($_POST["type"][4]) ){
- $type = ($_POST["type"][4]);
- }
- else if(isset($_POST["type"][5])){
- $type = ($_POST["type"][5]);
- }
- else if(isset($_POST["type"][6])){
- $type = ($_POST["type"][6]);
- }else{
- $type="";
- }
- if ( isset($_POST["area"][1]) ){
- $area = ($_POST["area"][1]);
- }
- else if(isset($_POST["area"][2])){
- $area = ($_POST["area"][2]);
- }
- else if(isset($_POST["area"][3])){
- $area = ($_POST["area"][3]);
- }else{
- $area="";
- }
- if(isset($_POST["beg_date"]))
- $beg_date = ($_POST["beg_date"]);
- else
- $beg_date = "";
- if ( isset($_POST["beg_time"]) )
- $beg_time = trim($_POST["beg_time"]);
- else
- $beg_time = "";
- if ( isset($_POST["end_date"]) )
- $end_date = trim($_POST["end_date"]);
- else
- $end_date = "";
- if ( isset($_POST["end_time"]) )
- $end_time = trim($_POST["end_time"]);
- else
- $end_time = "";
- }
- //function SprawdzPoprawnoscDanych ($title, $type, $area,$beg_date, $beg_time, $end_date, $end_time) {
- //if ( ($title=="") || ($type=="") || ($area=="")||($beg_date=="")||($beg_time=="")||($end_date=="")||($end_time=="") )
- // return "zle_dane";
- //return "dane_ok";
- //}
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement