Passing variable from URL + Selecting from SQL and Echoing it

Question

Title is a little hard to understand, so basically I'm making a Pastebin clone and am attempting to do a kind of viewmember.php?id=1213 thing for viewing pastes. However, I can't figure it out at all. I've done a lot of research, and after finally understanding what I had to do (or so I thought) I made this up and don't know why it isn't working.

<?php
require 'connection.php';
    $getid = $_GET["id"];
    $sql = "SELECT * FROM pasteinfo WHERE id = ?";
    $stmt = $con->prepare($sql);
    $stmt->bind_param("i", $getid);
    echo $stmt;

?>

I'm probably just stupid. Thanks for the help.

You need to execute the statement to actually get any results. — M. Eriksson
– M. Eriksson, Commented Oct 5, 2016 at 4:30

Indrasis Datta · Accepted Answer · 2016-10-05 04:50:04Z

1

You need to run the command to execute the query.

$sql = "SELECT field1, field2 FROM pasteinfo WHERE id = ?"; // Specify fields in query
$stmt->bind_param("i", $getid);  /* bind parameters for markers */
$stmt->execute();  /* execute query */
$stmt->bind_result($field1, $field2); /* bind result variables */
$stmt->fetch();    /* fetch value */
echo "Field 1:".$field1;
echo "Field 2:".$field2;

Reference: Example #1 mysqli::prepare() example

edited Oct 5, 2016 at 4:50

answered Oct 5, 2016 at 4:40

Indrasis Datta

8,6182 gold badges18 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

index.php Over a year ago

Thanks! How do I echo the result?

Indrasis Datta Over a year ago

In order to echo the result, it's the best if you specify the fields in SELECT instead of mentioning SELECT *

Rafiqul Islam Over a year ago

$result = $stmt->execute(); foreach($result as $val){ echo $val->item_name; }

index.php Over a year ago

Don't really see what you mean Object Manipulator with the fields. I'm not trying to make a search box or anything, just allow them to access pastes through the URL like the example in the OP. Maybe I'm stupid, not sure, but where do the fields fit in?

Rafiqul Islam · Accepted Answer · 2016-10-05 05:15:00Z

0

// save result in a variable and then run a loop and echo 
$result = $stmt->execute(); 

foreach($result as $val){ 
    echo $val->item_name; 
}

edited Oct 5, 2016 at 5:15

answered Oct 5, 2016 at 4:51

Rafiqul Islam

1,6561 gold badge14 silver badges25 bronze badges

5 Comments

index.php Over a year ago

Trying to use that in my code but it isn't working. This is how it looks with it: <?php require 'connection.php'; $getid = $_GET["id"]; $sql = "SELECT * FROM pasteinfo WHERE id = ?"; $stmt = $con->prepare($sql); $stmt->bind_param("i", $getid); $result = $stmt->execute(); // save result in a variable and then run a loop and echo foreach($result as $val){ echo $val->item_name; } ?>

Rafiqul Islam Over a year ago

remove this // save result in a variable and then run a loop and echo

index.php Over a year ago

@Rafij nothing's happened

Rafiqul Islam Over a year ago

run this line echo " <pre>" ; print_r($result);

index.php Over a year ago

@Rafij the web page displays '1'

Collectives™ on Stack Overflow

Passing variable from URL + Selecting from SQL and Echoing it

2 Answers 2

4 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related