我通过php将值插入MySQL时遇到问题 [英] I got a problem inserting values into MySQL via php

问题描述

嗨我在向数据库中实现信息时遇到了一些麻烦



我收到了这条线



< pre lang =PHP> $ mxitid = $ _SERVER [ HTTP_X_MXIT_USERID_R];

我通过

导入我的数据库

  $ 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）; 

它的工作完美，但我遇到的问题是，如果我的值

 $ _ SERVER [  HTTP_X_MXIT_USERID_R] 

无法检索我无法将任何信息插入我的数据库。

 $ _ SERVER [  HTTP_X_MXIT_USERID_R] 

正在通过一个名为mxit的特定平台使用，所以如果我使用任何其他平台它不起作用。有没有办法改变行

  $ mxitid  = $ _SERVER [  HTTP_X_MXIT_USERID_R]; 

如果无法检索信息以插入另一个默认值（如ADMIN）而不是它？

解决方案

mxitid =

_SERVER [ HTTP_X_MXIT_USERID_R];

我要导入的我的数据库通过

sql = INSERT INTO。

Hi Im having some trouble implementing info into a database

I got the line

$mxitid = $_SERVER["HTTP_X_MXIT_USERID_R"];

Which I'm importing to my database via

$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

$_SERVER["HTTP_X_MXIT_USERID_R"]

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

the

$_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

$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?

解决方案

mxitid =

_SERVER["HTTP_X_MXIT_USERID_R"];

Which I'm importing to my database via

sql = "INSERT INTO ".

这篇关于我通过php将值插入MySQL时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！