I got a problem inserting values into MySQL via php

Question

0.00/5 (No votes)

See more:

Hi Im having some trouble implementing info into a database

I got the line

PHP

$mxitid = $_SERVER["HTTP_X_MXIT_USERID_R"];

Which I'm importing to my database via

PHP

$sql = "INSERT INTO ".$dbTable." (StringyChat_ip,StringyChat_name,StringyChat_message,StringyChat_time,mxit_id) VALUES (\"$ip\",\"$name\",\"$message\",$post_time,$mxitid)";
                  $result = mysql_query($sql);

well its working perfectly, but the problem I'm experiencing is that if my value

PHP

$_SERVER["HTTP_X_MXIT_USERID_R"]

cannot be retrieved I can't insert any info to my database.

the

PHP

$_SERVER["HTTP_X_MXIT_USERID_R"]

is being used via a specific platform called mxit, so if I use any other platform it don't work. Is there maybe a way to change the line

PHP

$mxitid = $_SERVER["HTTP_X_MXIT_USERID_R"];

to a function if the info couldn't be retrieved to insert another default value like ADMIN rather in the place of it?

Posted 31-Aug-14 6:13am

cobusbo

Updated 31-Aug-14 6:16am

v2

Add a Solution

Comments

Mohibur Rashid 31-Aug-14 19:15pm

the header is set by the client application. Your MXIT was the responsible to do the job. I am not sure if it is possible to change the header on request. You can add the Id with your data posting. or you can set the value through PHP or Javascript. in PHP header("HTTP_X_MIXIT_USERID_R : someid"); is suppose to work. with javascript follow this link, http://stackoverflow.com/questions/11214718/is-it-possible-to-alter-http-requests-header-using-javascript
it may help

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

cobusbo · Answer 1 · 2014-08-31T13:20:00

Solution 1

PHP

$mxitid = $_SERVER["HTTP_X_MXIT_USERID_R"];

if(!isset($mxitid))
{
    $mxitid = "DEFAULT";
}

Did the job perfectly...

Posted 31-Aug-14 13:20pm

cobusbo

I got a problem inserting values into MySQL via php

1 solution

Solution 1

Add your solution here

Preview 0

I got a problem inserting values into MySQL via php

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us