I'm having trouble when I try to update/insert data into MySQL.
I have the following insert.php file:
<?php
include 'conn.php'; // MySQL Connection
if(!empty($_POST))
{
$output = '';
$message = '';
$domn_doamna = mysqli_real_escape_string($connect, $_POST["domn_doamna"]);
$nume = mysqli_real_escape_string($connect, $_POST["nume"]);
$prenume = mysqli_real_escape_string($connect, $_POST["prenume"]);
$cnp = mysqli_real_escape_string($connect, $_POST["cnp"]);
$oras = mysqli_real_escape_string($connect, $_POST["oras"]);
$judet = mysqli_real_escape_string($connect, $_POST["judet"]);
$strada = mysqli_real_escape_string($connect, $_POST["strada"]);
$numar = mysqli_real_escape_string($connect, $_POST["numar"]);
$bloc = mysqli_real_escape_string($connect, $_POST["bloc"]);
$scara = mysqli_real_escape_string($connect, $_POST["scara"]);
$etaj = mysqli_real_escape_string($connect, $_POST["etaj"]);
$apartament = mysqli_real_escape_string($connect, $_POST["apartament"]);
$telefon = mysqli_real_escape_string($connect, $_POST["telefon"]);
$email = mysqli_real_escape_string($connect, $_POST["email"]);
$serie_ci = mysqli_real_escape_string($connect, $_POST["serie_ci"]);
$nr_ci = mysqli_real_escape_string($connect, $_POST["nr_ci"]);
$ci_eliberat_de = mysqli_real_escape_string($connect, $_POST["ci_eliberat_de"]);
$data_eliberare_ci = mysqli_real_escape_string($connect, $_POST["data_eliberare_ci"]);
$data_cerere = mysqli_real_escape_string($connect, $_POST["data_cerere"]);
$email_bc = mysqli_real_escape_string($connect, $_POST["email_bc"]);
$telefon_bc = mysqli_real_escape_string($connect, $_POST["telefon_bc"]);
$info = mysqli_real_escape_string($connect, $_POST["info"]);
$ce_doreste = mysqli_real_escape_string($connect, $_POST["ce_doreste"]);
$status = mysqli_real_escape_string($connect, $_POST["status"]);
if($_POST["employee_id"] != '')
{
$query = "UPDATE `clienti_existenti` SET `domn_doamna` = '$domn_doamna',`nume` = '$nume',`prenume` = '$prenume',`cnp` = '$cnp',`oras` = '$oras',`judet` = '$judet',`strada` = '$strada',`numar` = '$numar',`bloc` = '$bloc',`scara` = '$scara',`etaj` = '$etaj',`apartament` = '$apartament',`telefon` = '$telefon',`email_client` = '$email',`serie_ci` = '$serie_ci',`nr_ci` = '$nr_ci',`ci_eliberat_de` = '$ci_eliberat_de',`data_eliberare_ci` = '$data_eliberare_ci',`data_adaugare` = '$data_cerere',`email_bc` = '$email_bc',`telefon_bc` = '$telefon_bc',`info` = '$info',`ce_doreste` = '$ce_doreste',`status` = '$status' WHERE `id` = '".$_POST["employee_id"]."' ";
$message = 'Data Updated';
}
else
{
$query = "INSERT INTO `clienti_existenti` (`domn_doamna`,`nume,`prenume`,`cnp`,`oras`,`judet`,`strada`,`numar`,`bloc`,`scara`,`etaj`,`apartament`,`telefon`,`email_client`,`serie_ci`,`nr_ci`,`ci_eliberat_de`,`data_eliberare_ci`,`data_adaugare`,`email_bc`,`telefon_bc`,`info`,`ce_doreste`,`status`) VALUES ('$domn_doamna','$nume','$prenume','$cnp','$oras','$judet','$strada','$numar','$bloc','$scara','$etaj','$apartament','$telefon','$email','$serie_ci','$nr_ci','$ci_eliberat_de','$data_eliberare_ci','$data_cerere','$email_bc','$telefon_bc','$info','$ce_doreste','$status') ";
$message = 'Data Inserted';
}
echo $connect;
if (mysqli_query($connect, $query)) //############# HERE IT`S STOPING !!!
{
$output .= '<label class="text-success">' . $message . '</label>';
$select_query = "SELECT * FROM clienti_existenti ORDER BY id DESC";
$result = mysqli_query($connect, $select_query);
$output .= '
<table class="table table-bordered">
<tr>
<th width="10%">Nume</th>
<th width="10%">Prenume</th>
<th width="10%">Telefon</th>
<th width="10%">Suma</th>
<th width="10%">Avans</th>
<th width="10%">Status</th>
<th width="10%">Adaugat</th>
<th width="10%" class="text-center">Editeaza</th>
<th width="10%" class="text-center">Vizualizeaza</th>
<th width="10%" class="text-center">Documente</th>
</tr>
';
while($row = mysqli_fetch_array($result))
{
$output .= '
<tr>
<td>'.$row["nume"].'</td>
<td>'.$row["prenume"].'</td>
<td>'.$row["telefon"].'</td>
<td>'.$row["suma_ct"].'</td>
<td>'.$row["avans_ct"].'</td>
<td>'.$row["status"].'</td>
<td>'.$row["data_adaugare"].'</td>
<td class="text-center"><input type="button" name="edit" value="Editeaza" id="'.$row["id"].'" class="btn btn-info btn-xs edit_data" /></td>
<td class="text-center"><input type="button" name="view" value="Vizualizeaza" id="'.$row["id"].'" class="btn btn-info btn-xs view_data" /></td>
<td class="text-center"><input type="button" name="documente" value="Documente" id="'.$row["id"].'" class="btn btn-info btn-xs view_data" /></td>
</tr>
';
}
$output .= '</table>';
}
echo $output;
}
?>
and the conn.php:
<?php
$connect = mysqli_connect("localhost", "sbdc", "sbdc", "sbdc");
?>
For some reason I get blank page and nothing is updated/inserted in mysql DB... somehow it's stopped around echo $connect; and doesn't want to execute if line , the output result for echo p$connect;` is:
Recoverable fatal error: Object of class mysqli could not be converted to string.
Could anyone help me out please ? Thank you very much.
