PHP - Column count doesn't match

Question

I've recently trying to add data into a database, (New to php), I've looked over what other people has with this error but yet still I cannot see where I have gone wrong. The error is:

Column count doesn't match value count at row 1

Code:

$dbhost = 'localhost';
$dbuser = 'evocityi_admin';
$dbpass = 'password';
$database = 'evocityi_stocks';
$conn = mysql_connect($dbhost, $dbuser, $dbpass, $database);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}


    $Dtime = "30/04/16";
    $StockName = "FUMUKU";
    $FUMUKUPrice = 1000;
    $sql = "INSERT INTO stocks".
           "(Stock,Price, TimeD) ".
           "VALUES ".
           "('$StockName,$FUMUKUPrice, $DTime')";
    mysql_select_db('evocityi_stocks');
    $retval = mysql_query( $sql, $conn );
    if(! $retval )
    {
      die('Could not enter data: ' . mysql_error());
    }
    echo "Entered data successfully\n";
    mysql_close($conn);
    ?>

SQL Database: https://gyazo.com/e74a6b9e87c18d60855424dcae647cdf

You really shouldn`t use mysql_connect and other mysql functions in PHP anymore since they are removed in PHP 7.0, rather replace them with mysqli equivalent, see php.net/manual/en/book.mysqli.php — Jan Richter
– Jan Richter, Commented Apr 30, 2016 at 11:32

R Singh · Accepted Answer · 2016-04-30 11:13:52Z

1

Change the column type for Stock and TimeD to varchar in your table definition. On the link you posted, they are both int.

answered Apr 30, 2016 at 11:13

R Singh

7651 gold badge5 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

techworld · Accepted Answer · 2016-04-30 11:28:19Z

1

as suggested by @PaulB12345, change column type to varchar and there is error in quotes.

ideally your query should be like (see quotes after values)

$sql = "INSERT INTO stocks".
           "(Stock,Price, TimeD) ".
           "VALUES ".
           "('$StockName','$FUMUKUPrice', '$DTime')";

answered Apr 30, 2016 at 11:28

techworld

3315 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP - Column count doesn't match

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related