Pic change on click

Hi have confussed myself,

can you see why i cant get a new pic to be displayed in the box on click please ?

<HTML><HEAD><TITLE></TITLE><META content="text/html; charset=utf-8" http-equiv=Content-Type><META name=GENERATOR content="MSHTML 10.00.8400.0"><STYLE type=text/css>BODY {
    FONT-FAMILY: verdana, arial, sans-serif
}</STYLE>
</HEAD><BODY>
<FORM style="BORDER-TOP-COLOR: ; BORDER-BOTTOM-COLOR: ; BORDER-RIGHT-COLOR: ; BORDER-LEFT-COLOR: " method=post action=refresh>
<TABLE cellSpacing=2 cellPadding=1 width="100%" border=1>
<TBODY>
<TR>
<TD><INPUT style="HEIGHT: 22px; WIDTH: 43px" size=1 value=0000 name="clickcount"></TD></TR>
<TR><php$con = mysql_connect("localhost", "bubber", "xyz");
 if (!$con){ die('Could not connect: ' . mysql_error()); }mysql_select_db("base1", $con);

   //----------------------------------------------//----------------------------------------------
    $result = mysql_query("SELECT * FROM `xpic` ORDER BY RAND() LIMIT 0,1;");echo "<TABLE border=9><TBODY><TR>
<P></P><TH>xxxx</TH></TR>";
<TD>
while($row = mysql_fetch_array($result))

  {
  echo "<TR>";

    echo '<TD><IMG border=0 name=abc hspace=0 alt=abc123 src="',$row['pic'],'" width=300 height=343></A></TD>';

 echo "</TR>";
  }
echo "</TBODY></TABLE>";


mysql_close($con);
?>;
</TD></TR>
<TR>
<TD><INPUT type=submit value="change pic" name=click onclick= picchange()></TD></TR></TBODY></TABLE></FORM>

   <SCRIPT language=javascript type=text/javascript>
function pcchange() 
{
A = document.frmOne.clickcount.value;
A = Number(A);
C = A+1;
document.frmOne.clickcount.value =  C;

return colourchange();
  <SCRIPT language=javascript type=text/javascript>
function colourchange()
 {
    var red=Math.floor(Math.random()*256)
     var green=Math.floor(Math.random()*256)
        var blue=Math.floor(Math.random()*256)

    document.frmOne.clckcount.style.backgroundColor = "rgb("+red+","+green+","+blue+")";

    return newpic();
    <SCRIPT language=javascript type=text/javascript>
function newpic()
 {      
   document.frmOne.cabc.value = <php$con = mysql_connect("localhost", "bubber", "xyz"); if (!$con){ die('Could not connect: ' . mysql_error()); }mysql_select_db("base1", $con);

   //----------------------------------------------//----------------------------------------------
    $result = mysql_query("SELECT * FROM `xpic` ORDER BY RAND() LIMIT 0,1;");echo "<TABLE border=9><TBODY><TR>
<P></P><TH>xxxx</TH></TR>";

while($row = mysql_fetch_array($result))

  {
  echo "<TR>";

    echo '<TD><IMG border=0 name=abc hspace=0 alt=abc123 src="',$row['pic'],'" width=300 height=343></A></TD>';

 echo "</TR>";
  }
echo "</TBODY></TABLE>";


mysql_close($con); 
?>


              }

      </SCRIPT>
         }

      </SCRIPT>
}</SCRIPT>



</BODY></HTML>

3

Contributors

5

Replies

10 Hours

Discussion Span

11 Months Ago

Last Updated

6

Views

Kniggles

Junior Poster in Training

96 posts since Oct 2010

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

11 Months Ago

0

You are mixing in PHP in a Javascript function. That is not possible.

pritaeas

Posting Prodigy

Moderator

9,310 posts since Jul 2006

Reputation Points: 1,178

Solved Threads: 1,465

Skill Endorsements: 86

11 Months Ago

0

Hi priteas, how do i turn the mysql querry $result into a varilable to be able to be used and chaged in the java on-click fuction ?

Kniggles

Junior Poster in Training

96 posts since Oct 2010

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

11 Months Ago

0

You can use Ajax.
Once page is loaded at user side and then you want any php operation without page load you can use ajax.
Below is sample code. You need to include jQuery file to run it.

By default show only one pic. When user click on button call this ajax function.
in ajax.php file you need to write php code to fetch any random image src and just echo it.

$.ajax({
  url: 'ajax.php',
  success: function(data) {
   alert('random image src:'+data);
    // data will be src of image
    // using javascript you can change image's src from data
  }
});

vibhaJ

Posting Shark

958 posts since Apr 2010

Reputation Points: 161

Solved Threads: 190

Skill Endorsements: 3

11 Months Ago

0

Have tried to strip it down even more to the basics , to try and understand,
so now have 2 pages 1.php & 2.php

1 =

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="2.php" method="post" name="form1" target="_self">
  <p><img alt="pic1" name="pic1" width="320" height="320" id="pic1" />
    <label for="click">total clicks</label>
    <input name="click" type="text" id="click" value="00000" />
  </p>
  <p>button1
    <input type="submit" name="button1" id="button1" value="Submit" onClick = calculate() />
  </p>
</form>
<script language="javascript" type="text/javascript">
function calculate() 
{
A = document.formOne.pic1.value;
A = Number(A);
C = A+1;
document.frmOne.w.value =  C;
document.frmOne.z.value = C+1;
return 2.php()
}
</script></body>
</html>

and 2.php

<?php

 $con = mysql_connect("host", "myuser", "psxx");
 if (!$con)
{
 die('Could not connect: ' . mysql_error());
  }
mysql_select_db("mytable", $con);
//----------------------------------------------

//----------------------------------------------


$result = mysql_query("SELECT * FROM `xpic` ORDER BY RAND() LIMIT 0,1;");

while($row = mysql_fetch_array($result))

  {


   pic1='<td><img width="300" src="',$row['pic'],'"/></a></td>';


  }



mysql_close($con);
?>

and I cant get it to load a pic when I first land on the page now :(

Kniggles

Junior Poster in Training

96 posts since Oct 2010

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

11 Months Ago

0

am now down to

1.php =

</head>

<body>
<div id="frm"><img  src="<?php echo "$pic"; ?>"></></div>

<button id="Next pic" onclick="show_next(); return false;">

function show_next()
{
  $('#frm').load('2.php');
}


</body>
</html>

and
2.php

<?php

 $con = mysql_connect("localhost", "memyselfi", "psxx");
 if (!$con)
{
 die('Could not connect: ' . mysql_error());
  }
mysql_select_db("table1base", $con);

$sql = ("SELECT pic FROM xpic ORDER BY RAND() LIMIT 1");

       while($row = mysql_fetch_array($sql)){

             $pic = $row["pic"];

    }


mysql_close($con);
?>

1 random pic 1 button , on click = new random pic,

Kniggles

Junior Poster in Training

96 posts since Oct 2010

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

Pic change on click

and 2.php

This article has been dead for over three months: Start a new discussion instead