PHP post $_GET variable in table field

Question

I'm having some problems trying to post $_GET variables into a table.

Here is my script:

include 'connect.php';

if(isset($_POST['client_name'])) {

$_GET['list']; //these are variables passed through from another page and I want these to post in the same table this page is suppose to post in.
$_GET['list_id'];


$Cname = $_POST['client_name'];
$Cnumber = $_POST['client_number'];
$listid = $_POST['list_id'];
$listname = $_POST['list'];


if(!empty($Cname) && !empty($Cnumber)){

    $query = "INSERT INTO clients (id, client_name, client_number, list_name, date_registered, list_id) VALUES ('$userid','$Cname', '$Cnumber', '$listname', now(), '$listid')";

    mysql_query($query);

echo '<br />
 <br />
        You successfully added a new clients to your list <a href="http://somewebsite.com/clients.php">View Update</a>';


    mysql_close();
    } 

    else {

        echo '<script type="text/javascript">alert("Both fields are required");</script>';
        }

Whenever I run the script everything else but the listname and list_id is posted in the database table. I tried assigning the get variables to new variable such as

$listNAME = $_GET['id'];

but even with that I still end up with empty fields in my table

I even tried to use the $_GET variable in the mysql INSERT query and still no luck

Can anyone help me out and give me some advice as to what I can do to solve the empty fields when the script runs.

<form action="addclient.php" method="POST">

Name of Client: <input type="text" name="client_name">

Client's Number: <input type="text" name="client_number" placeholder="1-876-xxx-xxx">

 <input type="submit" >


</form>

your columns are set to the proper data type? varchar or text or>>? — Smith Smithy
– Smith Smithy, Commented Sep 10, 2013 at 22:37
Why you are mixing $_POST and $_GET request. You are saying ending up with empty fields. How could that happen when you testing if(!empty($Cname) && !empty($Cnumber)){ So your fields $Cname and $Cnumbercan not be emtpy. — moskito-x
– moskito-x, Commented Sep 10, 2013 at 22:46
Where you setting list_name and list_id fields ? If you do it with a <form> and a submit your method mustbe method="post" . As long we cannot see your <form> we can't see what's going on. — moskito-x
– moskito-x, Commented Sep 10, 2013 at 22:56

mathielo · Accepted Answer · 2013-09-10 22:45:49Z

4

You say you have $_GET variables, but you are trying to retrieve them as $_POST variables:

$listid = $_POST['list_id'];
$listname = $_POST['list'];

Isn't it the issue? You could also try this to see what's comming in both arrays:

print_r($_GET);
print_r($_POST);

Alternatively, you could use $_REQUEST as it receives either $_GET or $_POST variables.

answered Sep 10, 2013 at 22:45

mathielo

6,7757 gold badges53 silver badges64 bronze badges

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

Comments

moskito-x · Accepted Answer · 2013-09-11 00:44:31Z

1

I say it only to notice .

Please use PDO or mysqli

if you are calling your addclient.php like

http://localhost/addclient.php?list_id=100&list=mylistname

than you must catch both variables in addclient.php

if (isset($_GET['list_id'])) {

 $listid = $_GET['list_id'];
 $listname = $_GET['list'];

}

and your form

<form action="addclient.php" method="POST">
    <input type="hidden" name="list_id" value="$listid">
    <input type="hidden" name="list" value="$listname">
Name of Client: <input type="text" name="client_name">
Client's Number: <input type="text" name="client_number" placeholder="1-876-xxx-xxx">
 <input type="submit" >
</form>

and after submit

if(isset($_POST['client_name'])) {

$Cname = $_POST['client_name'];
$Cnumber = $_POST['client_number'];
$listid = $_POST['list_id'];
$listname = $_POST['list'];
....
}

and in your insert

VALUES ('$userid','$Cname', '$Cnumber', '$listname', now(), '$listid')

$listid without quotes it's a int(11) .

VALUES ('$userid','$Cname', '$Cnumber', '$listname', now(), $listid)

edited Sep 11, 2013 at 0:44

answered Sep 10, 2013 at 23:58

moskito-x

12k5 gold badges49 silver badges61 bronze badges

1 Comment

mattchambers Over a year ago

thank you @moskito-x I used this and managed to make everything work

Collectives™ on Stack Overflow

PHP post $_GET variable in table field

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related