how to add int number of array to variable

Question

$pagename = 'index.html';
$dbh = connectDb();
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $dbh->query("select 'tcount' from accessNum where pagename = '$pagename'");
$record = $stmt->fetchAll();

if (sizeof($stmt) != 0) {
    $counter = $record['tcount'];
    $counter++;
    $dbh->exec("update accessNum set tcount = '$counter' where pagename = '$pagename'");
}

mysql (table name is accessNum) is
pagename(varchar(255)) = index.html,
today(date) = 2015-08-31,
tcount(int(11)) = 1,
totalcount(int(11)) = 1,

the tcount keeps 1 every update. why it occurs?

Doing `select 'tcount'` will *literally* select the string `'tcount'`. It will not get the value of the column. It's like doing `SELECT 1`. — gen_Eric, Aug 31 '15 at 14:07

score 0 · Answer 1 · answered Aug 31 '15 at 13:49

0

If you work with int you don't need quotes on variable like this

if (sizeof($stmt) != 0) {
    $counter = $record['tcount'];
    $counter++;
    $dbh->exec("update accessNum set tcount = $counter where pagename = '$pagename'");
}

answered Aug 31 '15 at 13:49

bicho

134
1
11

score 0 · Answer 2 · answered Aug 31 '15 at 13:50

You do not need quotes around a column name in a SELECT query

$stmt = $dbh->query("select tcount from accessNum where pagename = '$pagename'");

Also, you do not need quotes around a number in an UPDATE query

$dbh->exec("update accessNum set tcount = $counter where pagename = '$pagename'");

score 0 · Answer 3 · answered Aug 31 '15 at 13:51

Always escape column and table names with backticks, and values with quotes. They're quite different in MySQL. This should work:

$pagename = 'index.html';
$dbh = connectDb();
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $dbh->query("select `tcount` from `accessNum` where `pagename` = '$pagename'");
$record = $stmt->fetchAll();

if (sizeof($stmt) != 0) {
    $counter = $record['tcount'];
    $counter++;
    $dbh->exec("update `accessNum` set `tcount` = '$counter' where `pagename` = '$pagename'");
}

how to add int number of array to variable

3 Answers3