PHP get some data from database then echo it out into a JS file

Question

MYSQL table structure: id , name , status , color

how can i use PHP to get some data from my database(mysql) ,the php script will look for table rows that have "good" in the "status" column. Then echo those rows which have good in status(P/S out into a JS file. It also get the color from each row (with status=good) and ptu it into javascript(jQUery)

I did a little research on how to use php to generate javascript.

Here's a php script, it's not working btw:

<?php
header("content-type: application/x-javascript");

  include 'connect.php';
  $sql = "SELECT * FROM users WHERE status ='good'"; 
  $query = mysql_query($sql)or die(mysql_error());

  $rows = array();
while($row = mysql_fetch_array( $query )){
  $rows[] = $row;
  echo "$('a[href*=\"row[username]\"]').css('color', 'row[color]');\n";
}

?>

The out put is (which wont work):

$('a[href*="row[username]"]').css('color', 'row[color]');

The connect.php is working(connects to database) , just the script is not working.

(BTW: The file name of this is usercolor.js.php , is it correct?) I hope someone could guide me.

Thanks and have a wonderful day.

just the script is not working. - in what way is it not working? No output, the javascript is invalid, etc etc - give us a clue! — DaveRandom
– DaveRandom, Commented Dec 1, 2011 at 10:04

Treffynnon · Accepted Answer · 2011-12-01 10:18:27Z

2

echo "$('a[href*=\"row[username]\"]').css('color', 'row[color]');\n";

won't work. Try

$username = $row['username'];
$color = $row['color']; 
echo "$('a[href*=\"$username\"]').css('color', '$color');\n";

or

echo "$('a[href*=\"{$row['username']}\"]').css('color', '{$row['color']}');\n";

see the manual for an explanation. Also, according to your mysql table structure, the column is called name and not username.

edited Dec 1, 2011 at 10:18

Treffynnon

21.6k6 gold badges68 silver badges99 bronze badges

answered Dec 1, 2011 at 10:08

Roman

6,5682 gold badges32 silver badges51 bronze badges

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

3 Comments

Treffynnon Over a year ago

@roman there is a syntax error in your code. Hence my edit. Please refrain from rolling back to broken code.

Roman Over a year ago

@Treffynnon oh, I didn't rollback intentionally, we just edited at the same time. Thanks anyway for correcting the typo.

sm21guy Over a year ago

Thanks for helping me guys , selected as answer

Collectives™ on Stack Overflow

PHP get some data from database then echo it out into a JS file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related