Cant get field values with space from mysql using php

Question

I am trying to pass variable that containing the values with space through href but I fail to get the expected output with space.

The code I used is:

print " <a href=update.php?id='$id'&name=$name&dob='$dob'&email='$email'>Update Details</a> <br>
        Student ID: $id<br> Student Name: $name<br> Date Of Birth: $dob<br> Email ID: $email<br>";

In update.php I could see the link as

localhost/student_portal/update.php?id='abc'&name=Giridharan

and I didn't get the full name and dob and email

My variables with values are as follows:

$id=abc
$name=Giridharan Rengarajan
$dob=1993-07-22
[email protected]

What should I do to get all the four values in update.php?

$query_string = 'id='.urlencode($id).'&name='.urlencode($name).'&dob='.urlencode($dob).'&email='.$email; echo htmlentities($query_string); print " <a href=update.php?htmlentities($query_string)>Update Details</a> Student ID: $id Student Name: $name Date Of Birth: $dob Email ID: $email "; the urs i got is localhost/student_portal/… how can i extract values from that.? — user2603693
– user2603693, Commented Jul 21, 2013 at 8:13

Duleendra · Accepted Answer · 2013-07-21 09:41:28Z

1

Since spaces are not legal parts of the query string you have to encode them.

Eg: Use rawurlencode / rawurldecode

<a href=update.php?id='$id'&name=rawurlencode($name)&dob='$dob'&email='rawurlencode($email)'>Update Details</a>

answered Jul 21, 2013 at 9:41

Duleendra

4971 gold badge5 silver badges22 bronze badges

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

1 Comment

user2603693 Over a year ago

it returns only first part of my name (ie before the space)

srain · Accepted Answer · 2013-07-21 08:22:14Z

0

You can get the variables in update.php by:

<?php
$id = $_GET['id'];
$name = $_GET['name'];
$dob = $_GET['dob'];
$email = $_GET['email'];

answered Jul 21, 2013 at 8:22

srain

9,1426 gold badges32 silver badges43 bronze badges

Comments

Andrej · Accepted Answer · 2013-07-21 09:39:42Z

0

For proper creation of url you can use http_build_query. See examples here http://www.php.net/manual/en/function.http-build-query.php

Create array of your params, put it into this function and to your update script like a string.

answered Jul 21, 2013 at 9:39

Andrej

7,5041 gold badge22 silver badges22 bronze badges

Collectives™ on Stack Overflow

Cant get field values with space from mysql using php

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related