[PHP-DB] Database Paging

2001-03-06 Thread Vipin Chandran
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

[PHP-DB] Problem with OCIFETCHSTATEMENT function...

2001-03-06 Thread Sergio
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: OCIFe

Re: [PHP-DB] Database Paging

2001-03-06 Thread jjeffmanweb
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 PROT

Re: [PHP-DB] Database Paging

2001-03-06 Thread Manuel Lemos
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 provid

[PHP-DB] using php to generate html file?

2001-03-06 Thread Fai
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 (ht

Re: [PHP-DB] using php to generate html file?

2001-03-06 Thread Rick St Jean
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 ima

[PHP-DB] parsing parameter over page

2001-03-06 Thread andrie
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 on

RE: [PHP-DB] parsing parameter over page

2001-03-06 Thread Hoover, Josh
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

RE: [PHP-DB] parsing parameter over page

2001-03-06 Thread Michael Rudel
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 - ___ Suc

Re: [PHP-DB] using php to generate html file?

2001-03-06 Thread Jaxon
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 ho

Re: [PHP-DB] using php to generate html file?

2001-03-06 Thread Rick St Jean
\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 t

[PHP-DB] php and mysql file insertion!

2001-03-06 Thread Kevin Connolly
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.

Re: [PHP-DB] parsing parameter over page

2001-03-06 Thread Lennin Arriola
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 Dat

Re: [PHP-DB] MySQL - Problem with multiple INSERTs?

2001-03-06 Thread Chris
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, everyth

RE: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Rick Emery
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

RE: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Rick Emery
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, 20

Re: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Miles Thompson
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 i

RE: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Rick Emery
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

Re: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread David Balatero
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-

RE: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Rick Emery
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

Re: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Kevin Connolly
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: "'

[PHP-DB] Sybase-ct in Linux and MS SQL 2000

2001-03-06 Thread Sergio Murillo
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 r

[PHP-DB] detect cookies

2001-03-06 Thread andrie
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 P

Re: [PHP-DB] MySQL - Problem with multiple INSERTs?

2001-03-06 Thread JJeffman
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, commen

Re: [PHP-DB] detect cookies

2001-03-06 Thread JJeffman
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 Jaym

Re: [PHP-DB] detect cookies

2001-03-06 Thread Miles Thompson
Reminder - page has to be reloaded before cookie becomes visible. (or should I say is picked up by the browser.) Use phpinfo() to double check. Miles At 07:51 PM 3/6/01 -0300, JJeffman wrote: >I've never used but there is a php function "get_browser()" which might do >the work. >I think the be