PHP - Onclick Button To Display Database Table

i have this code which fetch meta tags and title

function file_get_contents_curl($url)
{
    $ch = curl_init();

    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);

    $data = curl_exec($ch);
    curl_close($ch);

    return $data;
}

$html = file_get_contents_curl("http://example.com/");

//parsing begins he 
$doc = new DOMDocument();
@$doc->loadHTML($html);
$nodes = $doc->getElementsByTagName('title');

//get and display what you need:
$title = $nodes->item(0)->nodeValue;

$metas = $doc->getElementsByTagName('meta');

for ($i = 0; $i < $metas->length; $i++)
{
    $meta = $metas->item($i);
    if($meta->getAttribute('name') == 'description')
        $description = $meta->getAttribute('content');
    if($meta->getAttribute('name') == 'keywords')
        $keywords = $meta->getAttribute('content');
}

if(!title == ' ')
{
echo ' found a title';
}

in this code you see in last i have if condition (!title==' ') its execute it when i open file i want its only run when i click the html button like <input type="button" name="Release" onclick="" value="Click "> please tell me what i do help me

Amazingly, PHP Coding Help != JavaScript Help.

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=333336.0

Friends
  I am new to php and i have to submit my coursework in php by 3rd dec, I stuck at one place where i have to upload multiple photo and one can see all the photo he has uploaded and can edit or delete that photo so i have done uploading now i am showing those pics in table by running loop and generating tr and td but now i have two buttons with each row edit and delete now when i clicked on one delete or edit that pic should be delete or give text box to edit description of pic, Please help me how to do that.......

I have a dynamic script and need to create a click event function with JavaScript to delete the row which has a checkbox checked when the delete button is pressed. 
 
 
This is being implemented with PHP and as now serves as light code for this matter at hand. I was only able to delete all rows. I have my efforts with the js functions too.     <script type="text/javascript">
   var counter = 1;
   var limit = 6;
   function addTextArea() {
    if (counter == limit-1) {
    alert("Maximum limit " + counter + " sorry");
    return false;
    }
    else {
    <!-- CAUTION THIS IS BACKWARDS. -->
   
    var newdiv = document.createElement('div');
    newdiv.innerHTML = "" + (counter + 1) + " <br><textarea name='fav_det[]' id=counter rows='3' cols='20'>";
    document.getElementById('div6').appendChild(newdiv);
   
    var newdiv = document.createElement('div');
    newdiv.innerHTML = "" + (counter + 1) + " <br><textarea name='fav_col' id=counter rows='3' cols='20'>";
    document.getElementById('div5').appendChild(newdiv);
   
    var newdiv = document.createElement('div');
    newdiv.innerHTML = "" + (counter + 1) + " <br><textarea name='fav_mod[]' id=counter rows='3' cols='20'>";
    document.getElementById('div4').appendChild(newdiv);
   
    var newdiv = document.createElement('div');
    newdiv.innerHTML = " " + (counter + 1) + " <br><input type='text' name='truck[]' id=counter>";
    document.getElementById('div3').appendChild(newdiv);
   
    var newdiv = document.createElement('div');
    newdiv.innerHTML = " " + (counter + 1) + " <br><input type='text' name='car[]' id=counter>";
    document.getElementById('div2').appendChild(newdiv);
   
    var newdiv = document.createElement('div');
    newdiv.innerHTML = "" + (counter + 1) + " <br><input type='checkbox' name='chk[]' id=counter>";
    document.getElementById('div1').appendChild(newdiv);
   
    counter++
    return true;
    }
   }
   </script>
   
   
   <script type="text/javascript">
   function  deleteRowS(dataTable) {
    for (var rowi= table.rows.length; rowi-->0;) {
     var row= table.rows[rowi];
     var inputs= row.getElementsByTagName('dataTable');
     for (var inputi= inputs.length; inputi-->0;) {
      var input= inputs[inputi];
   
      if (input.type==='checkbox' && input.checked) {
       row.parentNode.removeChild(row);
       break;
      }
     }
    }
   }
   </script> 
   
   
   
   <script type="text/javascript">
   function deleteRow()  {
     var table = document.getElementById(tableID).tBodies[0];
     var rowCount = table.rows.length;
   
     // var i=1 to start after header
     for(var i=1; i<rowCount; i++) {
      var row = table.rows[i];
      // index of td contain checkbox is 8
      var chkbox = row.cells[6].getElementsByTagName('input')[0];
      if('checkbox' == chkbox.type && true == chkbox.checked) {
       table.deleteRow(i);
       }
     }
   }</script>
   
   </head>
   <table>
   <tr><td valign='top'><b>NEED DELETE ROW WITH CHECKBOX FUNCTION:</td></tr>
   </table>
   <table id="dataTable" width="auto" style="margin:-4px 0 0 0; padding:14px 0 0 0;" cellspacing="10px"><tbody id="dataTable"></tbody>
   <tr>
   <td valign='Top'>
   &#x2717;
   <div id="div1">
   <input type="checkbox" name="chk[]" autocomplete="off" id="1" >
   </div>
   </td>
   
   <td valign='Top'>
   cars
   <div id="div2">
   <input type="text" name="car[]" id="2" >
   </div>
   </td>
   
   <td valign='Top'>
   trucks
   <div id="div3">
   <input type="text" name="truck[]" id="3" >
   </div>
   </td>
   
   <td valign='Top'>
   your favorite model
   <div id="div4">
   <textarea name="mod[]" id="4" rows="3" cols="20"></textarea>
   </div>
   <br><br>
   </td>
   
   <td valign='Top'>
   your favorite add-ons
   <div id="div5">
   <textarea name="fav_col" id="5" rows="3" cols="20"></textarea>
   </div>
   </td>
   
   <td valign='Top'>
   explain vehicle overall
   <div id="div6">
   <textarea name="fav_det" id="6" rows="3" cols="20"></textarea>
   </div>
   </td>
   </tr>
   </table>
   <input type="button" value="Add another" onClick="addTextArea();" />&nbsp;
   <input type="button" value="Delete row" onclick="deleteRow('dataTable');deleteRowS('dataTable')" />

I dont want unset onclick="this.disabled=true" if page refresh,

code :

 

<button type="button" class="addb btn btn-primary rounded-pill py-2 btn-block" type="submit" data-voice_sku="'.$row["voice_sku"].'" data-voice_name="'.$row["voice_name"].'" onclick="this.disabled=true">Add to Playlist</button>

 

If page refresh onclick event unset. how to prevent?

I think I'm using the wrong method, but GET and POST don't seem to fit in at all. I'm making a random game where they can only play 20 times a day. Once they hit that roll again button, I want a string to go into the database. And then after that, I will pull all those.. whatever I know how to do that part, but I just want to know why the button isn't making it insert all those values into the fields.

<?php

$dice = rand(1,6);
echo "You rolled a<br /><b>{$dice}</b>\n";

$winnings = "500";
if($dice == 6)
{
    include("haha.php");
    $cxn = mysqli_connect($dbhost,$dbuser,$dbpassword,$dbdatabase);
    $username = $cxn->real_escape_string($_SESSION['username']);
    $sql = "UPDATE `Member` SET `rp` = rp+$winnings WHERE `username` = '$username'";
    mysqli_query($cxn,$sql);
}?>
<FORM ACTION="random.php" METHOD="post">
<INPUT TYPE="submit" VALUE="Roll Again! NAME="sixdice">
</FORM>
<?php
    if (@$_POST['sixdice']) {
include("haha.php");
$cxn = mysqli_connect($dbhost,$dbuser,$dbpassword,$dbdatabase);
      $userid = "$_SESSION['userid']";
      $username = "$_SESSION['username']";
      $sql = "INSERT INTO Sixdice (userid,username,rolltime) VALUES ('$userid','$username',NOW())";
      $result = mysqli_query($cxn,$sql) or die("Query died: insert");
      }
?>

I'm currently trying...struggling....to teach myself PHP and I'm really bugged with this database stuff. I am slowly managing but I'm a tad bit stuck now.

I want to show a specific piece of information from a table.

Lets say my table is structured like so:

id user email 1
Bob
Bob@Name.com
2 Fred Fred@Name.com 3 Matt Matt@Name.com
What would I need to do to display ONLY Freds user?

One way I tried only displayed the first rows info (Bob) the second way I tried (with a while loop) only displayed the last rows info (Matt)

Heres my current code:
<html>
<body>
<?php
include 'dbwire.php'; 

$query = mysql_query('SELECT * FROM user');

$row = mysql_fetch_array($query); 

while ($row = mysql_fetch_array($query)) { 
echo '<b>User:</b> ' . $row['user'] . '<br />';
}
?>
</body>
</html>

<?php
require_once('upper.php');

require_once('database.php');
if(isset($_COOKIE['LoginIdCookie']))
{
echo '<h4>Welcome '.$_COOKIE['LoginIdCookie'].'</h4>';
}
else{ echo '<h4>Events</h4>';}
$result=mysqli_query($dbc,"select * from events") or die('Not Connected');
echo "<html>
<body>";
  echo "<form method='post' action='EventParticipator.php'>"; 
  echo "<u><h4>Please tick events in which you want to participate</h4></u>";
  /*echo "<table cellspacing='0' cellpadding='15'>
   <th><b>Event Title:</b></th>
   <th ><b>Event City:</b></th>
<th><b>Content:</b></th>
<th><b>Images:</b></th>
<th><b>Event Date:</b></th>";*/

//while($row=mysqli_fetch_array($result))
$row=mysqli_fetch_array($result);
for($i=0;$i<5;$i++)
{
$Title=$row['Title'];
$City=$row['City'];
$Content=$row['Content'];
//$Photo=$row['Photo'];
$Date=$row['Date'];
$EventId=$row['EventId'];
$Photo=$row['Photo'];
//echo $Photo;

echo "<tr><td><img src='$Photo' width='120' height='90'/></td><td>$City</td><td>,</td><td>$Date</td><td>:</td><td>$Title</td></tr>
<tr><td>$Content</td></tr>
<tr><td><a href='#'>Know more</a></td><td>/</td><td><a href='#'>Click here to participate</a></td></tr>"; 
}
//echo "<tr><td><input type='submit' name='submit' value='Participate'</td>";
if(isset($_COOKIE['LoginIdCookie']))
{
echo "<td><a href='log_out.php'>Log out</a></td>";
echo "<td><a href='EditActivity.php'>Edit Your Activities</a></td></tr>";
}
echo "</table></form></body></html>";
require_once('lower.php');
?>






Quote

Hi friends ..........
I write above code to display top 5 rows from the database but it not works properly. It displays first row 5 times which is undesireable.
Anyone please help?????????????????
thanks in advance..................

Hello,
I recently came upon this website and I want to implement something similar. The 'remove' box is what I would like to do with PHP. I have no idea where to start. I would like to be able to search through my database, select one of its components and add it to that window. Within that window I would also like to be able to remove it. Does anyone know where I should go from there?


here is the site:
http://www.sealandserpent.org/schedgen/schedulegenerator.php

I'm writing a highscore board for a game and I can only display one value from a DB... 
I don't know what I could be doing wrong. I've done this kind of DB work before.

<?php
$name = $_GET['lvl'];
    if($_GET['lvl']=="Strength"){ //1/21
        $skill = "strlvl";
        $exp = "strexp";
}     else if($_GET['lvl']=="Attack"){ //2/21
        $skill = "atklvl";
        $exp = "atkexp";
}     else if($_GET['lvl']=="Defence"){ //3/21
        $skill = "deflvl";
        $exp = "defexp";
}     else if($_GET['lvl']=="Hitpoints"){ //4/21
        $skill = "hplvl";
        $exp = "hpexp";
}     else if($_GET['lvl']=="Range"){ //5/21
        $skill = "rglvl";
        $exp = "rgexp";        
}     else if($_GET['lvl']=="Magic"){ //6/21
        $skill = "mglvl";
        $exp = "mgexp";
}     else if($_GET['lvl']=="Hitpoints"){ //7/21
        $skill = "hplvl";
        $exp = "hpexp";
}     else if($_GET['lvl']=="Prayer"){ //8/21
        $skill = "prlvl";
        $exp = "prexp";
}     else if($_GET['lvl']=="Runecraft"){ //9/21
        $skill = "rclvl";
        $exp = "rcexp";
}     else if($_GET['lvl']=="Slayer"){ //10/21
        $skill = "sllvl";
        $exp = "slexp";
}     else if($_GET['lvl']=="Thieve"){ //11/21
        $skill = "thlvl";
        $exp = "thexp";                        
}     else if($_GET['lvl']=="Agility"){ //12/21
        $skill = "hplvl";
        $exp = "hpexp";
}     else if($_GET['lvl']=="Firemaking"){ //13/21
        $skill = "fmlvl";
        $exp = "fmexp";
}     else if($_GET['lvl']=="Woodcut"){ //14/21
        $skill = "wclvl";
        $exp = "wcexp";
}     else if($_GET['lvl']=="Cooking"){ //15/21
        $skill = "cklvl";
        $exp = "ckexp";
}     else if($_GET['lvl']=="Herblore"){ //16/21
        $skill = "hblvl";
        $exp = "hbexp";
}     else if($_GET['lvl']=="Mining"){ //17/21
        $skill = "mnlvl";
        $exp = "mnexp";
}     else if($_GET['lvl']=="Farming"){ //18/21
        $skill = "frmlvl";
        $exp = "frmexp";
}     else if($_GET['lvl']=="Fishing"){ //19/21
        $skill = "fshlvl";
        $exp = "fshexp";
}     else if($_GET['lvl']=="Smithing"){ //20/21
        $skill = "smlvl";
        $exp = "smexp";
}     else if($_GET['lvl']=="Fletching"){ //21/21
        $skill = "fltlvl";
        $exp = "fltexp";
}     else if($_GET['lvl']==""){ //0/21
echo "<center><br /><br />No skill selected!</center><br />";
}
mysql_connect("mysql", "15557_test", "**************") or
    die("Could not connect: " . mysql_error());
mysql_select_db("15557_test");
//STARTS HERE
$result = mysql_query("SELECT playerName, $skill, $exp FROM skills ORDER BY $exp ASC LIMIT 5000");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo"Skill: " . $name . "<br />";
printf("Player: %s - Rank: %s - EXP: %s<br />", $row[0],$row[1],$row[2]);

mysql_free_result($result

//ENDS HERE
}
?>

I'm trying to simply display the contents of an entire database for the purpose of building an administrative super-user into the back-end to remove login credentials without having to resort to having to manually interact with Mariadb or PHPmyadmin. However, the code is only returning the last row that was entered into the database. I can't seem to figure out why it's not working as intended. The code is intended to simply display the entire contents of the database into an html table.

The code i'm using:

<?php 
$link = mysqli_connect("127.0.0.1", "database user", "password", "login");

if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
            }

if ($result = mysqli_query($link, "SELECT * FROM accounts", MYSQLI_STORE_RESULT)) {

	while ($row = $result->fetch_assoc()) {
	$id = $row["id"];
	$username = $row["username"];
	$pass = $row["password"];
	$email = $row["email"];
	$su = $row["su"];
        }

   }
mysqli_close($link);
?>
<!DOCTYPE html>
<html>
	<head>

	</head>

	<body>
		<table>
		<tr> <th>id</th><th><th>user name</th><th>password</th><th>email</th><th>elevated privlege</th></tr>
                <tr>
		<td>   <?php echo $id; ?>    </td>
	        <td>   <?php echo $username; ?>      </td>
		<td>   <?php echo $pass; ?> </td>
                <td>   <?php echo $email; ?> </td>
                <td>   <?php echo $su; ?> </td>
                </tr>
                </table>
	</body>
</html>

 

Edited August 31, 2020 by bakertaylor28
correction of the code used.

Hello
i have a SQL db that has some Empty Rows in it ....
I Had used a if else statement to make it display N/A If the answer is different than it should be like this

<?php if ($string) {echo $string} else {echo"N/A"};?>
but i think there are better ways of doing this
Can anyone teach me how may i do it?
Edit:
it should be a way to see if the db row value is empty/null :|

I need to create several buttons that when clicked it updates a field in a table and then passes params to another page (action). I cant seem to figure a logical way of doing this without making things messy, any one have any ideas

I have page with male female radio button

Here's the code

Code: [Select]
$qry=mysql_query("SELECT * FROM reg_table where id=$id ");

$res=mysql_fetch_array($qry);

$radio = $res['gender'];

switch($radio)
{
   case "male":
   $mal = "checked";
   break;
   case "female":
   $fem = "checked";
   break;
}
Code: [Select]
Gender: <br />
<input type="radio" name="colour" value="male" checked="<?php $mal; ?>" />Male
<input type="radio" name="colour" value="female" checked="<?php $fem; ?>" />Female


Whats the use of checked in
<input type="radio" name="colour" value="male" checked="<?php $mal; ?>" />

When I display the data in my database I have included a radio button in each row. When the button is clicked, the intention is to delete all the information in that row. But it won't delete anything...

Here's the form:
Code: [Select]
<FORM Method = "POST" action ="update_tee_times.php">
 
<?php

include("opendatabase.php"); 

$dateID = $_POST[teetimedate];

$result = mysql_query("
SELECT Date, Player1,Player2,Player3,Player4,Player5,Time, IF( TIME(Time) BETWEEN '17:30:00' AND '19:30:00','FFFF66','FFFFFF') AS color
FROM Daysheets
WHERE Date ='$dateID'"); 

echo "<h1>";
echo date("l, F d, Y", strtotime($dateID));
echo "</h1>";

echo "<table align=center width=700 border=1>\n";
echo "<th>Clear</th><th>Time</th><th>Player 1</th><th>Player 2</th><th>Player 3</th><th>Player 4</th><th>Player 5</th>
<th>M</th><th>W</th><th>G</th>";

$i=0;

while($row = mysql_fetch_array( $result )) 
{
$dateID = $row['Date'];
$timeID = $row['Time'];

echo "<tr>";
echo "<td>";
echo "<input type='radio' name='time1[$i]' value='$timeID'>"; //HERE'S THE RADIO BUTTON
echo "</td><td>";
echo date("g:i ", strtotime($row[Time]));
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player1]' name='player1[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player2]' name='player2[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player3]' name='player3[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player4]' name='player4[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player5]' name='player5[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Men]' name='women'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Women]' name='women'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Guest]' name='guests'
style ='background-color:#{$row['color']};'>";

echo "<input type='hidden' name='date[$i]' value='$dateID'>";
echo "<input type='hidden' name='time2[$i]' value='$timeID'>";
echo "</td></tr>";
$i++;
}
echo "</table>";

mysql_close($con);

?>
<br /><br />

<input type="Submit" name="Submit" value="Update Tee Times">
</FORM> And here's the form action:
Code: [Select]
<?php

header("Location: /teetimes/preteetimesadmin.php");

include("opendatabase.php");

$size = count($_POST['player1']);
$timeID1 = $_POST['time1'][$i];

//HERE'S WHERE I'M TRYING TO DELETE THE DATA.
mysql_query("
UPDATE Daysheets
SET 
        Player1='',
        Player2='',
        Player3='',
        Player4='',
        Player5=''
WHERE Time ='$timeID1' ");

//HERE'S THE UPDATE, WHICH WORKS FINE.
$i=0;

while ($i < $size)
     {
     $dateID = $_POST['date'][$i];
     $timeID2 = $_POST['time2'][$i];  
     $player1 = ($_POST['player1'][$i]);
     $player2 = ($_POST['player2'][$i]);
     $player3 = ($_POST['player3'][$i]);
     $player4 = ($_POST['player4'][$i]);
     $player5 = ($_POST['player5'][$i]);

mysql_query("
UPDATE Daysheets
SET 
        Player1='$player1',
        Player2='$player2',
        Player3='$player3',
        Player4='$player4',
        Player5='$player5'

WHERE Date ='$dateID' 
AND Time ='$timeID2' ");
     $i++;
}

mysql_close($con)

?>When I add or update any information it works fine. It just won't delete anything where the radio button is clicked.
Any help appreciated! Thanks.