CodeLobster IDE

onclick use
Page 1 of 1

Author:  12Strings [ Sun Sep 11, 2022 2:09 pm ]
Post subject:  onclick use

Hi, the code below displays the records in a database table. I select a record from a dropdown and
update a couple of fields in that record. So far so good.... Then I want to, using the "target"
field (which is a url) as an argument, onclick or whatever and go to that url. Surely there's a way?

<!DOCTYPE><html><head><title>email menu</title></head>
<form name="form" method="post" action="">
//============== check connection
{echo "Can't Connect to mySQL:".mysqli_connect_error();}
{echo "Connected to mySQL</br>";}
//This creates the drop down box
echo "<select name= 'target'>";
echo '<option value="">'.'--- Select email account ---'.'</option>';
$query = mysqli_query($con,"SELECT target FROM lookuptbl");
$query_display = mysqli_query($con,"SELECT * FROM lookuptbl");
{echo "<option value='". $row['target']."'>".$row['target']
echo '</select>';

<input type="submit" name="submit" value="Submit"/>
{echo "Can't Connect to mySQL:".mysqli_connect_error();}
$name = $_POST['target'];
$fetch="SELECT id, target, username, password, purpose, emailused,lastused,
count FROM lookuptbl WHERE target = '".$name."'";
$result = mysqli_query($con,$fetch);
{echo "Error:".(mysqli_error($con));}

//display the table
echo '<table border="1">'.'<tr>'.'<td bgcolor="#ccffff align="center">'. 'lookup menu'. '</td>'.'</tr>';
echo '<tr>'.'<td>'.'<table border="1">'.'<tr>'.'
<td bgcolor="#CFB53B align="center">'.'id'.'</td>'.'
<td bgcolor="#CFB53B align="center">'.'target'.'</td>'.'
<td bgcolor="#ccffff align="center">'.'username'.'</td>'.'
<td bgcolor="#ccffff align="center">'.'password'.'</td>'.'
<td bgcolor="#ccffff align="center">'.'purpose'. '</td>'.'
<td bgcolor="#ccffff align="center">'.'emailused'.'</td>'.'
<td bgcolor="#CFB53B align="center">'.'lastused'.'</td>'.'
<td bgcolor="#CFB53B align="center">'.'count'. '</td>'.'</tr>';
{echo ("<tr><td>$data[0]</td><td>$data[1]</td><td>$data[2]</td><td>$data[3]</td>
echo '</table>'.'</td>'.'</tr>'.'</table>';
$sql = "UPDATE lookuptbl SET lastused=NOW(), count=$count + 1 WHERE target=$target";
if ($con->query($sql) === TRUE) { echo "Record updated successfully"; }
else { echo "Error updating record: " . $con->error; }
// $con->close();

<button onclick="myFunction('<?php echo $row["url"];?>')">go to url</button>
<script language="javascript">
var sid;
function myFunction(sid) {;

Author:  12Strings [ Mon Sep 19, 2022 11:20 pm ]
Post subject:  Re: onclick use

Am I to understand that no one here understands the PHP manuals enough to relate to your benefactors?

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group