Re: [PHP-DB] how to get the referrer page details
Am Donnerstag, 15. Juni 2006 15:46 schrieb Manoj Singh: Now i came to know that this variable is not supported by some servers or it can be set off in php.ini setting. So can any one help me doing this without using $_SERVER['HTTP_REFERER']. That how the things are. Sometimes others do not act like one likes to. You should respect that some individuals do not want you to get that information. I bet, that is not really a big thing, isn't it? Best Regards, Oliver -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Inserting Data into MySQL database
Am Donnerstag, 15. Juni 2006 22:42 schrieb Girish Agarwal:
Hi All,
I have a table in mySQL database 5.0 the structure of which is as
follows
ssno INT 9,
lname VARCHAR(15) NOT NULL,
fname VARCHAR(15) NOT NULL,
I am inserting the values using
$query = insert into student (ssno,lname,fname) VALUES
('.$student['ssno'].','.$student['lname'].','.$student['fname'].');
$query = INSERT INTO student (ssno,lname,fname) VALUES (12345,'','');
This Query is working Fine but the only Problem I have is that if
the lname and fname values are NULL then how come it does not return an
error but instead adds the record into the database.
You pass emtpy strings. ('') Try this
$query = INSERT INTO student (ssno,lname,fname) VALUES (12345,NULL,NULL);
Best Regards,
Oliver
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to get the referrer page details
I use $_SERVER['REMOTE_ADDR'], but the notes at http://us2.php.net/getenv say you may want to also use HTTP_X_FORWARDED_FOR (and not even getenv but $_SERVER as you were attempting). Regards, Dwight -Original Message- From: Oliver Block [mailto:[EMAIL PROTECTED] Sent: Friday, June 16, 2006 1:48 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] how to get the referrer page details Am Donnerstag, 15. Juni 2006 15:46 schrieb Manoj Singh: Now i came to know that this variable is not supported by some servers or it can be set off in php.ini setting. So can any one help me doing this without using $_SERVER['HTTP_REFERER']. That how the things are. Sometimes others do not act like one likes to. You should respect that some individuals do not want you to get that information. I bet, that is not really a big thing, isn't it? Best Regards, Oliver -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Forms with letter security
I have a set of graphical letters A to Z. I want some displayed and then keyed into a security field to verify a person is submitting the form. I have seen these used before on shopping carts. I know about creating salts to select which letters to choose. What I am wondering is if there is a way to join the letters together instead of having 6 different images displayed. Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
