[RESOLVED] database form

auddog

I have created a form that inserts information into my database and everything works fine if I fill out all of the form. If I don't fill out the entire form, I get the following error: mysqli_error() expects exactly 1 parameter, 0 given . Is this something to do with PHP or mysql. I was thinking at it had to do with my php.ini file and an error code, but I'm not sure. Any help would be greatly appreicated.

Piranha

It can be both or any one of them. Without seing the code (and preferably an echoed query) it is impossible to say. So please post the query as it is generated and the cide that is used for this.

auddog

Here's the code that I have the puts the information into the database

<?php
include 'config_ada.php';

/*** create a new mysqli object with default database***/
$connection = mysqli_connect($hostname, $username, $password, $dbname) or die ("Unable to connect");


/*** sql to UPDATE a new record ***/
$sql = "INSERT INTO ada set
        (job_name, job_number, owner, own_phone, own_address, phone, proj_loc,
        proj_type, proj_desc, start_date, finish_date, square_feet, total_hours,
        total_fee, est_cost, act_cost, change_ord, consultants, contractor, file_box_num,
        file_box_loc, drawing_box_num, cad_cd, contract, Field25, Field26, Field27,
        Field28, proj_manager, proj_arch)
        values
        ('$_POST[job_name]', '$_POST[job_number]', '$_POST[owner]', '$_POST[own_phone]',
        '$_POST[own_address]', '$_POST[phone]', '$_POST[proj_loc]', '$_POST[proj_type]',
        '$_POST[proj_desc]', '$_POST[start_date]', '$_POST[finish_date]', '$_POST[square_feet]',
        '$_POST[total_hours]', '$_POST[total_fee]', '$_POST[est_cost]', '$_POST[act_cost]',
        '$_POST[change_ord]', '$_POST[consultants]', '$_POST[contractor]', '$_POST[file_box_num]',
        '$_POST[file_box_loc]', '$_POST[drawing_box_num]', '$_POST[cad_cd]', '$_POST[contract]',
        '$_POST[field25]', '$_POST[field26]', '$_POST[field27]', '$_POST[field28]',
        '$_POST[proj_manager]', '$_POST[proj_arch]')";

//excute query
$result = mysqli_query($connection, $sql) or die ("Error in query: $sql. ".mysqli_error());

// close connection
mysqli_close($connection);

header("Location: view_project_25.php");
exit;
?>

and here the error that I'm getting after it runs.

Warning: mysqli_error() expects exactly 1 parameter, 0 given in c:\Inetpub\wwwroot\ada\add_project.php on line 26
Error in query: INSERT INTO ada set (job_name, job_number, owner, own_phone, own_address, phone, proj_loc, proj_type, proj_desc, start_date, finish_date, square_feet, total_hours, total_fee, est_cost, act_cost, change_ord, consultants, contractor, file_box_num, file_box_loc, drawing_box_num, cad_cd, contract, Field25, Field26, Field27, Field28, proj_manager, proj_arch) values ('another test', '10002', 'will', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '1', '1').

I hope this helps as I have just about given up.

HalfaBee

You need to add the $connection into mysqli_error ( );
eg string mysqli_error ( $connection )

Then you will see where the error is occuring.
It is not secure to put $_POST variables directly into SQL.
It should be checked and cleaned first.

Piranha

I think that some of the values that is empty is set to NOT NULL in the database. When you try to insert an empty value it will not work. Please check if there are any columns set to NOT NULL in the database.

If there is no columns that is set to NOT NULL I have no idea what to do, it seems that the query is ok.

If there are one or many NOT NULL columns in the database then you have to decide if you still want it as NOT NULL and check for that as well, or if you can change it to enable NULL values.

auddog

I changed the insert query string and that seems to work as long as I fill in the last form box, which is field 28 and is yet to be determined for use, so I just set the default value to one. I don't have any of the field in the database set to not null, with the exception of the id. The only thing that I can see that is unique about the database is the collation is set to latin1_swedish_ci for all the fields, with the exception of the id field. I'm not sure that means much. Thanks for all the help.

cahva

Well what does that say now when you corrected the mysqli_error() with mysqli_error($connection)?

$result = mysqli_query($connection, $sql) or die ("Error in query: $sql. ".mysqli_error($connection));

That mysqli_error will give you the real reason for failing so correct that.