calling a javascript alert from php

**Chuck Anderson** · Jul 13 '06, 08:35 PM

Re: calling a javascript alert from php

monomaniac21 wrote:

hi i want to be able to trigger a javascript style popup alert in php
(i want a message displayed on the actual page) is this possible?
>
>

I'll take this one ... all I usually do here is ask questions.

The answer to your question is No. Php is run on the *server before* the
page is displayed. Therefore, Php cannot popup an alert like JavaScript
(which runs on the *client computer after* the page is loaded).

That said; if you want to implement a two step procedure like

(1) Delete this file.
(2) Are you Sure (Y or N)?

You can do that with Php, but clicking on (1) must create a request to
the server to display a new page with (2) as a form or hyperlinks.
Clicking on Y or N must return to the server again in able to perform
the action.

--
*************** **************
Chuck Anderson • Boulder, CO

http://www.CycleTourist.com

Everyone's journey should be different,
so that we all are enriched
in new and endless ways
*************** **************

**David Haynes** · Jul 13 '06, 08:35 PM

Re: calling a javascript alert from php

Chuck Anderson wrote:

monomaniac21 wrote:

>hi i want to be able to trigger a javascript style popup alert in php
>(i want a message displayed on the actual page) is this possible?
>>
>>

I'll take this one ... all I usually do here is ask questions.
>
The answer to your question is No. Php is run on the *server before* the
page is displayed. Therefore, Php cannot popup an alert like JavaScript
(which runs on the *client computer after* the page is loaded).
>
That said; if you want to implement a two step procedure like
>
(1) Delete this file.
(2) Are you Sure (Y or N)?
>
You can do that with Php, but clicking on (1) must create a request to
the server to display a new page with (2) as a form or hyperlinks.
Clicking on Y or N must return to the server again in able to perform
the action.
>

or you can have the php spit out the javascript as part of the page and
trigger it from the onclick= in the submit.

-david-

**Chuck Anderson** · Jul 13 '06, 11:15 PM

Re: calling a javascript alert from php

David Haynes wrote:

Chuck Anderson wrote:
>

>monomaniac21 wrote:
>>

>>hi i want to be able to trigger a javascript style popup alert in php
>>(i want a message displayed on the actual page) is this possible?
>>>
>>>
>>>

>I'll take this one ... all I usually do here is ask questions.
>>
>The answer to your question is No. Php is run on the *server before* the
>page is displayed. Therefore, Php cannot popup an alert like JavaScript
>(which runs on the *client computer after* the page is loaded).
>>
>That said; if you want to implement a two step procedure like
>>
>(1) Delete this file.
>(2) Are you Sure (Y or N)?
>>
>You can do that with Php, but clicking on (1) must create a request to
>the server to display a new page with (2) as a form or hyperlinks.
>Clicking on Y or N must return to the server again in able to perform
>the action.
>>
>>

or you can have the php spit out the javascript as part of the page and
trigger it from the onclick= in the submit.
>
-david-

But that's not "triggered in Php" and is simply JavaScript.

--
*************** **************
Chuck Anderson • Boulder, CO

http://www.CycleTourist.com

Everyone's journey should be different,
so that we all are enriched
in new and endless ways
*************** **************

**David Haynes** · Jul 13 '06, 11:35 PM

Re: calling a javascript alert from php

Chuck Anderson wrote:

David Haynes wrote:

>Chuck Anderson wrote:
>>

>>monomaniac2 1 wrote:
>>>
>>>hi i want to be able to trigger a javascript style popup alert in php
>>>(i want a message displayed on the actual page) is this possible?
>>>>
>>>>
>>I'll take this one ... all I usually do here is ask questions.
>>>
>>The answer to your question is No. Php is run on the *server before*
>>the page is displayed. Therefore, Php cannot popup an alert like
>>JavaScript (which runs on the *client computer after* the page is
>>loaded).
>>>
>>That said; if you want to implement a two step procedure like
>>>
>>(1) Delete this file.
>>(2) Are you Sure (Y or N)?
>>>
>>You can do that with Php, but clicking on (1) must create a request
>>to the server to display a new page with (2) as a form or hyperlinks.
>>Clicking on Y or N must return to the server again in able to perform
>>the action.
>>>
>>>

>or you can have the php spit out the javascript as part of the page and
>trigger it from the onclick= in the submit.
>>
>-david-

But that's not "triggered in Php" and is simply JavaScript.
>

Yes, but you had already provided "you can't get there from here"
answer. Sometimes it pays to offer alternatives rather than just to
answer the question someone has asked.

-david-

**Norman Peelman** · Jul 13 '06, 11:35 PM

Re: calling a javascript alert from php

"monomaniac 21" <mcyi2mr3@googl email.comwrote in message
news:1152819416 .271145.137020@ 35g2000cwc.goog legroups.com...

hi i want to be able to trigger a javascript style popup alert in php
(i want a message displayed on the actual page) is this possible?
>

Not by PHP alone but have a look at http://www.xajaxproject.org/ to things
like this...

Norm

**IchBin** · Jul 14 '06, 12:05 AM

Re: calling a javascript alert from php

David Haynes wrote:

Chuck Anderson wrote:

>David Haynes wrote:

>>Chuck Anderson wrote:
>>>
>>>monomaniac 21 wrote:
>>>>
>>>>hi i want to be able to trigger a javascript style popup alert in php
>>>>(i want a message displayed on the actual page) is this possible?
>>>>>
>>>>>
>>>I'll take this one ... all I usually do here is ask questions.
>>>>
>>>The answer to your question is No. Php is run on the *server before*
>>>the page is displayed. Therefore, Php cannot popup an alert like
>>>JavaScript (which runs on the *client computer after* the page is
>>>loaded).
>>>>
>>>That said; if you want to implement a two step procedure like
>>>>
>>>(1) Delete this file.
>>>(2) Are you Sure (Y or N)?
>>>>
>>>You can do that with Php, but clicking on (1) must create a request
>>>to the server to display a new page with (2) as a form or
>>>hyperlinks . Clicking on Y or N must return to the server again in
>>>able to perform the action.
>>>>
>>>>
>>or you can have the php spit out the javascript as part of the page and
>>trigger it from the onclick= in the submit.
>>>
>>-david-

>But that's not "triggered in Php" and is simply JavaScript.
>>

Yes, but you had already provided "you can't get there from here"
answer. Sometimes it pays to offer alternatives rather than just to
answer the question someone has asked.
>
-david-
>

I am following this thread because I am trying to do the same thing.
Problem is I do not know php\javascript all that well. I had posed my
code to this newsgroup but received no answer. So I do not know if I can
do what I am trying to do or I am just so far off that it does not
warent an answer. This is what I have so far. I can not get to work and
have comment out what I am trying:

//
// Handle the data coming back
echo '<FORM NAME=author method=post action='.$_SERV ER['PHP_SELF'].'>';
//echo '<SELECT NAME=author_pk SIZE=20 COLS=20 ONCHANGE='.$_PO ST[id].'>';
//echo '<SELECT NAME=author_pk SIZE=20 COLS=20 ONCHANGE=getPK( )>';
echo '<SELECT NAME=author_pk SIZE=20 COLS=20>';

while ($rows = mysql_fetch_obj ect($result)) {
echo '<OPTION VALUE='.$rows->id.'>'.
$rows->TITLE.' '.
$rows->lastname.', '.
$rows->firstname.
$rows->middlename.
$rows->SUFFIX.
'</OPTION>';
}
echo '</SELECT>';
echo '</FORM>';
//echo '<script language=Javasc ript>';
//echo 'function getPK() {';
//echo
"document.autho r.author_pk.opt ions[document.author .author_pk.sele ctedIndex].value
";
//echo '}';
//echo "</script>";

--

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
_______________ _______________ _______________ _______________ ______________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

**IchBin** · Jul 14 '06, 12:05 AM

Re: calling a javascript alert from php

David Haynes wrote:

Chuck Anderson wrote:

>David Haynes wrote:

>>Chuck Anderson wrote:
>>>
>>>monomaniac 21 wrote:
>>>>
>>>>hi i want to be able to trigger a javascript style popup alert in php
>>>>(i want a message displayed on the actual page) is this possible?
>>>>>
>>>>>
>>>I'll take this one ... all I usually do here is ask questions.
>>>>
>>>The answer to your question is No. Php is run on the *server before*
>>>the page is displayed. Therefore, Php cannot popup an alert like
>>>JavaScript (which runs on the *client computer after* the page is
>>>loaded).
>>>>
>>>That said; if you want to implement a two step procedure like
>>>>
>>>(1) Delete this file.
>>>(2) Are you Sure (Y or N)?
>>>>
>>>You can do that with Php, but clicking on (1) must create a request
>>>to the server to display a new page with (2) as a form or
>>>hyperlinks . Clicking on Y or N must return to the server again in
>>>able to perform the action.
>>>>
>>>>
>>or you can have the php spit out the javascript as part of the page and
>>trigger it from the onclick= in the submit.
>>>
>>-david-

>But that's not "triggered in Php" and is simply JavaScript.
>>

Yes, but you had already provided "you can't get there from here"
answer. Sometimes it pays to offer alternatives rather than just to
answer the question someone has asked.
>
-david-
>

I am following this thread because I am trying to do something simular.
That is pass value back to php on a select ONCHANGE=. Problem is I do
not know php\javascript all that well. I had posted my code to this
newsgroup but received no answer. So I do not know if I can do what I am
trying to do or I am just so far off that it does not warent an answer.
This is what I have so far. I can not get to work and have comment out
what I am trying:

//
// Handle the data coming back
echo '<FORM NAME=author method=post action='.$_SERV ER['PHP_SELF'].'>';
//echo '<SELECT NAME=author_pk SIZE=20 COLS=20 ONCHANGE='.$_PO ST[id].'>';
//echo '<SELECT NAME=author_pk SIZE=20 COLS=20 ONCHANGE=getPK( )>';
echo '<SELECT NAME=author_pk SIZE=20 COLS=20>';

while ($rows = mysql_fetch_obj ect($result)) {
echo '<OPTION VALUE='.$rows->id.'>'.
$rows->TITLE.' '.
$rows->lastname.', '.
$rows->firstname.
$rows->middlename.
$rows->SUFFIX.
'</OPTION>';
}
echo '</SELECT>';
echo '</FORM>';
//echo '<script language=Javasc ript>';
//echo 'function getPK() {';
//echo
"document.autho r.author_pk.opt ions[document.author .author_pk.sele ctedIndex].value
";
//echo '}';
//echo "</script>";

--

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
_______________ _______________ _______________ _______________ ______________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

**Rik** · Jul 14 '06, 01:05 AM

Re: calling a javascript alert from php

IchBin wrote:

I am following this thread because I am trying to do something
simular.
That is pass value back to php on a select ONCHANGE=. Problem is I do
not know php\javascript all that well. I had posted my code to this
newsgroup but received no answer. So I do not know if I can do what I
am
trying to do or I am just so far off that it does not warent an
answer.

javascript/HTML is just plain text to PHP, you're better of asking an a
javascript group how you should accomplish what you're trying, get the
javascript code for that, and then build it in PHP.

What is it exactly you're trying to accomplish, because I can't make it out
from the following code?
(and BTW: <selectdoesn' t have a cols attribute...).

This is what I have so far. I can not get to work and have comment out
what I am trying:
>
//
// Handle the data coming back
echo '<FORM NAME=author method=post action='.$_SERV ER['PHP_SELF'].'>';
//echo '<SELECT NAME=author_pk SIZE=20 COLS=20
ONCHANGE='.$_PO ST[id].'>'; //echo '<SELECT NAME=author_pk SIZE=20
COLS=20 ONCHANGE=getPK( )>';
echo '<SELECT NAME=author_pk SIZE=20 COLS=20>';
>
while ($rows = mysql_fetch_obj ect($result)) {
echo '<OPTION VALUE='.$rows->id.'>'.
$rows->TITLE.' '.
$rows->lastname.', '.
$rows->firstname.
$rows->middlename.
$rows->SUFFIX.
'</OPTION>';
}
echo '</SELECT>';
echo '</FORM>';
//echo '<script language=Javasc ript>';
//echo 'function getPK() {';
//echo
>

"document.autho r.author_pk.opt ions[document.author .author_pk.sele ctedIndex].
value

";
//echo '}';
//echo "</script>";

I really just know the basics of javascript, but:

--------------------------------------------------------
<script type="text/javascript">
function getPK(arg){
alert(arg);
}
</script>
<form name="testform" >
<select name="author_pk " size="20"
onchange="getPK (this.options[this.selectedIn dex].value)">
<option value="first">f oo</option>
<option value="another" >bar</option>
<option value="last">ba z</option>
</select>
</form>
--------------------------------------------------------

or alternatively:
--------------------------------------------------------
<script type="text/javascript">
function getPK(){

alert(document. testform.author _pk.options[document.testfo rm.author_pk.se lect
edIndex].value);
}
</script>
<form name="testform" >
<select name="author_pk " size="20"
onchange="getPK (this.options[this.selectedIn dex].value)">
<option value="first">f oo</option>
<option value="another" >bar</option>
<option value="last">ba z</option>
</select>
</form>
--------------------------------------------------------

or, if you make & know an ID:
--------------------------------------------------------
<script type="text/javascript">
function getPK(){
selectbox = document.getEle mentById('autho r_pk');
alert(selectbox .options[selectbox.selec tedIndex].value);
}
</script>
</head>
<body>
<form name="testform" >
<select id="author_pk" name="author_pk " size="20" onchange="getPK ()">
<option value="first">f oo</option>
<option value="another" >bar</option>
<option value="last">ba z</option>
</select>
</form>
--------------------------------------------------------

That's how you can get the value.

Now, passing it back to PHP? That will require a trip to the server, and why
would you want to know it before the form is submitted? As it requires a
trip to the server, you could just as easily read the $_POST value.

If you want to do something on your page after selecting the something, you
either should have sent al the relevant info to the server in the HTML or in
js, or you'd have to make use of XMLHTTPRequests
(http://ajaxpatterns.org/XMLHttpRequest_Call).

That's going a bit to far in this group, I'd say: check the pointers, and if
things are unclear, ask comp.lang.javas cript.

--
Rik Wasmus

**David Haynes** · Jul 14 '06, 01:15 AM

Re: calling a javascript alert from php

IchBin wrote:

I am following this thread because I am trying to do something simular.
That is pass value back to php on a select ONCHANGE=. Problem is I do
not know php\javascript all that well. I had posted my code to this
newsgroup but received no answer. So I do not know if I can do what I am
trying to do or I am just so far off that it does not warent an answer.
This is what I have so far. I can not get to work and have comment out
what I am trying:
>
//
// Handle the data coming back
echo '<FORM NAME=author method=post action='.$_SERV ER['PHP_SELF'].'>';
//echo '<SELECT NAME=author_pk SIZE=20 COLS=20 ONCHANGE='.$_PO ST[id].'>';
//echo '<SELECT NAME=author_pk SIZE=20 COLS=20 ONCHANGE=getPK( )>';
echo '<SELECT NAME=author_pk SIZE=20 COLS=20>';
>
while ($rows = mysql_fetch_obj ect($result)) {
echo '<OPTION VALUE='.$rows->id.'>'.
$rows->TITLE.' '.
$rows->lastname.', '.
$rows->firstname.
$rows->middlename.
$rows->SUFFIX.
'</OPTION>';
}
echo '</SELECT>';
echo '</FORM>';
//echo '<script language=Javasc ript>';
//echo 'function getPK() {';
//echo
"document.autho r.author_pk.opt ions[document.author .author_pk.sele ctedIndex].value
";
//echo '}';
//echo "</script>";

IchBin:
You don't need to use javascript at all to do what you want to do.
You can simply let PHP do all the work.
Take a look at this example based upon your posting:

<?php
// an example of a monolithic form processor in php
// connect to mysql database
// @note: add a lot more error checking.
mysql_connect($ hostname, $username, $password);
mysql_select_db ($database);

// This form uses the POST method, so process any post selections here
if( isset($_POST['author_pk']) ) {
// do whatever you need to do with the author_pk
$sql = "select * from book_detail where author_pk = {$_POST['author_pk']}";
$detail = mysql_query($sq l);
}

// main form query
$sql = "SELECT * from users order by lastname, firstname, middlename ";
$result = mysql_query($sq l);

mysql_close();
?>
<FORM NAME="author" method="post" action="<?php echo
$_SERVER['PHP_SELF'];?>"
<SELECT NAME="author_pk " SIZE="20" COLS="20">
<?php
// a loop to populate the select options
while( $row = mysql_fetch_obj ect($result) ) {
printf("<option value=\"%d\">%s , %s, %s, %s, %s</option>\n",
$row->id, $row->TITLE, $row->lastname,
$row->firstname, $row->middlename, $row->SUFFIX);
}
mysql_free_resu lt($result);

// display any book details based on the user's selection
if( isset($detail) ) {
while( $row = mysql_fetch_ass oc($detail) ) {
printf("Title: %s<br>\n", $row['title']);
}
}
?>
</SELECT>
</FORM>

**IchBin** · Jul 14 '06, 07:45 AM

Re: calling a javascript alert from php

David Haynes wrote:

IchBin wrote:

>I am following this thread because I am trying to do something
>simular. That is pass value back to php on a select ONCHANGE=. Problem
>is I do not know php\javascript all that well. I had posted my code to
>this newsgroup but received no answer. So I do not know if I can do
>what I am trying to do or I am just so far off that it does not warent
>an answer. This is what I have so far. I can not get to work and have
>comment out what I am trying:
>>
>//
>// Handle the data coming back
>echo '<FORM NAME=author method=post action='.$_SERV ER['PHP_SELF'].'>';
>//echo '<SELECT NAME=author_pk SIZE=20 COLS=20 ONCHANGE='.$_PO ST[id].'>';
>//echo '<SELECT NAME=author_pk SIZE=20 COLS=20 ONCHANGE=getPK( )>';
>echo '<SELECT NAME=author_pk SIZE=20 COLS=20>';
>>
>while ($rows = mysql_fetch_obj ect($result)) {
> echo '<OPTION VALUE='.$rows->id.'>'.
> $rows->TITLE.' '.
> $rows->lastname.', '.
> $rows->firstname.
> $rows->middlename.
> $rows->SUFFIX.
> '</OPTION>';
>}
>echo '</SELECT>';
>echo '</FORM>';
>//echo '<script language=Javasc ript>';
>//echo 'function getPK() {';
>//echo
>"document.auth or.author_pk.op tions[document.author .author_pk.sele ctedIndex].value
>";
>//echo '}';
>//echo "</script>";

>
IchBin:
You don't need to use javascript at all to do what you want to do.
You can simply let PHP do all the work.
Take a look at this example based upon your posting:
>
<?php
// an example of a monolithic form processor in php
// connect to mysql database
// @note: add a lot more error checking.
mysql_connect($ hostname, $username, $password);
mysql_select_db ($database);
>
// This form uses the POST method, so process any post selections here
if( isset($_POST['author_pk']) ) {
// do whatever you need to do with the author_pk
$sql = "select * from book_detail where author_pk =
{$_POST['author_pk']}";
$detail = mysql_query($sq l);
}
>
// main form query
$sql = "SELECT * from users order by lastname, firstname, middlename ";
$result = mysql_query($sq l);
>
mysql_close();
?>
<FORM NAME="author" method="post" action="<?php echo
$_SERVER['PHP_SELF'];?>"
<SELECT NAME="author_pk " SIZE="20" COLS="20">
<?php
// a loop to populate the select options
while( $row = mysql_fetch_obj ect($result) ) {
printf("<option value=\"%d\">%s , %s, %s, %s, %s</option>\n",
$row->id, $row->TITLE, $row->lastname,
$row->firstname, $row->middlename, $row->SUFFIX);
}
mysql_free_resu lt($result);
>
// display any book details based on the user's selection
if( isset($detail) ) {
while( $row = mysql_fetch_ass oc($detail) ) {
printf("Title: %s<br>\n", $row['title']);
}
}
?>
</SELECT>
</FORM>
>

David, thank you so much for helping me out. I do not have much more
hair to pull out. I am a Java person. Anyway, I understand a lot more
after you sample code.

As an aside, this is my own little project to learn php and etc. I
already have a complete Java\swing application written around this DB so
I figure I could lean away from J2EE and try PHP. It is a different animal.

This DB is a Quotes DB. I have been building over the last few years.
Just a personal interest. I have around 1300 authors and over 32,000
quotes along with detail\quote like external Links and references for
each quote. And naturally detail information about the author.

I did mix your code with mine. The only problem I am having is with the
dropdown object. When I run the program the following displays: on and
on and not in the dropdown..

, , , , , Abbey, Edward, , , Abbott, William, Alexander, , Abelard,
Pete, , , Accius, Lucius, , , Acheson, Dean, , , Ackerman, Diane, , ,
Adams, Abigail, Smith, , Adams, Ansel, , , Adams, Bryan, , , Adams,
Douglas, , , Adams, Franklin, Pierce, , Adams, Henry, , , Adams, Joey,
Lauren, , Adams, John, , , Adams, John, Quincy, , Adams, Scott, , ,
Addison, Joseph, , , Ade, George, , , Adler, Alfred, , , Adler,
Mortimer, Jerome, , Adorno, Theodor, , , Aeschylus, , , , Aesop, , , ,
Afer, Publius, Terentius, , Agathon, , , , Agesilaus, , , II , Aiken,
George, , , Aiken, Howard, , , Alcott, Amos, Bronson, , Alcott, Louisa,
May, , Alcuinus or Ealhwine, Flaccus, Albinu, , Alda, Alan, , ,
Alexander, Shana, , , Ali-Haj, Muhammad, , , Allen, Fred, , , Allen,
Woody, , , Alzado, Lyle, , , Amiel, Henri-Frédéric, , , Amory,
Cleveland, , , Anaxagoras, , , , Ancient Chinese Curse, , , , Andersen,
Hans, Christian, , Angell, George, Thorndike, , Angelou, Maya, , The
Princess, Anne, , , , Princess Royal , Anonymous, , , , Anouilh, Jean, ,
Saint, Anselm, , , of Canterbury , Anthony, Susan, B., , Antiphanes, , ,
, Antisthenes,

Here is the code but I guess the concern is the dropdown.

<?php
//
// Open DB
include 'library/opendb.php';

// This form uses the POST method, so process any post selections here
if( isset($_POST['author_pk']) ) {
// do whatever you need to do with the author_pk
// $sql = "select * from book_detail where author_pk =
{$_POST['author_pk']}";
// $detail = mysql_query($sq l);
}
//
// main form query
$sqlcmd = 'select id, TITLE, lastname, firstname, middlename, SUFFIX
from author_detail order by lastname, firstname, middlename';
$result = mysql_query($sq lcmd);
if (!$result) {
die('Database Error: ' . mysql_error());
exit;
}
//
// Close DB
include 'library/closedb.php';
?>

<FORM NAME="author" method="post" action="<?php echo
$_SERVER['PHP_SELF'];?>"
<SELECT NAME="author_pk " SIZE="20" COLS="20">

<?php
// a loop to populate the select options
while( $row = mysql_fetch_obj ect($result) ) {
printf("<option value=\"%d\">%s , %s, %s, %s, %s</option>\n",
$row->id, $row->TITLE, $row->lastname,
$row->firstname, $row->middlename, $row->SUFFIX);
}

mysql_free_resu lt($result);

// display any book details based on the user's selection
if( isset($detail) ) {
// while( $row = mysql_fetch_ass oc($detail) ) {
// printf("Title: %s<br>\n", $row['title']);
// }
}
?>
</SELECT>
</FORM>

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
_______________ _______________ _______________ _______________ ______________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

**David Haynes** · Jul 14 '06, 10:35 AM

Re: calling a javascript alert from php

IchBin wrote:

David, thank you so much for helping me out. I do not have much more
hair to pull out. I am a Java person. Anyway, I understand a lot more
after you sample code.
>
As an aside, this is my own little project to learn php and etc. I
already have a complete Java\swing application written around this DB so
I figure I could lean away from J2EE and try PHP. It is a different animal.
>
This DB is a Quotes DB. I have been building over the last few years.
Just a personal interest. I have around 1300 authors and over 32,000
quotes along with detail\quote like external Links and references for
each quote. And naturally detail information about the author.
>
I did mix your code with mine. The only problem I am having is with the
dropdown object. When I run the program the following displays: on and
on and not in the dropdown..
>
, , , , , Abbey, Edward, , , Abbott, William, Alexander, , Abelard,
Pete, , , Accius, Lucius, , , Acheson, Dean, , , Ackerman, Diane, , ,
Adams, Abigail, Smith, , Adams, Ansel, , , Adams, Bryan, , , Adams,
Douglas, , , Adams, Franklin, Pierce, , Adams, Henry, , , Adams, Joey,
Lauren, , Adams, John, , , Adams, John, Quincy, , Adams, Scott, , ,
Addison, Joseph, , , Ade, George, , , Adler, Alfred, , , Adler,
Mortimer, Jerome, , Adorno, Theodor, , , Aeschylus, , , , Aesop, , , ,
Afer, Publius, Terentius, , Agathon, , , , Agesilaus, , , II , Aiken,
George, , , Aiken, Howard, , , Alcott, Amos, Bronson, , Alcott, Louisa,
May, , Alcuinus or Ealhwine, Flaccus, Albinu, , Alda, Alan, , ,
Alexander, Shana, , , Ali-Haj, Muhammad, , , Allen, Fred, , , Allen,
Woody, , , Alzado, Lyle, , , Amiel, Henri-Frédéric, , , Amory,
Cleveland, , , Anaxagoras, , , , Ancient Chinese Curse, , , , Andersen,
Hans, Christian, , Angell, George, Thorndike, , Angelou, Maya, , The
Princess, Anne, , , , Princess Royal , Anonymous, , , , Anouilh, Jean, ,
Saint, Anselm, , , of Canterbury , Anthony, Susan, B., , Antiphanes, , ,
, Antisthenes,
>
Here is the code but I guess the concern is the dropdown.
>
<?php
//
// Open DB
include 'library/opendb.php';
>
// This form uses the POST method, so process any post selections here
if( isset($_POST['author_pk']) ) {
// do whatever you need to do with the author_pk
// $sql = "select * from book_detail where author_pk =
{$_POST['author_pk']}";
// $detail = mysql_query($sq l);
}
//
// main form query
$sqlcmd = 'select id, TITLE, lastname, firstname, middlename, SUFFIX
from author_detail order by lastname, firstname, middlename';
$result = mysql_query($sq lcmd);
if (!$result) {
die('Database Error: ' . mysql_error());
exit;
}
//
// Close DB
include 'library/closedb.php';
?>
>
<FORM NAME="author" method="post" action="<?php echo
$_SERVER['PHP_SELF'];?>"
<SELECT NAME="author_pk " SIZE="20" COLS="20">
>
<?php
// a loop to populate the select options
while( $row = mysql_fetch_obj ect($result) ) {
printf("<option value=\"%d\">%s , %s, %s, %s, %s</option>\n",
$row->id, $row->TITLE, $row->lastname,
$row->firstname, $row->middlename, $row->SUFFIX);
}
>
mysql_free_resu lt($result);
>
// display any book details based on the user's selection
if( isset($detail) ) {
// while( $row = mysql_fetch_ass oc($detail) ) {
// printf("Title: %s<br>\n", $row['title']);
// }
}
?>
</SELECT>
</FORM>

IchBin:
1. I made a mistake in the sample code I sent you in that the <FORM>
tag is not properly terminated. The line should read:
<FORM NAME="author" method="post" action="<?php echo
$_SERVER['PHP_SELF']'?>">
The last '>' was missing.
2. if you run the SQL query from the mysql command line, do you get
what you expect?
Hint:
Add 'echo $sqlcmd;exit;' after the $sqlcmd= line and then cut and
paste into a mysql command session
3. Adjust the sqlcmd and add 'limit 1' so that only one row is returned
while debugging. If it is still not right, post the code and the output
and I'm sure folks here will be all over it offering advice.

-david-

**IchBin** · Jul 14 '06, 02:15 PM

Re: calling a javascript alert from php

David Haynes wrote:

>
IchBin:
1. I made a mistake in the sample code I sent you in that the <FORM>
tag is not properly terminated. The line should read:
<FORM NAME="author" method="post" action="<?php echo
$_SERVER['PHP_SELF']'?>">
The last '>' was missing.
2. if you run the SQL query from the mysql command line, do you get
what you expect?
Hint:
Add 'echo $sqlcmd;exit;' after the $sqlcmd= line and then cut and
paste into a mysql command session
3. Adjust the sqlcmd and add 'limit 1' so that only one row is returned
while debugging. If it is still not right, post the code and the output
and I'm sure folks here will be all over it offering advice.
>
-david-
>

David, thanks for all your help and tips. The sql is correct.

IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
_______________ _______________ _______________ _______________ ______________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

**Colin McKinnon** · Jul 16 '06, 09:15 PM

Re: calling a javascript alert from php

monomaniac21 wrote:

hi i want to be able to trigger a javascript style popup alert in php
(i want a message displayed on the actual page) is this possible?

print "<scriptalert(' Hello world'); </script>";

(needs some tidying, and watch out for the quotes)

C.

calling a javascript alert from php

calling a javascript alert from php

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment