Can anyone help me fix my code, I think the problem is on onclick

Get Started
1 
function edit_user($username){
if ( $username == 'admin' ) {
$query = "SELECT * FROM login WHERE username != 'admin'";
$queryResult = mysql_query($query) or die (mysql_error());
echo "<table border='1'>

<tr>
<th>Loginid</th>
<th>username</th>
<th>email</th>
<th>activated</th>
<th>Edit User</th>
<th>Delete user</th>
</tr>";
while($rows = mysql_fetch_array($queryResult)) {
//Todo: Here is a problem
//probably use mysql_num_array function...gonna fix that this.
//
// $_SESSION['username'] = $rows['username'];
echo "<tr>";
echo "<td bgcolor='#FF9933'>". $rows['loginid'] . "</td>";
echo "<td bgcolor='#FF9933'>" . $rows['username'] . "</td>";
echo "<td bgcolor='#FF9933'>" . $rows['email'] . "</td>";
echo "<td bgcolor='#FF9933'>" . $rows['activated'] . "</td>";
echo "<td bgcolor='#FFFFFF'><center>" . '<input type="button" name="Activate" value="Activate" class="form"
onClick="activate_user_id('.$rows['username'].','.$rows['loginid'].','.$rows['activated'].')">' . "</center></td>";
echo "<td bgcolor='#FFFFFF'><center>" . '<input type="submit" name="Delete" value="Delete" class="form"
onClick="delete_user('.$rows['username'].','.$rows['loginid'].','.$rows['activated'].')">' . "</center></td>";
echo "</tr>";
}
echo "</table>";
}else {
echo "$username";
echo "<p>You dont have permission to access the Admin site</p>";
}
}

function activate_user_id ($username, $loginid, $activated) {
global $seed;
if (!valid_username($username) || !user_exists($username))
{
return false;
}

$query = sprintf("select activated from login where username = '%s' and loginid = '%s' and activated = '%s' limit 1",
mysql_real_escape_string($username), mysql_real_escape_string($loginid));
$result = mysql_query($query);

if (mysql_num_rows($result) == 1)
{

$sql = sprintf("update login set username = 'eric15' where username ='%s' and loginid = '%s' and activated = '%s'",
mysql_real_escape_string($username), mysql_real_escape_string($loginid));
return true;
}
}

function delete_user ($username, $loginid, $activated) {
$query = sprintf("select activated from login where username = '%s' and loginid = '%s' and activated = '%s' limit 1",
mysql_real_escape_string($username), mysql_real_escape_string($loginid));
$result = mysql_query($query);

if (mysql_num_rows($result) == 1)
{

$sql = sprintf("delete from login where username = '%s' and loginid = '%s' and activated = '%s'",
mysql_real_escape_string($username), mysql_real_escape_string($loginid));
}
}
2

The OnClick attribute is for putting javascript functions into. Your delete_user() and activate_user_id functions are PHP functions. If you want to be able to delete a user without reloading the page you would need to use some AJAX or jQuery.

3

Can you show me an example to fix that code? I am just start learning php

4

I am looking for a button that inside a php table.
I tried

echo "<td bgcolor='#FFFFFF'><center>"
 . '<input type="button" name="Activate" value="Activate" class="form" onClick="activate_user_id('.$rows['username']
.','
.$rows['loginid']
.','
.$rows['activated']
.')">'
 . "</center></td>";

I know people said i have to use AJAX to make it work. but i dont know AJAX at all, Can anyone show me how to use AJAX that to make this button works with calling a function in the same page and refresh the page after updated the sql

5

I made it php function. How to make it as AJAX?

6

I’m confused. Is
activate_user_id
a javascript or PHP function?

7

I guess the main thing to remember is PHP happens on the server and javascript happens in the browser.

So it could be something like:

PHP puts together the page and sends it out
a click event triggers a javascript function
the javascript function goes to a PHP file
the PHP file returns info to the javascript
the javascript uses that to alter the page