[PHP-DB] how to get the referrer page details
Hello all, I am developing a site in which user comes from different site to my site. Now i want to maintain that user comes from which site. I am using $_SERVER['HTTP_REFERER'] for that. 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']. Please help me. Regards Manoj -- Manoj Kumar Singh Software Engineer Kalptaru Infotech Ltd Dawa Bazaar Indore (MP) 452001 India
Re: [PHP-DB] how to get the referrer page details
Hello all, I am developing a site in which user comes from different site to my site. Now i want to maintain that user comes from which site. I am using $_SERVER['HTTP_REFERER'] for that. 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']. Please help me. Regards Manoj I seem to recall that $_SERVER['HTTP_REFERER'] being returned as undefined is a browser issue, not a server issue. And I couldn't find a directive for this in php.ini. Can anyone she some light on this? David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Inserting Data into MySQL database
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'].');
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. Is it because I
am not passing the values properly. Please Help
Thanks,
Girish
--
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
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'].');
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. Is it because I
am not passing the values properly. Please Help
Thanks,
Girish
Try;
show create table _tablename_;
from inside the mysql client. It will display what values are being
inserted as a default.
Remember: null and an empty string are not the same thing.
David
--
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
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'].');
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. Is it because I
am not passing the values properly. Please Help
Thanks,
Girish
TYPOS, SORRY - DPG
Try:
mysql show create table _tablename_;
from inside the mysql client. It will display what values are being
inserted as a default.
Remember: null and an empty string are not the same thing.
David
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
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
[EMAIL PROTECTED] wrote: Hello all, I am developing a site in which user comes from different site to my site. Now i want to maintain that user comes from which site. I am using $_SERVER['HTTP_REFERER'] for that. 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']. Please help me. Regards Manoj I seem to recall that $_SERVER['HTTP_REFERER'] being returned as undefined is a browser issue, not a server issue. And I couldn't find a directive for this in php.ini. This will only be set if you are coming from a referrer. If you hit the page directly, it won't be there at all. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
