PHP/SQL inserting data to sql

Question

I'm trying to insert data to sql from my form but the data is not going into my sql table. Also I'm not getting errors. Here is what I have :

<?php
mysqli_select_db($connect, "prekes");
if(isset($_POST['submit']))
{
     $pavad =  $_POST['pavad'];
     $Gamintojas =  $_POST['Gamintojas'];
     $Spalva =  $_POST['Spalva'];
     $Kiekis =  $_POST['Kiekis'];
     $Blizgumas = $_POST['Blizgumas'];
     $Kaina =  $_POST['Kaina'];
     $Kategorija =  $_POST['Kategorija'];
     $sandely =  $_POST['sandely'];

$query="
INSERT INTO prekes 
( pavad, Gamintojas, Spalva, Kiekis
, Blizgumas, Kaina, Kategorija, sandely) 
VALUES 
( '$pavad', '$Gamintojas', '$Spalva', '$Kiekis'
, '$Blizgumas', '$Kaina', '$Kategorija', '$sandely')
";

      if(mysqli_query($connect,$query))
      {
        echo "prideta";
      }else {
        echo"nope";
      }
}
?>

I've also putting my main.php code where I put my connection and tables at

</table>
<div class="prekiu_lentele">
<div class="lent">
<table class="lenetele_prekems" align="center">
<form action="insert.php" method="post">
<form action="update.php" method="get">
<tr>
    <th>Pavadinimas:<input type="text" name="pavad"></tr>
    <th>Gamintojas:<input type="text" name="Gamintojas"></tr>
    <th>Spalva:<input type="text" name="Spalva"></tr>
    <th>Kiekis:
      <select name="Kiekis">
        <option value="1l">1 l</option>
        <option value="2l">2 l</option>
        <option value="5l">5 l</option>
        <option value="10l">10 l</option>
      </select></tr>
    </tr>
    <tr>
    <th>Blizgumas:<input type="text" name="Blizgumas"></tr>
    <th>Kaina:<input type="text" name="Kaina"></tr>
    <th>Kategorija:<input type="text" name="Kategorija"></tr>
    <th>Kiekis sandelyje:<input type="text" name="sandely"></tr>
    </tr>
    <tr>
      <th ><input type="submit"; style="width: 300px"; value="Insert"  name="submit" ></th>
</tr>
</form>

You are mixing up `mysql` and `mysqli` in your code. Besides that it is better practice to use prepared statements instead of embedding variables in your query string, especially if you don't validate them. This is a huge security breach called SQL Injection. — Pieter De Clercq, May 23 '17 at 21:50
Yes, I fixed that, but I still don't see my mistake why my data isn't going to sql. — deividas, May 23 '17 at 21:52
I updated the line if(mysql_query($query)) - > if(mysqli_query($query)) — deividas, May 23 '17 at 21:56
Well, my database works, I have delete function which works, but I can't do Insert function — deividas, May 23 '17 at 23:42

score 0 · Accepted Answer · answered May 23 '17 at 23:58

0

I got it working, my path to sql database was wrong -_-. mysqli_select_db($connect, "prekes"); -> mysqli_select_db($connect, "produktai"); Noob mistakes..

answered May 23 '17 at 23:58

deividas

1
4

PHP/SQL inserting data to sql

1 Answers1

Linked