[PHP-DB] static or dynamic "printer-friendly" webpages?

Question for all you php experts out there: My organization's website is based on mysql/php backend - 95% of the webpages are generated dynamically using templates and database records. We have been asked to create "printer-friendly" versions of these pages. Now for your opinion/advice: shou

[PHP-DB] Adobc error

Hello guys Does anyone know what the following error means and how I can fix it? ** Fatal error: Failed opening required './adodb/adodb.inc.php' (include_path='.:/usr/share/php') in /home/thesis/public_html/registro.php on line 7 Than

[PHP-DB] Using regexps to clean up html files

hi all, I have a very large project where I have to insert information from a large number of HTML files. They are pulled from a public web database so they are somewhat consistent in format. However not all fields are present in each. So what I have decided to do is. Write a script that parses

Re: [PHP-DB] Storing Code in a db?

At 27.06.2001 14:06, you wrote: >Hey there, >Is it possible to store code like a function, for example, in a mysql >database and pull it into a php dynamicallly so you can use the function if >needed? Not in a way that would be effective, the only way I could see it work is if you use a script

Re: [PHP-DB] error ORA-12699

Try using $connect_string="ORCL"; Wayne sang wrote: > > I have read some doc. > $connect_string is set to equal from tnsnames.ora. > > $connect_string="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = > 192.168.1.1)(PORT = 1521))(CONNECT_DATA = (SID = ORCL)))"; > > I can connect my local o

Re: [PHP-DB] Modify Query, or sift through results?

Couldn't you use"SELECT DISTINCT" for this? http://www.mysql.com/doc/S/E/SELECT.html - Original Message - From: "Joseph Koenig" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 27, 2001 8:54 AM Subject: [PHP-DB] Modify Query, or sift through results? > I'

Re: [PHP-DB] Oracle Client to connect to remote DB

Do you know if the Oracle client can beinstalled via the command line? I don't have access to the box itself, only telnet access. Jeff ""Brian S. Dunworth"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Jeff, > > As far as I know, you cannot get *only* th

[PHP-DB] delay script

hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on "logout" button, it will show a page which will say "logging out" then after 5 seconds it will redirect to the login page. thanks =) -- PHP Database Mailing List (http://www.php.net/) To unsu

Re: [PHP-DB] Storing Code in a db?

Mark @ 10base-t pressed the little lettered thingies in this order... > Hey there, > Is it possible to store code like a function, for example, in a mysql > database and pull it into a php dynamicallly so you can use the function if > needed? > Yes, it is possible, but you need to run the code

Re: [PHP-DB] MySQL Error???

In article , [EMAIL PROTECTED] (Brian Grayless) wrote: > Is anyone familiar with this MySQL error? > > "1062: Duplicate entry '127' for key 1" You have a unique key (likely the primary key field). There is already a record with value "127" in t

RE: [PHP-DB] MySQL Error???

sounds like your field definition is something like int(2) or something, it needs to be bigger so that it can handle higher numbers for the unique primary key :) // -Original Message- // From: Brian Grayless [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 28 June 2001 12:24 AM // To: PHP DB

[PHP-DB] PHP & Oracle Stored Functions

Hi, Anyone have information on calling a stored function? Is it similar to a stored procedure? How to you access a return, thorugh OCIBindByName? Regards, Laurence Veale ext 6172 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comm

Re: [PHP-DB] managing variant data

Guten Tag Herr Scott, Montag, 25. Juni 2001, 11:21:42, schrieben sie: JS> Hi again, another conundrum. JS> What is the best way to deal with the following situation? JS> You have a group of common properties including a property that indicates a JS> second group of common properties. For exa

Re: [PHP-DB] MySQL Error???

Hi, This error occurs when your auto_increment index field is of type TINYINT. This field type can accept values form -128 to 127 so you cannot add records with index value greater than 127. I recommend you change it to INT(11) UNSIGNED which can accept values from 0 to 4294967295. If you expect

Re: [PHP-DB] Modify Query, or sift through results?

Hi, you could use the FIND_IN_SET(str,strlist) function which returns a value 1 to N if the string str is in the list strlist consisting of N substrings. Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. If you want to find all the reco

[PHP-DB] Passing XML

Hi there Is there anyway of passing a xml document to a php page as raw data. What I want to do is eg. send a page a xml document and recieve a response ( in xml ) from that page. I could eg get the result using fopen( 'http://url.com/xml.php' , 'r' ) but how do i send it any data without usin

RE: [PHP-DB] Database access using ODBC

Hi Miles, Andrew, rest of list, After checking ODBC traces and stripping the code down to the barebones, I found that there was two problems: Firstly, trying to do too many things in one statement didn't work, so I broke the following out into two statements: Was: --- #Open a persistent connec

RE: [PHP-DB] Storing Code in a db?

Hi Mark, ... yes, I think it's possible. Look at the Function 'eval()' in Chapter 'XXXVIII. Miscellaneous functions'. You will to have to experiment with escaping Char's. Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21.

Re: [PHP-DB] MySQL Error???

The error is probably caused by you inserting a value (127) nto a unique or key field which is identical to one in another record. -- Phil Driscoll -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] PostgreSQL errors on persistent connections in PHP 4.0.6

Hi - I have discovered an issue in PHP 4.0.6 and PostgreSQL (I'm running 7.1.2) where PHP will not return/show the entire error messages involving PostgreSQL when using persistent connections. A simple example would be: [PHP 4.0.5] Unable to connect to PostgreSQL server: Password authentication

RE: [PHP-DB] static or dynamic "printer-friendly" webpages?

Hi Shawna, ... the best (and professional) way are dynamic PDF's. Its a bit of work, but you can be sure that everyone can print them. You could create a PHP script that converts your dynamic web page into a static, printerfriendly PDF or you could try a pdf-printer, print the page to file and se

Re: [PHP-DB] FW: strange numbers in link

Shawna, Feel free to change this value, it doesn't appear to bear any significance and is probably a typo. Jason k Larson <[EMAIL PROTECTED]> wrote in message BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1">news:BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1... > Our website uses mysql/php. I

Re: [PHP-DB] How do I keep the values of objects when refreshing page?

Please be more specific. "Hector M Banda" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi all, > > My page is getting the values and the submits itself displaying the > information but the original selection is gone showing the objects with > no info. > > >

RE: [PHP-DB] MySQL Error???

Brian, Sounds to me as if the field you have as primary key is set to type 'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when set to 'unsigned' it accepts values from 0 to 255. In your place I would concider changing that column to a 'SMALLINT' and set it to 'unsigned'. Th

Re: [PHP-DB] flash

You might also check out libswf. http://www.php.net/manual/en/ref.swf.php -- 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] static or dynamic "printer-friendly" webpages?

hmmm, let me think about this. unless you are crazy you will choose your to stay dynamic. Can you imagine keeping track of new records... "let's click the PF version so I can print this... What the hell! Shawna I can't print this damn thing. This link doesn't work. blah blah..." It only gets wors

[PHP-DB] delay script

hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on "logout" button, it will show a page which will say "logging out" then after 5 seconds it will redirect to the login page. thanks =)

RE: [PHP-DB] Adobc error

It means that the registro.php script can't find the required file adodb.inc.php. Check the path of the requite statement on line 7 of registro.php (looking at the error msg. it could be the '.:' before the '/usr...' causing the problem). /Christian -Original Message- From: Wilmar Pérez

RE: [PHP-DB] Adobc error

Wilmar, it means that a file which is "included" via the "require()" function cannot be found. usually this is because they are doing something like require( $ROOT . "/the/file/they/want.php"); and you haven't set $ROOT properly, or something like that. basically, search registro.php for "requir

[PHP-DB] mysql errors .... or php errors ????

i know this may not be stricktly php but ... soemtimes when i return queries from mysql to php i get errors like 'invalid index test assumed 'test' in test.php at line 13' can't remember the exact syntax but that's the general idea. if i quote the var when i reference it the error goes awa

RE: [PHP-DB] Adobc error

you need to find adodb.inc.php and then check that the path in the include statement on line 7 in adodb.inc.php is pointing at the correct path. Steve > -Original Message- > From: Wilmar Pérez [mailto:[EMAIL PROTECTED]] > Sent: 27 June 2001 23:48 > To: PHP List > Subject: [PHP-DB] Adobc

Re: [PHP-DB] delay script

You may find that the HTML tag can help you there. -- 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 errors .... or php errors ????

This isn't a mySQL error. PHP is complaining about the quoting of variables. Check for magic_quotes or the like in your php.ini file -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

Re: [PHP-DB] delay script

sorry so brief earlier .. anyway this is a working sample http://www.php.net";> -- 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] static or dynamic "printer-friendly" webpages?

I would recommend staying as dynamic as possible. To answer your question, yes, another simple template (one designed to be friendly to printers) would easily work to do what you need. PDF is an interesting option but a lot of work and the clients/customers would need to ensure having the proper

Re: [PHP-DB] mysql errors .... or php errors ????

Another thought came to mind. These errors could be the result of verbose error reporting by PHP. php.ini or a script could be setting error reporting high enough to display these errors, however it's extremely poor PHP coding syntax to not correctly quote everything (except constants, of course)

Re: [PHP-DB] static or dynamic "printer-friendly" webpages?

I use a method combining both; I first write a so-called 'print.php' which has the ability to write a outputted page to a disk cache on the disk. So pages are only generated the first time they're accessed; on second and further requests they're serverd directly from the cache (disk in my case).

Re: [PHP-DB] Adobc error

Seems you're missing the file 'adodb.inc.php' in any of your include paths, namely '.' and '/usr/share/php'. Either extend the include_path directive in php.ini to make sure adodb.inc.php is in the include path or copy the fileto an appropriate directory. HTH, Markus On Wed, Jun 27, 2001 at 05:

Re: [PHP-DB] Storing Code in a db?

It's possible. Store the function as a text field, retrieve it and use eval($fieldvalue); > Hey there, > Is it possible to store code like a function, for example, in a mysql > database and pull it into a php dynamicallly so you can use the function if > needed? > > Mark > Leo -- PHP Database

[PHP-DB] Dbase function problem AGAIN !!!

Why noone answer ? Hi My problem is I have dbf file, I get one record, one of the record's filed is binary (32 b its). The function dbase_get_record cut Least Sagnificant Bit from this file , I of course I get wrong value. Can anyone help me? Is there sth wrong with function? Thax in advance Bar

Re: [PHP-DB] MySQL Error???

At 27.06.2001 17:24, Brian Grayless wrote: >Is anyone familiar with this MySQL error? > >"1062: Duplicate entry '127' for key 1" >I wrote a great bookmark management program that works fine, but everytime I >insert bookmarks, I insert somewhere over 120 and I start getting this >error, and it won'

Re: [PHP-DB] static or dynamic "printer-friendly" webpages?

At 27.06.2001 23:13, [EMAIL PROTECTED] wrote: >Question for all you php experts out there: > >My organization's website is based on mysql/php backend - 95% of the >webpages are generated dynamically using templates and database records. > >We have been asked to create "printer-friendly" versions o

Re: [PHP-DB] Modify Query, or sift through results?

On Wed, Jun 27, 2001 at 08:54:04AM -0500, Joseph Koenig wrote: > I've got a script that searches a db every night and sends out e-mail if > it finds something a person would be interested in, based on criteria > they gave us. The problem is that I have one field that stores regions > of the countr

Re: [PHP-DB] MySQL Error???

Most likely, your id (index, auto-increment field, whatever it is) data type is tinyint which only goes to 127. Brian Grayless <[EMAIL PROTECTED]> said: > Is anyone familiar with this MySQL error? > > "1062: Duplicate entry '127' for key 1" > I wrote a great bookmark management program that wor

Re: [PHP-DB] MySQL Error???

Hi You create a unique index (i think primary) an try to enter a key that is already in the table. greetings saul - Original Message - From: "Brian Grayless" <[EMAIL PROTECTED]> To: "PHP DB list (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, June 27, 2001 12:24 PM Subject: [PHP-DB] MySQL

Re: [PHP-DB] MySQL Error???

on 6/27/01 9:24 AM, Brian Grayless at [EMAIL PROTECTED] wrote: > "1062: Duplicate entry '127' for key 1" > I wrote a great bookmark management program that works fine, but everytime I > insert bookmarks, I insert somewhere over 120 and I start getting this > error, and it won't add them anymore.

Re: [PHP-DB] MySQL Error???

On Wed, Jun 27, 2001 at 10:24:13AM -0600, Brian Grayless wrote: > Is anyone familiar with this MySQL error? > "1062: Duplicate entry '127' for key 1" The error means you are attempting to put a second record in with the value of 127. > I wrote a great bookmark management program that works fine,

[PHP-DB] mssql_xxx() and characters

I tried different solutions and it has led me to suspect a something-or-another in mssql_query() function. However, the problem could originate from mssql_connect() or mssql_select_db() as well since there is no way I can verify otherwise, unless I start debugging. And debugging is exactly what's

[PHP-DB] Which state and country?

Hi all, How can we know from which state and country a hit came? Regards, Lisa Elita -- 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] Executing several PHP scripts simultaneously??

How can we execute several PHP scripts simultaneously inside a single PHP script? For example, let's say master.php has 10 tasks in different PHP scripts: 1.php, 2.php, ..., 10.php. Each task is independent (the input of each task is not determined by other tasks) so we can do the tasks in any ord

RE: [PHP-DB] MySQL Error???

> -Original Message- > From: Brian Grayless [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 27, 2001 11:24 AM > To: PHP DB list (E-mail) > Subject: [PHP-DB] MySQL Error??? > > > Is anyone familiar with this MySQL error? > > "1062: Duplicate entry '127' for key 1" > I wrote a great bo

[PHP-DB] php_sybase_ct.dll and libct.dll

Hi! After enabling Sybase extensions, PHP complains about not being able to find the extension dll "php_sybase_ct.dll". Yet, paths and stuff are all correct and the file is exactly where PHP is looking for it. After restarting web server service PHP starts to complain about libct.dll as well, whi

[PHP-DB] Sybase extensions for MSSQL??

Greetings, Would Sybase extensions for php work for MSSQL7? They say mssql_xxx is an alias for sybase_xxx. (I desperately need to get smth. working) Karl. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTE

Re: [PHP-DB] delay script

http://www.php.net/sleep > hello! > > does anyone knows how to delay a display of a certain page ... for example, > if i will click on "logout" button, it will show a page which will say > "logging out" then after 5 seconds it will redirect to the login page. > > > thanks =) > > > -- > PHP Datab

Re: [PHP-DB] delay script

On Thu, Jun 28, 2001 at 11:09:47AM +0800, Jennifer Arcino Demeterio wrote : > hello! > > does anyone knows how to delay a display of a certain page ... for example, > if i will click on "logout" button, it will show a page which will say > "logging out" then after 5 seconds it will redirect to t

Re: [PHP-DB] delay script

Hi, You can do this without using a php script why don't you use http://www.foo.com/foo.html"> where "N" represents a discrete time interval in seconds. Dobromir Velev -Original Message- From: Jennifer Arcino Demeterio <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date:

Re: [PHP-DB] Modify Query, or sift through results?

Ah ha..now it looks like we're on to something. I had to modify it a bit, but it worked...for the most part. I had to make it rlike "North[;|$]". But here's the next problem...I have a region 'Midwest' and 'Upper Midwest'. When I do this search for Midwest, I get the 'Upper Midwest' results also.