[PHP-DB] Re: [PHP] Creating a pdf document

On Thursday 24 January 2002 15:52, Mihail Bota wrote: Hello, I was wondering if I could save the result of a query in a pdf document. I looked for any functions that might help, but I got confused because I could not see how/where exactly to insert the necessary .dll's. First read the

[PHP-DB] Help -- Oracle

Help, i'm trying to connect to a remote oracle database from win98/apache/php4 and win2k/iis/php4 but it always gives me tns error. Other apps however, works fine with the tns configuration. the php oracle module was loaded successfully on both platforms. I've tried all sorts of possibilities.

RE: [PHP-DB] Help -- Oracle

Help, i'm trying to connect to a remote oracle database from win98/apache/php4 and win2k/iis/php4 but it always gives me tns error. Other apps however, works fine with the tns configuration. the php oracle module was loaded successfully on both platforms. I've tried all sorts of

[PHP-DB] Problem with MySQL4.0.1 speed, cpu- and memory-usage

Hello, in order to be able to use the replication features of MySQL we recently gave version 4.0.1alpha a try, since these features are reportedly more reliable in this version - although it is still alpha. Unfortunately the disadvantages - at least on our machines - don't seem to make up for

[PHP-DB] Pictures in MySQL database

Hello, I would like to create database with many pictures. I have problem with inserting pictures to table in MySQL. I created table where one of the name of column is image. The type of this column is LONGBLOB. How can I insert picture into this column? I tried insert a file (e.g.

Re: [PHP-DB] Pictures in MySQL database

Re the PLS. Nope, replies to private email are contrary to spirit of the list. Storing inages in a database is not a good practice. Fetches are slow and the database becomes incredibly bloated. Most people store the images on disk and a reference to their location in the database and have

RE: [PHP-DB] Pictures in MySQL database

Agreed, i think you'll find aan easy way of doing this is to name each image after the primary key to your table (ie 1.jpg, 2.jpg, 3.jpg etc if the primary key is an autonumber. and store them all in a certain file, then when you fetch the record from the table, you can run a simple check to see

[PHP-DB] Re: Help -- Oracle

Have you tried to replace the tnsname with its exact definition ? not the best thing to do, but it could be a workaround. Example : something like : $oracletns = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host =

[PHP-DB] Php4 and Interbase 6 on linux

Hi there all! I've got a slight problem. I developed a web site using php4, apache 1.3 and Interbase 6 on a Win2000 platform. Now the web page needs to be moved to a linux server. The server is running Suse Linux 7.2 with apache and php4 already installed and is working fine. But now how do

[PHP-DB] multi-dimensional array

Hi, I am trying to load a multi-dimensional array to my mysql database and am having difficulty reading the array. I created the array in a script, and sent it to another script through a form. One of the variables that gets passed is $home_team[][]. with the outer array being the week #, and

Re: [PHP-DB] Creating a pdf document

Thanks a lot guys! This really helps a lot. MySql is not installed on my machine, so it would take a while to install all the necessary libraries. I'll stick with the material given by Daniel, for the moment. Mihai -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

[PHP-DB] RE: Creating a pdf document

http://www.php.net/pdf You'll need Thomas Mertz' PDFlib, which is free for personal/not-for-profit use, but requires a license fee for commercial use: http://www.pdflib.com/pdflib/index.html -Andy -Original Message- From: Mihail Bota [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

RE: [PHP-DB] # of Records in Table

You are incorrect regarding my appreciation of the help I receive from the list. I very much value the help received from everyone who is a contributor to the list. This is one of the reasons (of many) I chose to develop with PHP/MySQL. At this point in time I mainly receive help, however, when

RE: [PHP-DB] How to find out the number of rows in a table?

SELECT count(*) AS ctr FROM mytable; -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 10:36 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to find out the number of rows in a table? Hi there, I am trying to find out the number of rows in a

[PHP-DB] MySQL Persistent-Links in SafeMode PHP4.1.1 on Linux

Hi Group, im encountering a problem with safemode and pers. links: Running unsafe mode everything is fine, when i turn on safemode the call to mysql-db with mysql_pconnect fails with cant connect to mysql thru socket /tmp/mysql.sock. This will only hasppend if i use persistent connect - normal

RE: [PHP-DB] How to find out the number of rows in a table?

Try the following: $sql = select count(*) as c from your_table ; $result = mysql_query(your_db, $sql, your_connection_identifier) ; $row_count = mysql_result($result, 0, 'c') ; Now $row_count contains the number of rows in your table named your_table HTH --Sam Masiello Andy [EMAIL

[PHP-DB] Re: Count(*)

Thank you everyone. The "COUNT(*) AS c" worked great. ---Original Message--- From: Kai Voigt Date: Friday, 25 January 2002 11:11:06 a. To: Barry Rumsey Cc: [EMAIL PROTECTED] Subject: Re: Count(*)

Re: [PHP-DB] Php4 and Interbase 6 on linux

Hi, You need to recompile PHP with support for Interbase. I would recommend reading the instructions on linux PHP installations on the PHP website. I imagine the conifgure option is something like --with-interbase=path_to_interbase but definately don't quote me on that. Cheers, db Paulu

[PHP-DB] dynamic sql

Is it possible to do a sort of dynamic sql. For instance, if I have a form with a bunch of field/data variables and I send them to a php processor, can I just create a loop to have it update all the fields without having to specify each field. In scratch code, I guess I'm looking for something

[PHP-DB] problem with LOAD DATA INFILE for date format

Hi, I have a sample data like below in text file (policy.txt). PolicyNo,DateOfBirth,PaidToDate 0003573607, 9/25/1973, 8/27/2001 708802,11/26/1959, 5/25/1998 0002776507, 3/19/1973,11/18/1999 0002776703, 3/13/1969,11/18/1999 Policy table structure: +---+-+ | Field

Re: [PHP-DB] dynamic sql

Have you tried it? I've done this sort of thing before, and it works just fine. By the time the query string is executed, the variables have been interpreted. So, if $colName = id, and $id = 12, then your query variable looks something like select * from myTable where $colName = $id. By

[PHP-DB] dynamic sql

Rich, thanks. I got the dynamic sql to work (i had a syntax problem), now my problem is what's the most efficient way to loop it through all the form fields that are passed to the processor? This is my current sql statement which handles 1 field: $sql_update = UPDATE md_users SET .$formName. =

Re: [PHP-DB] problem with LOAD DATA INFILE for date format

There may be a better way, but in migrating from Filemaker to MySQL, I encountered similar problems. My solution was to pass the data through Excel and use that to convert the dates into the required format (CTRL-1, Custom, -mm-dd). Of course, you ned to watch out for those nasty ' ' ' that