[RESOLVED] Php and mysql interaction

[Fuzzylr]

I need some help. I am trying to post some data to an sql database and for some reason I can't. I was wondering if you guys might be able to help.

<?php

include('config.php');

$con = mysql_connect($ip, $user, $pass5);

if (!$con)

{

	die('Could not connect:' . mysql_error());

}
mysql_select_db ($db, $con) or die(mysql_error());

if($mysql = true)
{
	write('Fuzzy1', 'knights1', '[e-mail]', '2');
}

function write($value, $valueP, $valueE, $valueC)

{



if($mysql = true)
{
	$default = 'default';
	$insert = 'INSERT INTO account (username, sha_pass_hash, gmlevel, email, joindate, last_ip, failed_logins, locked, active_realm_id, expansion, mutetime) VALUES ($value, $valueP, $default, $valueE, $default, $default, $default, $default, $default, $valueC, $default)';

	$value = strtoupper($value);

	$valueP = strtoupper($valueP);

	$valueE = strtoupper($valueE);

	$valueC = strtoupper($valueC);


	if(mysql_query($insert, $con)) echo 'Inserted';
	else echo 'Failed';



	mysql_close($con);
}
else {echo 'Could not connect:' . mysql_error(); mysql_close($con);}



echo $value . ' ' . $valueP . ' ' . $valueE . ' ' . $valueC. ' '.$default;

}

?>

Sql stuff....

CREATE TABLE `account` (
  `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier',
  `username`      varchar(32) NOT NULL default '',
  `sha_pass_hash` varchar(40) NOT NULL default '',
  `gmlevel` tinyint(3) unsigned NOT NULL default '0',
  `sessionkey` longtext,
  `v` longtext,
  `s` longtext,
  `email` text,
  `joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `last_ip` varchar(30) NOT NULL default '0.0.0.0',
  `failed_logins` int(11) unsigned NOT NULL default '0',
  `locked` tinyint(3) unsigned NOT NULL default '0',
  `last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
  `active_realm_id` int(11) unsigned NOT NULL default '0',
  `expansion` tinyint(3) unsigned NOT NULL default '0',
  `mutetime` bigint(40) unsigned NOT NULL default '0',
  `locale` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC COMMENT='Account System';

Also is there a way to set all over values to default when posting?

[dagon]

several issues:

what's $mysql suppose to contain, and where is it set?

== not =

your checking $mysql twice

the mysql values will be the default if left blank in the insert.

[Fuzzylr]

dagon;10938324 wrote:

several issues:

what's $mysql suppose to contain, and where is it set?

== not =

your checking $mysql twice

the mysql values will be the default if left blank in the insert.

I have made a ton of changes. I redid the way I was connecting to the database in order to stream like a few things. I've made the changes. I will continue to test.

[Fuzzylr]

ok, so I changed to this but I can't seem to write to the database. I've tried removing the conversion to uppers and that didn't work. Ug, I hate this stuff.

made the following changes.

<?php

include('config.php');

$con = mysql_connect($ip, $user, $pass5);

if (!$con)

{

	die('Could not connect:' . mysql_error());

}
mysql_select_db ($db, $con) or die(mysql_error());

write('Sirfuzzy', 'knights1', '[e-mail]', '2');

function write($value, $valueP, $valueE, $valueC)

{


$insert = 'INSERT INTO account (username, sha_pass_hash, email, expansion) VALUES ($value, $valueP, $valueE, $valueC)';



if(mysql_query($insert, $con)) echo 'Inserted';
else echo 'Failed' . ' ' . mysql_error();



mysql_close($con);



echo $value . ' ' . $valueP . ' ' . $valueE . ' ' . $valueC;

}

?>

is there a way to get a more detailed error message? Iv'e not seen anything in the logs.

[dagon]

values need to be quoted, but you should of got an error about it.

[Fuzzylr]

dagon;10938331 wrote:

values need to be quoted, but you should of got an error about it.

I'm not.

[Fuzzylr]

$insert = 'INSERT INTO account (username, sha_pass_hash, email, expansion) VALUES ('$value', '$valueP', '$valueE', '$valueC')';

Doing this causes all kinds of errors.

[halojoy]

You need to have the value of $con inside the function write()
Variables inside a function are local.
No values from outside are automatically assigned to variables inside function.
This is why we often pass arguments to a function.

But we can also transfer the value of $con
by telling it to have same value as outside, in the global.

function write($value, $valueP, $valueE, $valueC)

{
    global $con;

$insert = 'INSERT INTO account (username, sha_pass_hash, email, expansion) 
VALUES ($value, $valueP, $valueE, $valueC)';

if(mysql_query($insert, $con)) echo 'Inserted';
else echo 'Failed' . ' ' . mysql_error();

This is how I usually quote my SQL. It works.
- Double quotes for around the whole string.
- Single quotes inside around variables.

$insert = "INSERT INTO account (username, sha_pass_hash, email, expansion)
VALUES ('$value', '$valueP', '$valueE', '$valueC')"; 

[Fuzzylr]

halojoy;10938334 wrote:

You need to have the value of $con inside the function write()
Variables inside a function are local.
No values from outside are automatically assigned to variables inside function.
This is why we often pass arguments to a function.

But we can also transfer the value of $con
by telling it to have same value as outside, in the global.

function write($value, $valueP, $valueE, $valueC)

{
    global $con;

$insert = 'INSERT INTO account (username, sha_pass_hash, email, expansion) 
VALUES ($value, $valueP, $valueE, $valueC)';

if(mysql_query($insert, $con)) echo 'Inserted';
else echo 'Failed' . ' ' . mysql_error();

This is how I usually quote my SQL. It works.
- Double quotes for around the whole string.
- Single quotes inside around variables.

$insert = "INSERT INTO account (username, sha_pass_hash, email, expansion)
VALUES ('$value', '$valueP', '$valueE', '$valueC')"; 

You are the man...thanks a ton... Fixed.