I'm facing database submission issues

[Barand]

Easiest way is to add this line to your included connection.php

mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);

immediately before the line that connects to the database (either with mysqli_connect() or new mysqli()  )

[gw1500se]

No, you are the programmer. If you want someone to write the program for you there is a form to hire someone.

[Frankice]

Just now, Barand said:

Easiest way is to add this line to your included connection.php

mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);

immediately before the line that connects to the database (either with mysqli_connect() or new mysqli()  )

I understand your point on the hiring aspect.

Here is my connection Sir,

 

<?php


// database connection config
$dbHost = 'localhost';
$dbUser = '';
$dbPass = '';
$dbName = '';

$dbConn = mysqli_connect ($dbHost, $dbUser, $dbPass) or die ('MySQL connect failed. ' . mysql_error());
mysqli_select_db($dbConn,$dbName) or die('Cannot select database. ' . mysqli_error());

function dbQuery($sql)
{
	$result = mysqli_query($dbConn,$sql) or die(mysql_error());
	
	return $result;
}

?>

 

[Barand]

Have you not mastered copy and paste yet?

// database connection config
$dbHost = 'localhost';
$dbUser = '';
$dbPass = '';
$dbName = '';

mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);                                                      //   <-- ADD IT HERE   !!!
                                                                                                                       
$dbConn = mysqli_connect ($dbHost, $dbUser, $dbPass) or die ('MySQL connect failed. ' . mysql_error());
mysqli_select_db($dbConn,$dbName) or die('Cannot select database. ' . mysqli_error());

function dbQuery($sql)
{
    $result = mysqli_query($dbConn,$sql) or die(mysql_error());
    
    return $result;
}

 

[Frankice]

Just now, Barand said:

Have you not mastered copy and paste yet?

// database connection config
$dbHost = 'localhost';
$dbUser = '';
$dbPass = '';
$dbName = '';

mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);                                                      //   <-- ADD IT HERE   !!!
                                                                                                                       
$dbConn = mysqli_connect ($dbHost, $dbUser, $dbPass) or die ('MySQL connect failed. ' . mysql_error());
mysqli_select_db($dbConn,$dbName) or die('Cannot select database. ' . mysqli_error());

function dbQuery($sql)
{
    $result = mysqli_query($dbConn,$sql) or die(mysql_error());
    
    return $result;
}

Here is the error after I correct the connection.

atal error: Uncaught mysqli_sql_exception: Field 'email' doesn't have a default value in /home/psdelive/public_html/admin/add package.php:24 Stack trace: #0 /home/psdelive/public_html/admin/add package.php(24): mysqli_query(Object(mysqli), 'INSERT INTO pac...') #1 {main} thrown in /home/psdelive/public_html/admin/add package.php on line 24

 

 

[gw1500se]

There is your answer. Either you are not adding a value for email in your insert or there is a problem with your schema.

[Frankice]

I'm happy to find this forum, the database have been updated after I removed the email field in the database .Thank you so much I appreciate your time.