Проблем с база данни

L

lyki

Registered
Здравейте програмисти :) имам следния проблем направих си една проста програма която чрез попълване на формуляр ми вкарва данните в таблицата в базата данни та проблема е че прави 2 записа 1 с данните които сам въвел и 1 празен запис имате ли някаква представа как мога да реша проблема си.
 
от програми неразбирам, но ще дам идея да не би да си написал някаде заявка повторно, но тя да е празна?
 
Едновременно ли ги прави или след като рефрешнеш или втори път натиснеш "Събмит" бутона?
 
PHP: 
<?php
session_start();
if($_SESSION['proba']!=1){
     echo "Vaveli ste gre6no ime ili parola ";
        echo "<a href='login.php'>";
        echo "Nazad";
        echo "</a>";
        exit ();
}
?>
<html>
<head>
  <title>iuoyiuyoiuyio</title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">	
</head>
<body>

 <form method="POST" action="login3.php">
        <p>Vapros:
            <input type="text" name="vapros" size="90">
        </p>
        <p>Otgovor 1:
            <input type="text" name="otg1" size="90">
        </p>
        <p>Otgovor 2:
            <input type="text" name="otg2" size="90">
        </p>
        <p>Otgovor 3:
            <input type="text" name="otg3" size="90">
        </p>
        <p>Otgovor 4:
            <input type="text" name="otg4" size="90">
        </p>
        <p>Otgovor 5:
            <input type="text" name="otg5" size="90">
        </p>
         <p>
            <input type="submit" name="submit" value="submit">
        </p>
    </form>
     <?php error_reporting (E_ALL ^ E_NOTICE); ?>
    <?php
  
    $vapros = htmlspecialchars($_POST['vapros']);
    $otg1 = htmlspecialchars($_POST['otg1']);
    $otg2 = htmlspecialchars($_POST['otg2']);
    $otg3 = htmlspecialchars($_POST['otg3']);
    $otg4 = htmlspecialchars($_POST['otg4']);
    $otg5 = htmlspecialchars($_POST['otg5']);


    $user = "root";
    $pass = "";
    $db = "testove";
    $host = "localhost";
    $connection = mysql_connect($host, $user, $pass) or die("Ne moje da se svarje s BD");
    $db = mysql_select_db($db,$connection)or die("nemoje da se svarje s BD2");
    $query = mysql_query("INSERT INTO `testtable` (`test_id`, `vapros`,`otg1`, `otg2o`, `otg3o`, `otg4`, `otg5`)VALUES('','$vapros','$otg1','$otg2','$otg3','$otg4','$otg5')");
   
       echo "uspe6no ka4i vapros";
    
    
    ?>
</body>
</html>
Едновременно става,можели да съм объркал настройките на самата таблица.
 
PHP: 
<?php
session_start();
if($_SESSION['proba']!=1){
     echo "Vaveli ste gre6no ime ili parola ";
        echo "<a href='login.php'>";
        echo "Nazad";
        echo "</a>";
        exit ();
}
?>
<html>
<head>
  <title>iuoyiuyoiuyio</title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">   
</head>
<body>

 <form method="POST" action="login3.php">
        <p>Vapros:
            <input type="text" name="vapros" size="90">
        </p>
        <p>Otgovor 1:
            <input type="text" name="otg1" size="90">
        </p>
        <p>Otgovor 2:
            <input type="text" name="otg2" size="90">
        </p>
        <p>Otgovor 3:
            <input type="text" name="otg3" size="90">
        </p>
        <p>Otgovor 4:
            <input type="text" name="otg4" size="90">
        </p>
        <p>Otgovor 5:
            <input type="text" name="otg5" size="90">
        </p>
         <p>
            <input type="submit" name="submit" value="submit">
        </p>
    </form>
    <?php
  
    $vapros = htmlspecialchars($_POST['vapros']);
    $otg1 = htmlspecialchars($_POST['otg1']);
    $otg2 = htmlspecialchars($_POST['otg2']);
    $otg3 = htmlspecialchars($_POST['otg3']);
    $otg4 = htmlspecialchars($_POST['otg4']);
    $otg5 = htmlspecialchars($_POST['otg5']);


    $user = "root";
    $pass = "";
    $db = "testove";
    $host = "localhost";
    $connection = mysql_connect($host, $user, $pass) or die("Ne moje da se svarje s BD");
    $db = mysql_select_db($db,$connection)or die("nemoje da se svarje s BD2");
    $query = mysql_query("INSERT INTO `testtable` (`test_id`, `vapros`,`otg1`, `otg2o`, `otg3o`, `otg4`, `otg5`)VALUES('','$vapros','$otg1','$otg2','$otg3','$otg4','$otg5')");
   
       echo "uspe6no ka4i vapros";
    
    
    ?>
</body>
</html>

Какви грешки ти дава?
Покажи как ти е направена базата данни.
 
Я пробвай така:

PHP: 
<?php
session_start();
if($_SESSION['proba']!=1){
     echo "Vaveli ste gre6no ime ili parola ";
        echo "<a href='login.php'>";
        echo "Nazad";
        echo "</a>";
        exit ();
}
?>
<html>
<head>
  <title>iuoyiuyoiuyio</title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">   
</head>
<body>

 <form method="POST" action="login3.php">
        <p>Vapros:
            <input type="text" name="vapros" size="90">
        </p>
        <p>Otgovor 1:
            <input type="text" name="otg1" size="90">
        </p>
        <p>Otgovor 2:
            <input type="text" name="otg2" size="90">
        </p>
        <p>Otgovor 3:
            <input type="text" name="otg3" size="90">
        </p>
        <p>Otgovor 4:
            <input type="text" name="otg4" size="90">
        </p>
        <p>Otgovor 5:
            <input type="text" name="otg5" size="90">
        </p>
         <p>
            <input type="submit" name="submit" value="submit">
        </p>
    </form>
    <?php
  if (isset($_POST['submit']))
{
    $vapros = htmlspecialchars($_POST['vapros']);
    $otg1 = htmlspecialchars($_POST['otg1']);
    $otg2 = htmlspecialchars($_POST['otg2']);
    $otg3 = htmlspecialchars($_POST['otg3']);
    $otg4 = htmlspecialchars($_POST['otg4']);
    $otg5 = htmlspecialchars($_POST['otg5']);


    $user = "root";
    $pass = "";
    $db = "testove";
    $host = "localhost";
    $connection = mysql_connect($host, $user, $pass) or die("Ne moje da se svarje s BD");
    $db = mysql_select_db($db,$connection)or die("nemoje da se svarje s BD2");
    $query = mysql_query("INSERT INTO `testtable` (`test_id`, `vapros`,`otg1`, `otg2o`, `otg3o`, `otg4`, `otg5`)VALUES('','$vapros','$otg1','$otg2','$otg3','$otg4','$otg5')");
   
       echo "uspe6no ka4i vapros";
    
    }
    ?>
</body>
</html>
 
мерси справих се като добавих IF
PHP: 
<?php
session_start();
if($_SESSION['proba']!=1){
     echo "Vaveli ste gre6no ime ili parola ";
        echo "<a href='login.php'>";
        echo "Nazad";
        echo "</a>";
        exit ();
}
?>
<html>
<head>
  <title>iuoyiuyoiuyio</title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">	
</head>
<body>

 <form method="POST" action="login3.php">
        <p>Vapros:
            <input type="text" name="vapros" size="90">
        </p>
        <p>Otgovor 1:
            <input type="text" name="otg1" size="90">
        </p>
        <p>Otgovor 2:
            <input type="text" name="otg2" size="90">
        </p>
        <p>Otgovor 3:
            <input type="text" name="otg3" size="90">
        </p>
        <p>Otgovor 4:
            <input type="text" name="otg4" size="90">
        </p>
         <p>
            <input type="submit" name="submit" value="submit">
        </p>
    </form>
     <?php error_reporting (E_ALL ^ E_NOTICE); ?>
    <?php
  
    $vapros = htmlspecialchars($_POST['vapros']);
    $otg1 = htmlspecialchars($_POST['otg1']);
    $otg2 = htmlspecialchars($_POST['otg2']);
    $otg3 = htmlspecialchars($_POST['otg3']);
    $otg4 = htmlspecialchars($_POST['otg4']);
    if(empty($vapros) or empty($otg1) or empty($otg2) or empty($otg3)or empty($otg4)){

echo "ne ste popalnili vsi4ki poleta";

}
else {


    $user = "root";
    $pass = "";
    $db = "testove";
    $host = "localhost";
    $connection = mysql_connect($host, $user, $pass) or die("Ne moje da se svarje s BD");
    $db = mysql_select_db($db,$connection)or die("nemoje da se svarje s BD2");
    $query = mysql_query("INSERT INTO `testtable` (`test_id`, `vapros`,`otg1`, `otg2o`, `otg3o`, `otg4`)VALUES('','$vapros','$otg1','$otg2','$otg3','$otg4')");
   
       echo "успешно качи въпрос";
    
}
    ?>
</body>
</html>
 
А сега въобще записва ли нещо в базата данни? :)
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе