会话ID更改保存到DB

Question

I have this small problem on Session. Ill show you the codes below.

//checking session orderid if not created  
$setSession = $_SESSION['neworderid'];
if (empty($setSession)) {
    $neworderid = mt_rand(1000000000, 9999999999);  
    $_SESSION['neworderid'] = $neworderid;
}

//check if order_id exists in the database  
$db->setQuery("SELECT * FROM mn_orderitems WHERE order_id =" . $_SESSION['neworderid']);  
$query = $db->loadResult();  
if (!empty($query)) {  
    //if exists, do nothing  
    echo 'Not Empty';  
} else {
    //if order id doesn't exist, save the new order item  
    $qry = "INSERT INTO mn_orderitems (order_id, product_id, orderitem_name, orderitem_quantity, orderitem_price, orderitem_final_price) VALUES
        ('" . $_SESSION['neworderid'] . "', '" . $item->product_id . "', '" . $item->orderitem_name . "', '" . $item->orderitem_quantity . "', '" . $item->orderitem_price . "', '" . $item->orderitem_final_price . "')";  
    $result = mysql_query($qry);  
    if (!$result) {  
        echo "Error";  
    } else {  
        echo "Saved";  
    }  
    echo 'Empty';  
}  

Problem:
"When I try to echo the $_SESSION['neworderid']; it outputs = 8152269414
But when it is being save to database the order_id changes to 2147483647".

This only happens in live server. No problem in my localhost Apache.

Answer 1

The problem you are having is not with the PHP script itself, but your database structure. In MySQL the biggest number you can store (declared as INT) is 2147483647. If you want to store bigger numbers, you'll have to either change the script to generate a lower number OR change the DB to use BIGINT.