|
Answer» I want to select a row from mysqli dropdown,
click on button & link to "target"(format - www.somesite.com).
change 2 fields in the sql (via lastused.php) code follows:
My dropdown works, can't figure out the button code.
My dropdown code follows:
Any help?
Code: [Select]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<SCRIPT language=JavaScript>
<!-- CLOCK --
var timerID = null
var timerRunning = false
function stopclock()
{ if(timerRunning) clearTimeout(timerID) timerRunning = false }
function startclock()
{ stopclock() showtime() }
function showtime()
{
var now = new DATE()
var hours = now.getHours()
var MINUTES = now.getMinutes()
var seconds = now.getSeconds()
var timeValue = "" + ((hours > 12) ? hours - 12 : hours)
timeValue += ((minutes < 10) ? ":0" : ":") + minutes
timeValue += ((seconds < 10) ? ":0" : ":") + seconds
timeValue += (hours >= 12) ? " P.M." : " A.M."
document.clock.face.value = timeValue
timerID = setTimeout("showtime()",1000)
timerRunning = true
}
//-->
</SCRIPT>
</head>
<BODY onload="startclock()"><center>
<FORM NAME=clock method="post" action="" onsubmit=0>
<INPUT size=11 value=....Initializing.... name=face>
<FORM name=lastused method="post" action="">
<?php
echo"<center>";echodate('m/d/y');echo"</center>";
$id="''";
$con=mysqli_connect("localhost","root","cookie","homedb");
//==============checkconnection
if(mysqli_errno($con))
{echo"Can'tConnecttomySQL:".mysqli_connect_error();}
else
{echo"</br>";}
//==========Thiscreatesthedropdownboxusingrecordsinthetable
echo"<selectname='target'>";
echo'<optionvalue="">'.'---selectemailaccount---'.'</option>';
$query=mysqli_query($con,"SELECTtargetFROMemailtbl");
$query_display=mysqli_query($con,"SELECT*FROMemailtbl");
while($row=mysqli_fetch_array($query))
{echo"<optionclass=highlightvalue='".$row['target']."'>".$row['target']
.'</option>';}
echo'</select>';
?>
<input type="submit" name="submit" value="Submit"/>
</form>
<?php
nclude('lastused.php');//*********codefollows******************
error_reporting(E_ALL^E_NOTICE);
//error_reporting(0);
$con=mysqli_connect("localhost","root","cookie","homedb");
if(mysqli_errno($con))
{echo"Can'tConnecttomySQL:".mysqli_connect_error();}
if(isset($_POST['target']))
{
$id=$_POST['id'];
$lastused=$_POST['lastused'];
$name=$_POST['target'];
$fetch="SELECTtarget,username,password,emailused,lastused,purpose,savedFROMemailtblWHEREtarget='".$name."'";
$result=mysqli_query($con,$fetch);
if(!$result)
{echo"Error:".(mysqli_error($con));}
//===============================thisdisplaysthetable
echo'<tableborder="1">'.'<tr>'.'<tdbgcolor="#FFD47F"align="center">'.'emailmenu'.'</td>'.'</tr>';
echo'<tr>'.'<td>'.'<tableborder="1">'.'<tr>'.'<tdbgcolor="#ccffff">'.'target'.'</td>'.'<tdbgcolor="#ccffff">'.'username'.'</td>'.'<tdbgcolor="#ccffff">'.'password'.'</td>'.'<tdbgcolor="#ccffff">'.'emailused'.'</td>'.'<tdbgcolor="#FFD47F">'.'lastused'.'</td>'.'<tdbgcolor="#ccffff">'.'purpose'.'</td>'.'<tdbgcolor="#ccffff">'.'saved'.'</td>'.'</tr>';
while($data=mysqli_fetch_row($result))
{echo("<tr><td>$data[0]</td><td>$data[1]</td><td>$data[2]</td><td>$data[3]</td><td>$data[4]</td><td>$data[5]</td><td>$data[6]</td></tr>");}
echo'</table>'.'</td>'.'</tr>'.'</table>';
}
?>
</body></html>=======================================================
Code: [Select]<?php
//lastused.php
$dbconnect=mysqli_connect('localhost','root','cookie')ordie(mysqli_error($dbconnect));
$result=mysqli_query($dbconnect,"SELECT*FROMemailtbl");
if(!empty($_POST['lastused']))
{
$update=mysqli_query($dbconnect,"UPDATEemailtblSETvisits=visits+1,
lastused='NOW()'WHERElastused='$lastused'");
if($update==false)
{die("UPDATEFAILED:".mysqli_error($dbconnect));}
}
?>
|
