Write Forums

for some reason mysql query not working, not inserting, please check it out

Posted on 16th Feb 2014 07:03 pm by admin

This code is not inserting anything into my db, don't know why, the $_SESSION variable does contain data.

Please have a look.
Code:
function add_user_to_db()
{
//print_r($_SESSION['user_reg']);
$username = $_SESSION['user_reg']['username'];
$password = $_SESSION['user_reg']['password'];
$email = $_SESSION['user_reg']['email'];
$first_name = $_SESSION['user_reg']['first_name'];
$last_name = $_SESSION['user_reg']['last_name'];
$pharmacyname = $_SESSION['user_reg']['pharmacyname'];
$contact_number = $_SESSION['user_reg']['contact_number'];

$connection = db_connect();
$query = "INSERT INTO `pharma_edu`.`users` (`user_id`, `username`, `password`, `email`, `first_name`, `last_name`, `pharmacy_name`, `contact_number`, `user_access`, `active`) VALUES (NULL, '$username','$password', '$email', '$first_name', '$last_name', '$pharmacyname', '$contact_number', '1', 'n')";

if (mysql_query($query))
{
return true;
}else{
return false;
}
}
add_user_to_db();

No comments posted yet

231 21 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Converting RGB values to HEX 
Code: <?PHP

$file_handle = fopen("colors/rgb.csv", "r");

wh
writing a screen scraper 
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses
why this query can delete duplicates ? 
why this query can delete duplicates ? Anybody can give me the detailed explanation ?



Tha
Shuffle between users ?? 
I have multiple $users in table. I need to send them $message.

I need to send the next messag
Need a fuction to count entries in a field 
Hi
I need a fuction to count how many times a email address is entered in to a field.

I ma
 Bluetooth RSSI & VIsta  
Okie I got 4 Bluetooth adapters, a DBT-120 by Dlink, A Zonet Microsoft Bluetooth which is what I use
Display a default image 

I am trying to display generic image for items that don't have one, but I can't get it to display.