Can someone tell me the failure of my mysqli query?

Question

Can someone tell me the failure of my mysqli query?

Navigation

#1 by (0 votes)

0

My mistake is that when you send the form you send the echo but it does not save the sqlm insertion if you can help me I would appreciate it.

if (isset($_POST["enviar"])) {
$snombre = $_POST["snombre"];
$stel = $_POST["stel"];
$semail = $_POST["semail"];
$scasilla1=$_POST['scasilla1'];
$scasilla2=$_POST["scasilla2"];
$scasilla3=$_POST["scasilla3"];
$scasilla4=$_POST["scasilla4"];
$scasilla5=$_POST["scasilla5"];
$scasilla6=$_POST["scasilla6"];
$scasilla7=$_POST["scasilla7"];
$scasilla8=$_POST["scasilla8"];
$scasilla9=$_POST["scasilla9"];

$con->query("INSERT INTO servicios (snombre, stel, semail, scasilla1, 
scasilla2, scasilla3, scasilla4, scasilla5, scasilla6, scasilla7,   
scasilla8,  scasilla9)  

VALUES('$snombre','$stel','$semail','0','0','0','0','0','0','0','0','0')");

 echo "Se ha enviado de manera satisfactoria.<a   
 href='servicios.php'>Volver<a/>";
 }
mysqli_close($con);

Thanks in advance. Greetings.

php mysqli

asked by Raul 06.03.2018 в 17:58

source

1 answer

expected type-specifier before error c ++ how to prevent my bootstrap modal from closing with the keyboard and only with the bonton accept from the same modal? [duplicate]

score 0 · Accepted Answer

Greetings with the following changes you should already insert:

the variables get into the following syntax

'".$variable."'

Another detail I do not see where is your connection file or the function that connects you to the server

In your code I see a variable called $ with which has access to the DB but nowhere in your code is it observed or the function or requires an external .php file containing that connection

<?php

$con = new mysqli("localhost", "root", "password", "base_datos_hospital");//como mero ejemplo

if (isset($_POST["enviar"])) {
$snombre = $_POST["snombre"];
$stel = $_POST["stel"];
$semail = $_POST["semail"];
$scasilla1=$_POST['scasilla1'];
$scasilla2=$_POST["scasilla2"];
$scasilla3=$_POST["scasilla3"];
$scasilla4=$_POST["scasilla4"];
$scasilla5=$_POST["scasilla5"];
$scasilla6=$_POST["scasilla6"];
$scasilla7=$_POST["scasilla7"];
$scasilla8=$_POST["scasilla8"];
$scasilla9=$_POST["scasilla9"];

$con->query = "INSERT INTO servicios (snombre, stel, semail, scasilla1, 
scasilla2, scasilla3, scasilla4, scasilla5, scasilla6, scasilla7,   
scasilla8,  scasilla9)  

VALUES('".$snombre."','".$stel."','".$semail."','".$scasilla1."','".$scasilla2."','".$scasilla3."','".$scasilla4."','".$scasilla5."','".$scasilla6."','".$scasilla7."','".$scasilla8."','".$scasilla9."')";

 echo "Se ha enviado de manera satisfactoria.<a   
 href='servicios.php'>Volver<a/>";
 }
mysqli_close($con);

Try and tell us