Openning javascript popup with php?

Dakkar

I made a basic site like this and i want when people push the show button a small java script pop up open and show the content of one of my mysql table is it possible with php?

Here is my basic site code:

<html>

<head>
<meta http-equiv="Content-Language" content="tr">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<title>PORTAL</title>
</head>

<body bgcolor="#C0C0C0">

<p align="center"><u><font face="Arial Black" size="4">SYLVERIA PORTAL</font></u></p>
<hr>
<ul>
  <li>
  <p align="left">

<?

@mysql_connect("localhost", "root", "")
    or die("Veritabani ile baglanti kurulamadi!");
@mysql_select_db("portal")
    or die("Veritabaninda bir hata olustu!");


$sql = "SELECT post_subject FROM asd_uo_text WHERE post_id = '1'";
$res = mysql_query($sql) OR die(mysql_error());
$row = mysql_fetch_row($res);

echo ($row[0]);

?>
<form action="duzenle.php" method="get">
<input type="submit" value=" Show "></form> 

</li>
  <li>
  <p align="left">
<?


$sql2 = "SELECT post_subject FROM asd_uo_text WHERE post_id = '2'";
$res2 = mysql_query($sql2) OR die(mysql_error());
$row2 = mysql_fetch_row($res2);

echo ($row2[0]);
?>

<form action="duzenle2.php" method="get">
<input type="submit" value=" Show "></form> 

</li>
  <li>
  <p align="left">
<?

$sql3 = "SELECT post_subject FROM asd_uo_text WHERE post_id = '3'";
$res3 = mysql_query($sql3) OR die(mysql_error());
$row3 = mysql_fetch_row($res3);

echo ($row3[0]);

?>

<form action="duzenle3.php" method="get">
<input type="submit" value=" Show "></form> 

</li>
  <li>
  <p align="left">

<?

$sql4 = "SELECT post_subject FROM asd_uo_text WHERE post_id = '4'";

$res4 = mysql_query($sql4) OR die(mysql_error());
$row4 = mysql_fetch_row($res4);

echo ($row4[0]);

?>


<form action="duzenle4.php" method="get">
<input type="submit" value=" Show"></form> 

</li>
  <li>
  <p align="left">

<?

$sql5 = "SELECT post_subject FROM asd_uo_text WHERE post_id = '5'";
$res5 = mysql_query($sql5) OR die(mysql_error());
$row5 = mysql_fetch_row($res5);

echo ($row5[0]);

?>


<form action="duzenle5.php" method="get">
<input type="submit" value=" Show "></form> 

</li>
</ul>
<p align="left">&nbsp;</p>
<p align="left">&nbsp;</p>

</body>

</html>

Thanks

Weedpacket

You'll be more likely to use Javascript to open a Javascript popup. The PHP script is not running on the visitor's computer, so it's not going to be able to do anything there.

The content delivered by the popup's URL can be generated by PHP; you can add querystring stuff into that URL (like the stuff after the ? in the URL of this page) and the script can use that to look up stuff in the database.

piersk

It is possible to do what you want, but I'd do it like this: (I'm shownig a link instead of a button. the principle is the same(

<a href="phppage.php" onClick="window.open(this.href,'height=100,width=100');">text for link</a>

then in phppage.php you would have the php to generate whatever page you want people to see.

phpprogrammer

Dear Friend,

try this one

<?php

echo"<a href=javascript:window.open('mywindow.php','new','scrollbars=0,resize=no'); >click</a>";

regards
bvsureshbabu

piersk

Yes, that one will work, but if you don't have javascript enabled (like I know a few people haven't) then you way wouldn't work. However, the way I suggested would, althought the data wouldn't appear in a pop-up box, just in the same window.

Dakkar

Thanks it opens a pop up but it doesnt show my content which include in mysql inside of that pop up how can i make it possible
to put my datas into that pop up

piersk

The popup will act as a normal browser window (only a bit smaller), so it will be a problem with your code. Can you post the HTML for the button/link that opens the pop-up please

Dakkar

of course
this is my html code which opens javascript popup when click

<html> 

<head> 
<meta http-equiv="Content-Language" content="tr"> 
<meta name="GENERATOR" content="Microsoft FrontPage 5.0"> 
<meta name="ProgId" content="FrontPage.Editor.Document"> 
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254"> 
<title>PORTAL</title> 
</head> 

<body bgcolor="#C0C0C0"> 

<p align="center"><u><font face="Arial Black" size="4>PORTAL</font></u></p> 
<hr> 
<ul> 
  <li> 
  <p align="left"> 

<? 

@mysql_connect("localhost", "root", "") 
    or die("Veritabani ile baglanti kurulamadi!"); 
@mysql_select_db("portal") 
    or die("Veritabaninda bir hata olustu!"); 


$sql = "SELECT post_subject FROM asd_uo_text WHERE post_id = '1'"; 
$res = mysql_query($sql) OR die(mysql_error()); 
$row = mysql_fetch_row($res); 

echo"<a href=javascript:window.open('mywindow.php','new','scrollbars=0,resize=no'); >($row[0])</a>";

?> 
<form action="duzenle.php" method="get"> 
<input type="submit" value=" Show "></form> 

</li> 
  <li> 
  <p align="left"> 
<? 


$sql2 = "SELECT post_subject FROM asd_uo_text WHERE post_id = '2'"; 
$res2 = mysql_query($sql2) OR die(mysql_error()); 
$row2 = mysql_fetch_row($res2); 

echo"<a href=javascript:window.open('mywindow.php','new','scrollbars=0,resize=no'); >($row2[0])</a>";
?> 

<form action="duzenle2.php" method="get"> 
<input type="submit" value=" Show "></form> 

</li> 
  <li> 
  <p align="left"> 
<? 

$sql3 = "SELECT post_subject FROM asd_uo_text WHERE post_id = '3'"; 
$res3 = mysql_query($sql3) OR die(mysql_error()); 
$row3 = mysql_fetch_row($res3); 

echo"<a href=javascript:window.open('mywindow.php','new','scrollbars=0,resize=no'); >($row3[0])</a>";

?> 

<form action="duzenle3.php" method="get"> 
<input type="submit" value=" Show "></form> 

</li> 
  <li> 
  <p align="left"> 

<? 

$sql4 = "SELECT post_subject FROM asd_uo_text WHERE post_id = '4'"; 

$res4 = mysql_query($sql4) OR die(mysql_error()); 
$row4 = mysql_fetch_row($res4); 

echo"<a href=javascript:window.open('mywindow.php','new','scrollbars=0,resize=no'); >($row4[0])</a>";

?> 


<form action="duzenle4.php" method="get"> 
<input type="submit" value=" Show"></form> 

</li> 
  <li> 
  <p align="left"> 

<? 

$sql5 = "SELECT post_subject FROM asd_uo_text WHERE post_id = '5'"; 
$res5 = mysql_query($sql5) OR die(mysql_error()); 
$row5 = mysql_fetch_row($res5); 

echo"<a href=javascript:window.open('mywindow.php','new','scrollbars=0,resize=no'); >($row5[0])</a>";

?> 


<form action="duzenle5.php" method="get"> 
<input type="submit" value=" Show "></form> 

</li> 
</ul> 
<p align="left">&nbsp;</p> 
<p align="left">&nbsp;</p> 

</body> 

</html>

And I want content which is under mysql shown in that pop up like this

mysql_connect("localhost","root",""); 
mysql_select_db("portal"); 

$query="select post_subject,post_text from asd_uo_text where post_id = '1'"; 
$sonuc=mysql_query($query); 

$obje=mysql_fetch_object($sonuc); 
$subject=$obje->post_subject; 
$content=$obje->post_text;

and i want showing this content inside of that pop up

piersk

Ok, for starters, the link should look like this:

<?php
echo"<a href=\"javascript:window.open('mywindow.php','new','scrollbars=0,resize=no');\" >($row[0])</a>";
?>

Although I still reckon that you should do this instead (cross-browser and all that):

<?php
echo"<a href=\"mywindow.php\" onClick=\"window.open(this.href,'new','scrollbars=0,resize=no');\" >($row[0])</a>";
?>

Dakkar

But how can i show $content variable which has post_text from mysql into popup that my webpage opens

piersk

Huh? Not really sure what you're trying to say...

Dakkar

I just want to say i have a php code like this

mysql_connect("localhost","root","");  

mysql_select_db("portal");  

$query="select post_subject,post_text from asd_uo_text where post_id = '1'";  

$sonuc=mysql_query($query);  

$obje=mysql_fetch_object($sonuc);  

$subject=$obje->post_subject;  

$content=$obje->post_text;

and i want this $content variable to be shown inside of pop up which we open before
is it possible?

nemonoman

THere shouldn't be a problem??

window.open('mywindow.php'...

put the code you want executed in the php of 'mywindow.php'

Am I missing something?