Javascript alert

[Alistair4267]

Hi All

 

I have the following code which works great but i can't seem to figure out how to get the "result" from the database to be displayed in a alert box. Please could someone point me in the right direction or sugguest some way i could achieve this.

<?php
$dbhost = 'localhost:3036';
$dbuser = 'Dbuser';
$dbpass = 'Mypassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
$sql = 'SELECT page_id FROM page WHERE page_id=112';

mysql_select_db('my_wiki');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
    echo "Page ID :{$row['page_id']}  <br> ".
              "--------------------------------<br>";
}
echo "Fetched data successfully\n";
mysql_close($conn);
?>

[cyberRobot]

To get a message to appear inside a JavaScript alert box, you could do something like this:

<?php
echo "<script type='text/javascript'>alert('message for the alert box goes here');</script>";
?>

Of course, the code needs to be customized to fit your code.

[codefossa]

Instead of using echo inside of your while loop, just put the content into a variable.  Also, javascript alerts use \n rather than <br />.  It can't display HTML.

 

 

<?php

$content = "";

while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
    $content .= "Page ID :{$row['page_id']}" . "\n"
        . "--------------------------------" . "\n";
}

echo '
    <script type="text/javascript">
        window.addEventListener("load", function()
        {
            alert("' . $content . '");
        });
    </script>';

?>

 

Though, if you wanted to alert each one separately, you would just open the <script> before the while loop, close it after, and each row would echo out an alert.

[Alistair4267]

Hi

 

The above code works a treat (cheers).

 

I have change the "page_id" to page_title but the alert box is coming back a "Null" ?? I can confirm that the .php file is saved as UFT-8 so i am a little stumped on how to resolve this. 

 

Cheers

Alistair

[Alistair4267]

Hi

 

Please ignore the above, i was looking at a different script.

 

I am now getting "Object doesn't support this property or method"  

 

Cheers

Alistair

[cyberRobot]

Please post the updated code.

[nogray]

JavaScript does not support multi line strings. If you use the example by Xaotique, you need to use json_encode to make sure the string is a valid JavaScript string

 

e.g. alert(" . json_encode($content) . ");
 

[Irate]

Actually, alert and basically everything else supports the newline escape sequence in JavaScript.

[nogray]

JavaScript supports the new line escape sequence, but the string in the example is created in PHP and will be outputted with new line character (not a new line escape sequence).

[codefossa]

He's right.  I didn't test it, just threw it up quick.  When storing it in a variable, you need to use single quotes to hold the new line so "\n" gets sent rather than the new line character.

 

$works = "one line" . '\n' . "and another";

$doesnt = "one line" . "\n" . "that new line char broke the script";

[Irate]

Of course, my bad, quote issues there.

[Alistair4267]

HI All

 

This is my updated code.

<?php

$dbhost = 'localhost:3036';
$dbuser = 'Dbuser';
$dbpass = 'MyPassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}

$sql = "SELECT  t.old_text FROM
my_wiki.page p  INNER JOIN my_wiki.revision r  ON p.page_latest = r.rev_id
                INNER JOIN my_wiki.text t ON r.rev_text_id = t.old_id
                WHERE p.page_id = 208";

mysql_select_db('my_wiki.text');

$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not get data...' . mysql_error());
}

$content = "";

while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
   $content .= "(text from the page : {$row['t.old_text']}";
}
echo '
    <script type="text/javascript">
        {
        alert(' . {$content} . ');
        }
    </script>';

?>

For some reason nothing happens.

 

Cheers

Alistair

[Ch0cu3r]

The value of alert() needs to be wrapped in quotes

        alert("' . {$content} . '");

[Alistair4267]

Ah thanks for that, I now have the alert box showing up  but all it shows is "text from the page:" and no variable

 

I bet i have missed something very simple but i just can't see it

 

Cheers

Alistair

[Ch0cu3r]

$row['t.old_text'] should be $row['old_text']

[Alistair4267]

Just like to add i now get "Undefined index: t_old_text on line 29

 

$content .= "(text from the page : {$row['t.old_text']}";

 

Not sure why ??

 

Cheers

Alistair

[Alistair4267]

Oh my God, it's working 

 

THANK you 

[cyberRobot]

Side note: when fetching results, you could use mysql_fetch_assoc() instead of modifying mysql_fetch_array().

http://www.php.net/manual/en/function.mysql-fetch-assoc.php

 

For example:

while($row = mysql_fetch_assoc($retval))

Also, you're probably already aware that the mysql_ functions have been depreciated. If not, you should start looking into a different API:

http://www.php.net/manual/en/mysqlinfo.api.choosing.php