Select data from database with prefix and key with multiple where condition

Question

hello there I have PHP query that Fetch Records from a database with where condition I have four pages in WebSite I want to Fetch data from DataBase with where Condition Ever pages Fetch own Content From database Through link It's my query that's not work

Prefix already in config file

$prefix     = 'v1_';

$link = $p['link'] ;
    $data_query = $db->query("
        SELECT * FROM ".$prefix.$key." 
        WHERE "$p['link'] = $link "
      ");

In WebSite pages are Define with key $x

$x = 'about';
$pages[$x]['title']  = 'About Us';
$pages[$x]['link']   = 'about_us';
$pages[$x]['source'] = 0;

and same variable and own info in both pages

$x = 'objects';
$x = 'services';

and I'm using this query in website its work fine but now I want to change that I mention above details

 $data_query = $db->query("
    SELECT * FROM ".$prefix.$key." 
    WHERE online = 1 ;
  ");

Any contributors to this post, I thank you for your help :)

Stoycho Trenchev · Accepted Answer · 2016-09-17 06:35:50Z

0

Try this:

$data_query = $db->query("SELECT * FROM {$table} WHERE link = {$link}");

answered Sep 17, 2016 at 6:35

Stoycho Trenchev

5554 silver badges12 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:08:19Z

0

you can use LIKE query

eg.

SELECT * <TABLE_NAME> WHERE COLUMN_NAME LIKE '<prefix>%'

For multiple where condition read this answere

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Sep 17, 2016 at 7:13

Hiren Makwana

2,1462 gold badges16 silver badges30 bronze badges

Collectives™ on Stack Overflow

Select data from database with prefix and key with multiple where condition

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related