[PHP-DB] Database Paging
Hello, I am presently developing a search engine..I would like to have a script for paging through my database results...like "displaying 1 to 20 of 300 matches" and so on.. All help shall be appreciated, Thanx in adv.. vipin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Problem with OCIFETCHSTATEMENT function...
Hi all: I have a problem with the php function "ocifetchstatement($stmt,$table)" where $stmt comes from: $stmt=ociparse($conn,$query); ociexecute($stmt); The problem is that I can't call to this function twice or more times with the same $stmt. It appear the following message: Warning: OCIFetchStatement: ORA-01002: fetch out of sequence in I would like to know some way to rewind $stmt in order to get a cursor pointing to the beginning of the query or something else to solve this problem. Sergio -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Database Paging
What database are you using ? Jayme. I am presently developing a search engine..I would like to have a script for paging through my database results...like "displaying 1 to 20 of 300 matches" and so on.. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Database Paging
Hello, Vipin Chandran wrote: Hello, I am presently developing a search engine..I would like to have a script for paging through my database results...like "displaying 1 to 20 of 300 matches" and so on.. You may want to try to use Metabase which is a PHP abstraction package that provides that facility for all supported databases: http://phpclasses.UpperDesign.com/browse.html/package/20 You may also want to try this Query display result class that takes advantage of Metabase to display query results in HTML tables with links to go between result pages: http://phpclasses.UpperDesign.com/browse.html/package/130 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] using php to generate html file?
Does any body know how to use php to generate html file? That is when a user input for a webpage title, webpage background color or image in a php page, and then we can generate a html file which contains the properties of user's input such as background color. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] using php to generate html file?
I would use the the php to write to a CSS include. That way you have the tightest control over elements and design. Rick At 12:12 AM 3/7/01 +0800, you wrote: Does any body know how to use php to generate html file? That is when a user input for a webpage title, webpage background color or image in a php page, and then we can generate a html file which contains the properties of user's input such as background color. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] ## # Rick St Jean, # [EMAIL PROTECTED] # President of Design Shark, # http://www.designshark.com/ # Quick Contact: http://www.designshark.com/messaging.ihtml # Tel: 905-684-2952 ## -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] parsing parameter over page
any body can help me ? i confuse about parsing paramater over php pages the paramater that i try to parse was a class variable. so if i defined $a = new myclass; in a.php. can i use that variable class in my b.php. is it possible for me to do that ? i've tried using cookies, but that cookies only known my $a as an object type, i cannot access it's values. TIA andRie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] parsing parameter over page
Try this URL from the PHP manual: http://www.php.net/manual/en/function.serialize.php You could use serialize($a) on your a.php page and then to use that object, you would do unserialize($b). I think that's what you want to do. Josh Hoover KnowledgeStorm, Inc. Searching for a new IT solution for your company? Need to improve your product marketing? Visit KnowledgeStorm at www.knowledgestorm.com to learn how we can simplify the process for you. KnowledgeStorm - Your IT Search Starts Here i confuse about parsing paramater over php pages the paramater that i try to parse was a class variable. so if i defined $a = new myclass; in a.php. can i use that variable class in my b.php. is it possible for me to do that ?
RE: [PHP-DB] parsing parameter over page
Hi andrie, have you tried to 'serialize()' and 'unserialize()' your object ?? look at the 'Miscellaneous functions' in the php-manual. hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstrae 20 D-78467 Konstanz Germany fon: +49-(0)7531-89207-17 fax: +49-(0)7531-89207-13 e-mail: mailto:[EMAIL PROTECTED] internet: http://www.suchtreffer.de ___ -Original Message- From: andrie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 6:05 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] parsing parameter over page any body can help me ? i confuse about parsing paramater over php pages the paramater that i try to parse was a class variable. so if i defined $a = new myclass; in a.php. can i use that variable class in my b.php. is it possible for me to do that ? i've tried using cookies, but that cookies only known my $a as an object type, i cannot access it's values. TIA andRie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] using php to generate html file?
Any examples on this? regards, jaxon On 3/6/01 11:39 AM, "Rick St Jean" [EMAIL PROTECTED] wrote: I would use the the php to write to a CSS include. That way you have the tightest control over elements and design. Rick At 12:12 AM 3/7/01 +0800, you wrote: Does any body know how to use php to generate html file? That is when a user input for a webpage title, webpage background color or image in a php page, and then we can generate a html file which contains the properties of user's input such as background color. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] ## # Rick St Jean, # [EMAIL PROTECTED] # President of Design Shark, # http://www.designshark.com/ # Quick Contact: http://www.designshark.com/messaging.ihtml # Tel: 905-684-2952 ## -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] using php to generate html file?
?
/*
** open file for writing
*/
$filename = "data.txt";
if(!($myFile = fopen($filename, "w")))
{
print("Error: ");
print("'$filename' could not be created\n");
exit;
}
//write some lines to the file
fputs($myFile, "Save this line for later\n");
fputs($myFile, "Save this line too\n");
//close the file
fclose($myFile);
/*
** open file for reading
*/
if(!($myFile = fopen($filename, "r")))
{
print("Error:");
print("'$filename' could not be read\n");
exit;
}
while(!feof($myFile))
{
//read a line from the file
$myLine = fgets($myFile, 255);
print("$myLine BR\n");
}
//close the file
fclose($myFile);
?
At 12:27 PM 3/6/01 -0500, Jaxon wrote:
Any examples on this?
regards,
jaxon
On 3/6/01 11:39 AM, "Rick St Jean" [EMAIL PROTECTED] wrote:
I would use the the php to write to a CSS include. That way you have the
tightest control
over elements and design.
Rick
At 12:12 AM 3/7/01 +0800, you wrote:
Does any body know how to use php to generate html file? That is when
a user
input for a webpage title, webpage background color or image in a php
page,
and then we can generate a html file which contains the properties of
user's
input such as background color.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
##
# Rick St Jean,
# [EMAIL PROTECTED]
# President of Design Shark,
# http://www.designshark.com/
# Quick Contact: http://www.designshark.com/messaging.ihtml
# Tel: 905-684-2952
##
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
##
# Rick St Jean,
# [EMAIL PROTECTED]
# President of Design Shark,
# http://www.designshark.com/
# Quick Contact: http://www.designshark.com/messaging.ihtml
# Tel: 905-684-2952
##
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] parsing parameter over page
I don't think so, you'll have to persist your object in some way, for example in a database and then you only pass the id of your object. Another option is to persist your object as a string and then pass it either in the query or as post in a form. Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] MySQL - Problem with multiple INSERTs?
I did change the id fields from TINYINT to INT (that was just a careless
error), and fixed something else. But I still have the same problems. The
new table schemas are below, along with the queries that don't work.
I'd love for someone to reproduce the error. As a possible workaround,
everything seems to be fine when I prime the tables by adding a record;
they only seem to have a problem when the tables are empty.
Thanks,
Chris
mysql_connect("localhost", "myusername", "mypassword");
mysql_db_query("DocCountry", "INSERT INTO projects (idCreator, name,
comment) VALUES (1, 'sysmsg9.txt', 'Some file')");
mysql_db_query("DocCountry", "INSERT INTO files (idProject, name, comment)
VALUES (1, 'sysmsg9.txt', 'Some file')");
CREATE TABLE projects ( id int(11) NOT NULL auto_increment, timestamp
timestamp(14), idCreator int(11) DEFAULT '0' NOT NULL, name varchar(80) NOT
NULL, comment text NOT NULL, authLevel varchar(32) NOT NULL, PRIMARY KEY
(id) );
CREATE TABLE files ( id int(11) NOT NULL auto_increment, idProject int(11)
DEFAULT '0' NOT NULL, idCreator int(11) DEFAULT '0' NOT NULL, name
varchar(80) DEFAULT '0' NOT NULL, comment text NOT NULL, PRIMARY KEY (id) );
RE: [PHP-DB] php and mysql file insertion!
http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825 -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] php and mysql file insertion! Hi, I have a MySQL database that is updated using a PHP script. It stores a members details (name, address etc.) I also want it to store a file (a member photo to be exact). Is this possible? Any help is much appreciated! Thanks, Kevin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] php and mysql file insertion!
Kevin, You generally get much better performance naming and storing your file in a directory, keeping only the link in a text field in MySQL. (Or just about any other database for that matter.) Miles Thompson At 06:27 PM 3/6/01 +, Kevin Connolly wrote: Hi, I have a MySQL database that is updated using a PHP script. It stores a members details (name, address etc.) I also want it to store a file (a member photo to be exact). Is this possible? Any help is much appreciated! Thanks, Kevin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] php and mysql file insertion!
Yes. There's another tutorial on the site which addresses that question. rick -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 1:39 PM To: Rick Emery Subject: Re: [PHP-DB] php and mysql file insertion! great thanks! Will I be able to save different file types do you know? wull it work for non-picture files? Thanks again, Kev. - Original Message - From: "Rick Emery" [EMAIL PROTECTED] To: "'Kevin Connolly'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 7:28 PM Subject: RE: [PHP-DB] php and mysql file insertion! That link just failed me... Anyway, go to http://www.weberdev.com. Select the "Articles and Tutorials" link at the left. Go to the "PHP" link. Select the "Graphics" link. Select the article "Saving Images in MySQL". rick -Original Message- From: Rick Emery Sent: Tuesday, March 06, 2001 1:23 PM To: 'Kevin Connolly'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] php and mysql file insertion! http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825 -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] php and mysql file insertion! Hi, I have a MySQL database that is updated using a PHP script. It stores a members details (name, address etc.) I also want it to store a file (a member photo to be exact). Is this possible? Any help is much appreciated! Thanks, Kevin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] php and mysql file insertion!
Couldn't you also just store the image on the server, then put the path to the image (http://www.mysite.com/images/thatimg.jpg) in the database? -- David Balatero Rick Emery wrote: Yes. There's another tutorial on the site which addresses that question. rick -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 1:39 PM To: Rick Emery Subject: Re: [PHP-DB] php and mysql file insertion! great thanks! Will I be able to save different file types do you know? wull it work for non-picture files? Thanks again, Kev. - Original Message - From: "Rick Emery" [EMAIL PROTECTED] To: "'Kevin Connolly'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 7:28 PM Subject: RE: [PHP-DB] php and mysql file insertion! That link just failed me... Anyway, go to http://www.weberdev.com. Select the "Articles and Tutorials" link at the left. Go to the "PHP" link. Select the "Graphics" link. Select the article "Saving Images in MySQL". rick -Original Message- From: Rick Emery Sent: Tuesday, March 06, 2001 1:23 PM To: 'Kevin Connolly'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] php and mysql file insertion! http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825 -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] php and mysql file insertion! Hi, I have a MySQL database that is updated using a PHP script. It stores a members details (name, address etc.) I also want it to store a file (a member photo to be exact). Is this possible? Any help is much appreciated! Thanks, Kevin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] php and mysql file insertion!
Yes, you can. But you still ahve to extract it and format it for display. The tutorial explains the ins and outs of the process. -Original Message- From: David Balatero [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 2:03 PM To: Rick Emery Cc: 'Kevin Connolly'; '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] php and mysql file insertion! Couldn't you also just store the image on the server, then put the path to the image (http://www.mysite.com/images/thatimg.jpg) in the database? -- David Balatero Rick Emery wrote: Yes. There's another tutorial on the site which addresses that question. rick -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 1:39 PM To: Rick Emery Subject: Re: [PHP-DB] php and mysql file insertion! great thanks! Will I be able to save different file types do you know? wull it work for non-picture files? Thanks again, Kev. - Original Message - From: "Rick Emery" [EMAIL PROTECTED] To: "'Kevin Connolly'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 7:28 PM Subject: RE: [PHP-DB] php and mysql file insertion! That link just failed me... Anyway, go to http://www.weberdev.com. Select the "Articles and Tutorials" link at the left. Go to the "PHP" link. Select the "Graphics" link. Select the article "Saving Images in MySQL". rick -Original Message- From: Rick Emery Sent: Tuesday, March 06, 2001 1:23 PM To: 'Kevin Connolly'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] php and mysql file insertion! http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825 -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] php and mysql file insertion! Hi, I have a MySQL database that is updated using a PHP script. It stores a members details (name, address etc.) I also want it to store a file (a member photo to be exact). Is this possible? Any help is much appreciated! Thanks, Kevin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] php and mysql file insertion!
Yeah, but I also want t do some encrpyption stuff and I have to store a *.pgp file! I suppose I could do the same for this but I would prefer to have them both in the database! -Kev. - Original Message - From: "David Balatero" [EMAIL PROTECTED] To: "Rick Emery" [EMAIL PROTECTED] Cc: "'Kevin Connolly'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 8:03 PM Subject: Re: [PHP-DB] php and mysql file insertion! Couldn't you also just store the image on the server, then put the path to the image (http://www.mysite.com/images/thatimg.jpg) in the database? -- David Balatero Rick Emery wrote: Yes. There's another tutorial on the site which addresses that question. rick -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 1:39 PM To: Rick Emery Subject: Re: [PHP-DB] php and mysql file insertion! great thanks! Will I be able to save different file types do you know? wull it work for non-picture files? Thanks again, Kev. - Original Message - From: "Rick Emery" [EMAIL PROTECTED] To: "'Kevin Connolly'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 7:28 PM Subject: RE: [PHP-DB] php and mysql file insertion! That link just failed me... Anyway, go to http://www.weberdev.com. Select the "Articles and Tutorials" link at the left. Go to the "PHP" link. Select the "Graphics" link. Select the article "Saving Images in MySQL". rick -Original Message- From: Rick Emery Sent: Tuesday, March 06, 2001 1:23 PM To: 'Kevin Connolly'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] php and mysql file insertion! http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825 -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] php and mysql file insertion! Hi, I have a MySQL database that is updated using a PHP script. It stores a members details (name, address etc.) I also want it to store a file (a member photo to be exact). Is this possible? Any help is much appreciated! Thanks, Kevin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Sybase-ct in Linux and MS SQL 2000
I just installed a Sybase_CT module in php 4.0 on a linux machine. I'm trying to move a web site from a buggy and crashy NT box but I'm having trouble with the mssql_result call. This is what I get. Warning: 2 is not a valid Sybase result resource in /var/www/html/crap.php on line 54 Line 54 reads: $ssn = mssql_result($result,$a,0); I also get this error on all the mssql_result on the for loop. I made it work changing it with mssql_fetch_* calls but I want to move a big site to the Linux box and it would be a momumetal task rewriting the whole code. Can you please help? Thanks Sergio PS The same problem occurs with MS SQL 7.0 and MS SQL 2000 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] detect cookies
Hello php-db, can i detect weather user has enable or not their cookies ? or is there any function that can read browser setup ? -- Best regards, andrie mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] MySQL - Problem with multiple INSERTs?
Try this changes:
$con_id = mysql_connect("localhost", "myusername", "mypassword");
if($con_id){
mysql_db_query("DocCountry", "INSERT INTO projects (idCreator, name,
comment) VALUES (0, 'sysmsg9.txt', 'Some file')");
mysql_db_query("DocCountry", "INSERT INTO files (idProject, name,
comment) VALUES (0, 'sysmsg9.txt', 'Some file')");
}
else echo("Connection failed");
-Mensagem Original-
De: Chris [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 6 de maro de 2001 16:13
Assunto: Re: [PHP-DB] MySQL - Problem with multiple INSERTs?
I did change the id fields from TINYINT to INT (that was just a careless
error), and fixed something else. But I still have the same problems. The
new table schemas are below, along with the queries that don't work.
I'd love for someone to reproduce the error. As a possible workaround,
everything seems to be fine when I prime the tables by adding a record;
they only seem to have a problem when the tables are empty.
Thanks,
Chris
mysql_connect("localhost", "myusername", "mypassword");
mysql_db_query("DocCountry", "INSERT INTO projects (idCreator, name,
comment) VALUES (1, 'sysmsg9.txt', 'Some file')");
mysql_db_query("DocCountry", "INSERT INTO files (idProject, name, comment)
VALUES (1, 'sysmsg9.txt', 'Some file')");
CREATE TABLE projects ( id int(11) NOT NULL auto_increment, timestamp
timestamp(14), idCreator int(11) DEFAULT '0' NOT NULL, name varchar(80)
NOT
NULL, comment text NOT NULL, authLevel varchar(32) NOT NULL, PRIMARY KEY
(id) );
CREATE TABLE files ( id int(11) NOT NULL auto_increment, idProject int(11)
DEFAULT '0' NOT NULL, idCreator int(11) DEFAULT '0' NOT NULL, name
varchar(80) DEFAULT '0' NOT NULL, comment text NOT NULL, PRIMARY KEY
(id) );
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] detect cookies
I've never used but there is a php function "get_browser()" which might do
the work.
I think the best way is set the cookie and try to get it again, if you can
get it the user has cookies enabled.
setcookie("name",value,$cookieLifeTime,$cookiePath);
if($name) echo("Cookie is enabled");
HTH
Jayme.
-Mensagem Original-
De: andrie [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 6 de maro de 2001 18:34
Assunto: [PHP-DB] detect cookies
Hello php-db,
can i detect weather user has enable or not their cookies ?
or is there any function that can read browser setup ?
--
Best regards,
andrie mailto:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
