How can I loop this script that assigns values to variables?

Question

I'm looking to loop the following script, as to save lines of code, and manual hardcoding. The script pulls specific values from my database and assigns them to variables that are used across my website.

    $w1001a = $conn->query("SELECT columnB FROM table WHERE columnA='w1001a' limit 1")->fetch_object()->content; 
    $w1001b = $conn->query("SELECT columnB FROM table WHERE columnA='w1001b' limit 1")->fetch_object()->content; 
    ....
    $w1025b = $conn->query("SELECT columnB FROM table WHERE columnA='w1001b' limit 1")->fetch_object()->content;

Thanks in advance!

Maybe you need to use a IN statement or use a regex for columnA? — Class
– Class, Commented Mar 13, 2014 at 3:35

xdazz · Accepted Answer · 2014-03-13 03:36:55Z

1

Don't loop the query, use one query to get all the info.

The below is just dummy code:

$stmt = $conn->query("SELECT columnA, columnB FROM table WHERE columnA IN ('w1001a', 'w1001b', ...)");
$result = array();
while ($obj = $stmt->fetch_object()) {
  $result[$obj->columnA] = $obj->columnB;
}

answered Mar 13, 2014 at 3:36

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

2 Comments

user2864740 Over a year ago

The query might need a first/one-in-group (i.e. to cover the limit 1), but this is generally a much better approach ..

James Patrick Over a year ago

Thanks @xdazz - Now the data is accessible through $result[w1001a], rather than $w1001a. How would I finish this last step?

Collectives™ on Stack Overflow

How can I loop this script that assigns values to variables?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related