欢迎各位兄弟 发布技术文章
这里的技术是共享的
I need a simple code to check if a record exists in a db table. I found this code which does what I want though db_result no longer exists in D7.$exists = db_result(db_query('SELECT 1 FROM {artistfield} WHERE uid = %d', $user->uid));
How would I write this statement in D7?
PHP Fatal error: Call to undefined function db_result() in adsense_search.install on line 14
db_result is not available for Drupal 7, I think.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | 673 bytes | tashaharrison80 |
| File | Size |
|---|---|
| 673 bytes |
Simple fix, replacement for db_result.
$sql = db_query("SELECT name FROM {variable} WHERE name LIKE 'adsense_search__%'",
array('adsense_search_%'))->fetchCol();
$count = count($sql);
if ($count != 0) {
for ($i = 0; $i <= $count; $i++) {
variable_del($sql[$i]);
}
}
Comments
Just getting used to D7
Just getting used to D7 myself, does something like the below work?
Log in or register to post comments
Yeah I don't think there's an
Yeah I don't think there's an equivalent of db_result(). That's the closest I've found, so note that you will get an object, which means you need to check it with
$result->1or similar instead of just$result.Log in or register to post comments
Think I got it
How about something like this...
Got that from here..
http://api.drupal.org/api/drupal/includes--database.pgsql.inc/function/d...
Log in or register to post comments
Oooooh now I think I remember
Oooooh now I think I remember seeing that before too. Thanks.
Log in or register to post comments
That was just what I was
That was just what I was looking for! All works great now!
Thanks guys!!!
Log in or register to post comments
Alternative way to write db_result
If you are working in a migration project from d6 to d7 and if there are multiple occurrence of db_result in your custom module you can simply write the below function in any of your custom module without changing the same.