Integrity constraint violation: 1048 Column 'usid' cannot be null

[phpNew1]

hi I'm working on a file upload and keep receiving this error:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'usid' cannot be null

i dont wanna change the column to null is there a way round this

<?php
include_once("conninfo2.php"); 
error_reporting(E_ALL);


if(isset($_FILES['files'])){
    $query = "INSERT into files(`filename`,`fsize`,`ftype`,`usid`)
             VALUES(:filename,:fsize,:ftype,:usid)";
    $stmt  = $db->prepare($query);
    $errors= array();
    foreach($_FILES['files']['tmp_name'] as $key => $error ){
        if ($error != UPLOAD_ERR_OK) {
            $errors[] = $_FILES['files']['name'][$key] . ' was not uploaded.';
            continue;
        }
        $filename = $key.$_FILES['files']['name'][$key];
        $fsize = $_FILES['files']['size'][$key];
        $file_tmp  = $_FILES['files']['tmp_name'][$key];
        $ftype = $_FILES['files']['type'][$key]; 
        if($fsize > 2097152){
            $errors[] = 'File size must be less than 2 MB';
            continue;
        }
        try{       

            $stmt->bindParam(':filename', $filename , PDO::PARAM_STR );
            $stmt->bindParam(':fsize', $fsize, PDO::PARAM_STR );
            $stmt->bindParam(':ftype', $ftype, PDO::PARAM_STR );
            $stmt->bindParam(':usid', $usid, PDO::PARAM_INT );
            $stmt->execute();

        $desired_dir="fileupload/";

        if(is_dir($desired_dir)==false){
            mkdir($desired_dir, 0700);// Create directory if it does not exist
        }
        if(is_file($desired_dir.'/'.$filename)==false){
            move_uploaded_file($file_tmp,$desired_dir.'/'.$filename);
        }else{    //rename the file if another one exist
            $new_file=$desired_dir.'/'.$filename.time();
            move_uploaded_file($file_tmp,$new_file) ;               
        }
    }catch(PDOException $e){
        $errors[] = $filename . 'not saved in db.';
        echo $e->getMessage();
    }   
}
if(empty($error)){
    echo "Success";
}
}
?>

[bradgrafelman]

Where (and how) is the PHP variable $usid defined?

[phpNew1]

bradgrafelman;11041035 wrote:

Where (and how) is the PHP variable $usid defined?

hi the $usid is in the database it detects the user

[bradgrafelman]

Er, no... a PHP variable can't be defined by a database; the two are completely separate concepts. Where do you define the actual PHP variable called $usid? Based on your reply... I'm betting the answer is: You don't. In other words, you're attempting to bind an undefined variable (which PHP is nice enough to translate into NULL for you rather than just blow up).

What is this "usid" column in the DB? Is it an AUTO_INCREMENT column? If so, why include it in your INSERT statement at all?

[phpNew1]

the $usid isn't an auto increment as i have a fileid that already serves this purpose i want the usid to record the user that is upload the document

[phpNew1]

<?php
include_once("conninfo2.php"); 
error_reporting(E_ALL);


if(isset($_FILES['files'])){
    $query = "INSERT into files(`filename`,`fsize`,`ftype`,`usid`)
             VALUES(:filename,:fsize,:ftype,:usid)";
    $stmt  = $db->prepare($query);
    $errors= array();
    foreach($_FILES['files']['tmp_name'] as $key => $error ){
        if ($error != UPLOAD_ERR_OK) {
            $errors[] = $_FILES['files']['name'][$key] . ' was not uploaded.';
            continue;
        }
        $filename = $key.$_FILES['files']['name'][$key];
        $fsize = $_FILES['files']['size'][$key];
        $file_tmp  = $_FILES['files']['tmp_name'][$key];
        $ftype = $_FILES['files']['type'][$key]; 

    if($fsize > 2097152){
        $errors[] = 'File size must be less than 2 MB';
        continue;
    }
    try{       
        $stmt->bindParam(':filename', $filename , PDO::PARAM_STR );
        $stmt->bindParam(':fsize', $fsize, PDO::PARAM_STR );
        $stmt->bindParam(':ftype', $ftype, PDO::PARAM_STR );
        $stmt->bindParam(':usid', $usid, PDO::PARAM_INT );
        $stmt->execute();

        $desired_dir="fileupload/";

        if(is_dir($desired_dir)==false){
            mkdir($desired_dir, 0700);// Create directory if it does not exist
        }
        if(is_file($desired_dir.'/'.$filename)==false){
            move_uploaded_file($file_tmp,$desired_dir.'/'.$filename);
        }else{    //rename the file if another one exist
            $new_file=$desired_dir.'/'.$filename.time();
            move_uploaded_file($file_tmp,$new_file) ;               
        }
    }catch(PDOException $e){
        $errors[] = $filename . 'not saved in db.';
        echo $e->getMessage();
    }   
}
if(empty($error)){
    echo "Success";
}
}
?>

[bradgrafelman]

phpNew1;11041045 wrote:

i want the usid to record the user that is upload the document

Okay, well where is that information stored?

As it stands now, the code that you've shown us doesn't create the variable $usid. So, you somehow need to get this user information (apparently an integer ID value) stored in that variable before you attempt to use the variable as if it already contained that information.

[Derokorian]

The very first time you use $usid in the script you've shown us is:

            $stmt->bindParam(':usid', $usid, PDO::PARAM_INT ); 

Therefore at this point, it doesn't have a defined value, which is the point BG is making.

[phpNew1]

Derokorian;11041057 wrote:

The very first time you use $usid in the script you've shown us is:

            $stmt->bindParam(':usid', $usid, PDO::PARAM_INT ); 

Therefore at this point, it doesn't have a defined value, which is the point BG is making.

but i have added the value here isn't that were the value is set

if(isset($_FILES['files'])){
    $query = "INSERT into files(`filename`,`fsize`,`ftype`,`usid`)
             VALUES(:filename,:fsize,:ftype,:usid)";

[Weedpacket]

No, the variable [font=monospace]$usid[/font] is not set at that point. It doesn't even appear at that point.

That line says what to do with the value of [font=monospace]$usid[/font] when you supply it in the line Derokorian quoted.

But what is it?

[phpNew1]

Weedpacket;11041063 wrote:

No, the variable [font=monospace]$usid[/font] is not set at that point. It doesn't even appear at that point.

That line says what to do with the value of [font=monospace]$usid[/font] when you supply it in the line Derokorian quoted.

But what is it?

its a column that detects the user, this users info is in the login table

[laserlight]

phpNew1 wrote:

its a column that detects the user, this users info is in the login table

Refer to post #4. $usid is not a column; $usid is a PHP variable. The database column that you are thinking of is named usid, but bradgrafelman, Derokorian and Weedpacket have been talking about the variable named $usid.

To put it another way, what does this code output?

print_r($usid);

[phpNew1]

laserlight;11041071 wrote:

Refer to post #4. $usid is not a column; $usid is a PHP variable. The database column that you are thinking of is named usid, but bradgrafelman, Derokorian and Weedpacket have been talking about the variable named $usid.

To put it another way, what does this code output?

print_r($usid);

okay so scrapping the $usid, how would i go about adding the usersid of that user that is uploading the document?

[laserlight]

phpNew1 wrote:

okay so scrapping the $usid, how would i go about adding the usersid of that user that is uploading the document?

It depends. For example, suppose that after you have authenticated the user, you store the user's id in a session variable. You would then access this session variable in order to bind a value to the :usid prepared statement placeholder.

[phpNew1]

laserlight;11041083 wrote:

It depends. For example, suppose that after you have authenticated the user, you store the user's id in a session variable. You would then access this session variable in order to bind a value to the :usid prepared statement placeholder.

okay just making sure i understand i need to define the variable which would be the session to the userid??

[dalecosp]

Put this at the top of your script:

$usid = 1;

:evilgrin:

(Just be sure to understand what it will do first ...) :evilgrin:

[dalecosp]

phpNew1;11041085 wrote:

okay just making sure i understand i need to define the variable which would be the session to the userid??

Whatever the script recognizes as a valid "user id", you should set $usid equal to it before you execute the DB query.

[laserlight]

phpNew1 wrote:

i need to define the variable which would be the session to the userid?

Sorry, I don't understand your question. If you are not familiar with sessions, then I suggest that you read the PHP manual concerning session handling.

EDIT:
That said, this is just one possibility. The whole idea is that once you have somehow authenticated the user, you should "know" the user's id, and thus if you store that piece of knowledge somewhere, you just need to retrieve it and then use it for the insertion to the database table. For all we know you might be keeping track of a unique username instead, in which case perhaps you can use that to get the user's id, or maybe do a join or subquery.

[carljr]

i tried it and it didn't work. bummer. i tried to use the order form and then check phpmyadmin and saw nothing in the table. so the first thing i did was run my php script to see what type of response i'd get. i got this message: "Connected to database
Array
(
)".

(although i don't know what is supposed to be in the array, errors perhaps? but it did take away the previous error message i was receiving regarding an integrity error and one of the values needed be set to null)
in any event, the good connection is there. next i made sure the correct string in the html code to access the php script was correct and it is. if i may here is the html:

<form id="shoppingCart" method="POST" class="form-inline" name="basket_form" action="myconnection/prac0.php">

                                        Continue Shopping
                   								<thead>
								<tr>
									<th colspan="2" class="description">
										Item Description
									</th>
									<th class="size">
										Temple
									</th>

							  <th class="quantity">
										Quantity
								  </th>
									<th class="price">
										Price
									</th>
									<th class="subtotal">
										Subtotal
              </th>
									<th>&nbsp;

									</th>
								</tr>
							</thead>
						</table>
						<table class="table">
							<tbody>
								<tr class="warning">
									<td class="thumb" rowspan="2"><a href="javascript: void(0);" title="Link to product page"><img src="img/331.jpg" alt="" width="123" height="91" title="Product Image"></a></td>
									<td class="description" rowspan="2">
										<a class="item-name" href="javascript: void(0);" title="http://exxxx.co/vantage_poxxxx.html">The Minimum</a>
										<div>
											<div class="item-availability"><em>These Diamond Shape Spectacles Accentuate Anyone's Style and Grace</em>.</div>
											<div class="item-sku">MDL331</div>
										</div>
									</td>
									<td class="size">
                                        <select class="span2" id="prod2_size1" name="prod2_size1">
											<option value="Buffalo Horn" selected>Buffalo Horn</option>
											<option value="Gold">Gold</option>
											<option value="Rose Gold">Rose Gold</option>
											<option value="White Gold">White Gold</option>
											<option value="Titanium">Titanium</option>
											<option value="Platinum">Platinum</option>
                                        </select> 
							    </td>
									<td class="color">


										<input type="hidden" id="prod2_color1" name="prod2_color1" value="no">
									</td>
							  <td class="quantity">Qty:								    <input id="prod2_qty1" name="prod2_qty1" type="text" class="number" value="1" class="inline input-mini">
						      </td>
									<td class="price">
										<span class="currency">$</span><span class="amount">3000.00</span>
									</td>
									<td class="subtotal">
										<span class="currency">$</span><span class="amount">3000.00</span>
									</td>
									<td class="remove">
                                        <button class="btn btn-danger btn-mini" type="submit" name="prod2_remove1" value="remove_item" rel="tooltip" data-placement="left" data-original-title="Be careful! This item will be entirely removed from the basket!">
                                            <i class="icon-remove icon-white"></i>
                                        </button>
									</td>
								</tr>
								<tr class="warning additional_empty">
									<td class="empty_td" colspan="8">

									</td>
								</tr>
						  </tbody>
				    </table>


                    <table class="table">
						  <tbody>
								<tr class="warning">
									<td class="thumb" rowspan="2">
								  <a href="javascript: void(0);" title="http://eyexxxxint.html"><img src="img/332.JPG" width="123" height="91"></a></td>
									<td rowspan="2" class="description">
										<a class="item-name" href="javascript: void(0);" title="Link to product page">The Medium</a>
										<div>
											<div class="item-availability">
											  <p><em>Timeless Design, </em><em>A true work of art</em>, <em>High Quality Lenses, </em><em>A Comfortable Fit</em></p>
</div>
												<div class="item-sku">MDL332</div>
											</div>
										</td>
										<td class="size">
                                          <select class="span2" id="prod2_size1" name="prod2_size1">
												<option value="Buffalo Horn" selected>Buffalo Horn</option>
												<option value="Gold">Gold</option>
												<option value="Rose Gold">Rose Gold</option>
												<option value="White Gold">White Gold</option>
												<option value="Titanium">Titanium</option>
												<option value="Platinum">Platinum</option>
                                            </select>
										</td>
										<td class="color"><input type="hidden" id="prod2_color1" name="prod2_color1" value="no">
									  </td>
								  <td class="quantity">Qty:								    <input id="prod2_qty1" name="prod2_qty1" type="text" class="number" value="1" class="inline input-mini">
							      </td>
										<td class="price">
											<span class="currency">$</span><span class="amount">4000.00</span>
										</td>
										<td class="subtotal">
											<span class="currency">$</span><span class="amount">4000.00</span>
										</td>
										<td class="remove">
                                            <button class="btn btn-danger btn-mini" type="submit" name="prod2_remove1" value="remove_item" rel="tooltip" data-placement="left" data-original-title="Be careful! This item will be entirely removed from the basket!">
                                                <i class="icon-remove icon-white"></i>
                                            </button>
										</td>
									</tr>
									<tr class="warning additional_empty">
										<td class="empty_td" colspan="8">

								  </td>
								</tr>
						  </tbody>
				    </table>


                    <table class="table">
					  <tbody>
								<tr class="warning">
									<td class="thumb" rowspan="2">
										<a href="javascript: void(0);" title="Link to product page">
											<img src="img/333.jpg" width="123" height="91" title="Product Image">
										</a>
</td>
									<td class="description" rowspan="2">
										<a class="item-name" href="javascript: void(0);" title="Link to product page">The Maximum</a>
										<div>
											<div class="item-availability"><em>Rimless frames</em>, <em> Sophistication &amp; *Elegance</em> by Design</div>
											<div class="item-sku">MDL333</div>
										</div>
									</td>
									<td class="size">
                                        <select class="span2" id="prod2_size1" name="prod2_size1">
											<option value="Buffalo Horn" selected>Buffalo Horn</option>
											<option value="Gold">Gold</option>
											<option value="Rose Gold">Rose Gold</option>
											<option value="White Gold">White Gold</option>
											<option value="Titanium">Titanium</option>
											<option value="Platinum">Platinum</option>

                                        </select>
									</td>
									<td class="color"><input type="hidden" id="prod2_color1" name="prod2_color1" value="no">
								  </td>
									<td class="quantity"><label class="inline">Qty:</label><input id="prod2_qty1" name="prod2_qty1" type="text" class="number" value="1" class="inline input-mini">
									</td>
									<td class="price">
										<span class="currency">$</span><span class="amount">5000.00</span>
									</td>
									<td class="subtotal">
										<span class="currency">$</span><span class="amount">5000.00</span>
									</td>
									<td class="remove">
                                        <button class="btn btn-danger btn-mini" type="submit" name="prod2_remove1" value="remove_item" rel="tooltip" data-placement="left" data-original-title="Be careful! This item will be entirely removed from the basket!">
                                            <i class="icon-remove icon-white"></i>
                                        </button>

and the php:

try {
    $dbh = new PDO("mysql:host=$hostname;dbname=new_order", $username, $password);


$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT );
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
/*** echo a message saying we have connected ***/
echo 'Connected to database<br />';


?>

<body>


<?php


if ($_SERVER["REQUEST_METHOD"] == "POST")

{
$errors = [];
}

if(empty($errors)) {

echo "<pre>";
print_r($_POST);
echo "</pre>";
exit;


// prepare sql and bind parameters
    $query = "INSERT INTO details (description, prod2_size1, prod2_qty1, price)
            VALUES (:description, :prod2_size1, :prod2_qty1, :price)";
}
    $stmt = $dbh->prepare($query);
        $stmt->bindParam(':description', $_POST['description']);
        $stmt->bindParam(':prod2_size1', $_POST['prod2_size1']);
        $stmt->bindParam(':prod2_qty1', $_POST['prod2_qty1']);
        $stmt->bindParam(':price', $_POST['price']);
       $stmt->execute();


} catch (PDOException $exception) {
echo $exception->getMessage() . "<br />";
}

/*** close the database connection ***/
$dbh = null;

?>

just point me in the right direction. i'll do my own work. thanks, yall.