Fails to insert records with stored procedure in php
<p>I have the next code and i have experimented problems to insert in the data base, the   stored procedure works properly:</p>

<p><strong>The store procedure is:</strong></p>

<pre><code>DELIMITER //
CREATE PROCEDURE newProduct

(   
IN tipo VARCHAR(10),
IN categoria VARCHAR(10),
IN marca VARCHAR(10),
IN modelo VARCHAR(10),
IN color VARCHAR(10),
IN talla DOUBLE,
IN corte VARCHAR(15),
IN cveprecio VARCHAR(20),
IN precio DECIMAL(7,2),
IN sugp DECIMAL(7,2)        
)
BEGIN
START TRANSACTION;

INSERT INTO tipos (tipo) VALUES (tipo);
INSERT INTO marcas (marca,modelo) VALUES (marca,modelo);
INSERT INTO colores (color) VALUES (color);
INSERT INTO tallas (talla) VALUES (talla);
INSERT INTO corte (corte) VALUES (corte);
INSERT INTO precios (cveprecio,precio,sugp) VALUES (cveprecio,precio,sugp);

COMMIT;
END//
DELIMITER ;
</code></pre>

<p><strong>Call to store procedure in MYSQL (It works)</strong></p>

<p>call newProduct('Tenis','Hombre','Nike','ACG90','Negro',26.5,'Sintetico','6p90',690.50,750.50);</p>

<p><strong>Code PHP for Connect to the DB</strong></p>

<pre><code>&lt;?php//connect.php
$connect= mysqli_connect('localhost','root','xxxx','bancodedatos');
if (!$connect)
{
printf("Can't connect to MySQL Server.", mysqli_connect_error());
exit;
}
?&gt;
</code></pre>

<p><strong>Code for insert and call store procedure</strong> </p>

<pre><code>&lt;?php//insert.php
include("../connect.php");
$tipo= isset($_POST['tipo']) ? $_POST['tipo'] : NULL;
$categoria= isset($_POST['categoria']) ? $_POST['categoria'] : NULL;
$marca= isset($_POST['marca']) ? $_POST['marca'] : NULL;
$modelo= isset($_POST['modelo']) ? $_POST['modelo'] : NULL;
$color= isset($_POST['color']) ? $_POST['color'] : NULL;
$talla= isset($_POST['talla']) ? $_POST['talla'] : NULL;
$corte= isset($_POST['corte']) ? $_POST['corte'] : NULL;
$cveprecio= isset($_POST['cveprecio']) ? $_POST['cveprecio'] : NULL;
$precio= isset($_POST['precio']) ? $_POST['precio'] : NULL;
$sugp= isset($_POST['sugp']) ? $_POST['sugp'] : NULL;
$createProduct=mysqli_query($connect,"CALL newProduct($tipo,$categoria,$marca,$modelo,$color,$talla,$corte,$cveprecio,$precio,$sugp)"); 

mysql_close ($connect);

?&gt;
</code></pre>

<p><em><strong>To call it from php doesn't insert into database, thanks, and greetings from mexico</em></strong></p>
