Sending data from DB to web page

Question

In my form i enter ID of student, which is located in database. On submit I send entered ID to external script, where i search for name of student with entered ID. This works, and after i echo it's name it's correct, but I don't know how to send data back to the my web page so I could read student's name with GET from address bar. Code:

$con=mysqli_connect("localhost","root","","novi-studomat");
if (mysqli_connect_errno($con))
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$id=$_POST['id'];
$exe="SELECT * FROM student WHERE id='$id'";
$query=mysqli_fetch_array(mysqli_query($con,$exe));
$ime=$query['name'];

I've tried with this:

header('Location:http://www.administrator.html.php?name=".$name."');

But it doesn't sends data to the page. This worked, but I think that there must be more elegant solution:

echo "<script>window.location.assign('http://www.administrator.html.php?name=".$name."'); </script>";

Location:http://www.administrator.html.php?name=".$name.". impressive — Prisoner
– Prisoner, Commented Apr 11, 2013 at 16:41
There are two common ways to send data from the client to the server. A <form> or ajax. — user1032531
– user1032531, Commented Apr 11, 2013 at 16:44
@IvanPandžić I didn't mean that to come off as sarcastic, I was just poking fun at the url. — Prisoner
– Prisoner, Commented Apr 11, 2013 at 22:24

razz · Accepted Answer · 2013-04-11 16:43:59Z

1

Try this:

header('Location: http://www.administrator.html.php?name=' .$name);

answered Apr 11, 2013 at 16:43

razz

10.1k7 gold badges55 silver badges74 bronze badges

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

2 Comments

Ivan Pandžić Over a year ago

Tnx for fast help, it is a small problem, but I'm begginer and searching on the net takes me a lot of time...

razz Over a year ago

no problem :), note that the parameters dont need to be wrapped with quotes " or '

user1978081 · Accepted Answer · 2013-04-11 16:51:27Z

0

it's simple. when you work on database table you should use primary id not other data. if you know primary id of a table, you can write any query in anywhere even you can store this id in session

answered Apr 11, 2013 at 16:51

user1978081

Collectives™ on Stack Overflow

Sending data from DB to web page

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related