PHP
http://www.php.net/manual/en/ref.image.php
ImageMagick
http://www.imagemagick.org/www/identify.html
PEAR: Imagick
http://pear.php.net/package-info.php?package=imagick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ive heard that before, and its in the mysql manual, to have something like
"WHERE table1.id = table2.id"
But does make any sense to me.
What Im doing is providing a search form for customers that allows them to
search each individual table for content or all tables. all tables have a
common field,
Unfortunately it doesn't really work... It depends on what ODBC they
happen to be running ->
http://www.phpbuilder.com/mail/php-db/2001071/0395.php
Thierry B. wrote:
Hi,
quoted from 'function.odbc-connect.php'.Perhaps it might helps:
--
cs at coolspot dot d
Hi,
quoted from 'function.odbc-connect.php'.Perhaps it might helps:
--
cs at coolspot dot de
10-Jul-2001 08:01
We've tried hard to connect from php to our IBM DB2 RS/6000 Server. It
worked after we compiled with --ibm-db2= option, but it was unbelievable
slow.
Hello,
On 08/20/2003 10:06 PM, Daevid Vincent wrote:
The pages are very mySQL intensive. No classes used. Many "includes" though.
That explains it. No PHP cache will make your database execute the
queries faster. Your scripts will be most of the time waiting for the
database to respond.
What yo
The pages are very mySQL intensive. No classes used. Many "includes" though.
> -Original Message-
> From: Manuel Lemos [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 5:44 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: MMCache Benchmarks don't show much improvement?
>
Hello,
On 08/20/2003 09:10 PM, Daevid Vincent wrote:
Hello, I installed MMCache on one of our boxes here and did a few timing
tests. I have to say I'm very unimpressed given the hype and the benchmarks
on their servers. Am I missing something? (and yes, phpinfo() shows the
module is loaded). I was
You could use sudo and add 'apache' as a user who can run 'mount'...
Add this to /etc/sudoers:
apache ALL=NOPASSWD: /bin/mount
Daevid Vincent
http://daevid.com
> -Original Message-
> From: pete M [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 15, 2003 4:59 AM
> To:
Hello, I installed MMCache on one of our boxes here and did a few timing
tests. I have to say I'm very unimpressed given the hype and the benchmarks
on their servers. Am I missing something? (and yes, phpinfo() shows the
module is loaded). I was the only person hitting the pages on this test box.
F
Hi there everyone,
I am storing images in the filesystem and in a MySQL DB, my question is, I know when
you upload the images you can do the image width, height etc .. from the image, is
it possible to also do a pixel count and image color depth?
Any help would be REALLY appreciated :-)
Th
I store alot in databases.. when you deal with filesystem there can be
issues with multiple webservers (need replication using something like
rsync, etc).. I've used the db/filesystem link method before aswell but
typically go with database nowdays..
You do have to query each time to get image
Hi there,
Why not do both? Store the images themselves in a dir, but reference them
from a table, so that way you can control them pretty much totally via PHP
and MySQL. You could them write a system to create thumbnails from selected
items in the database or delete certain images etc . easi
Hi,
I have to manage a large amount of images uploaded by users on my site.
Using php/mysql I don't know if I should store the images in a directory
within the server or in a dedicated table.
What is the most suited method?
Thanks, best regards.
--
PHP Database Mailing List (http://www.php.
Hehe, ok, that was bad there for a second :)
Ben
-Original Message-
From: Brian Dailey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:24 PM
To: Ben Lake; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] SELECT FROM 2 or more tables
No, he meant rarely want to join entire tables wi
No, he meant rarely want to join entire tables without a cross referencing ID column.
That's definitely something you wouldn't want to do very often. It's impractical and
extremely inefficient.
Ben Lake wrote:
Rarely want to do joins? That's a new one.
Ben
-Original Message-
From: Bre
Rarely want to do joins? That's a new one.
Ben
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:04 PM
To: John Ryan
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] SELECT FROM 2 or more tables
A join merges every record in one table with e
A join merges every record in one table with every record in another
table, which is something you rarely want to do. So you want to set a
filter on the merged records, which can be anything, but is usually a
match between a field in one table and a field in another table.
That's a join in two
John,
It sounds like you need to read basic documentation on combining SQL queries.
Basically, you need to have a column that is common across both tables.
Eg., in TABLE1 have a column named TABLE1ID. Have the same ID cross referenced in TABLE2.
The ID would be sequenced in some way (auto_incre
select t1.name,t2.salary from personal t1,sal t2
where t1.id=t2.id;
- Original Message -
From: "John Ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 4:41 PM
Subject: [PHP-DB] SELECT FROM 2 or more tables
> Is it easy?? Is it possible?? Should I just ru
Is it easy?? Is it possible?? Should I just run 2 different queries and
output their results in the PHP script and make it look like it's all from
the same table
I cant grasp JOIN for the life of me
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/un
could any body hlep me in this.
how to run a shell script with suexec in php.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I have a script that is going into semi-production and during this
process a new problem was uncovered. I have the table a couple of table
fields setup as "Not NULL" with a "Default" value. The problem is that if
the user fails to select anything I get garbage in one of the fields and
no
Hi,
In a small part of my database I have two tables as follows:
# -- MySQL dump --
#
# Table structure for table 'WMS_Data'
#
CREATE TABLE WMS_Data (
Data_ID int(11) DEFAULT '' NOT NULL auto_increment,
Booking_ID int(11) DEFAULT '0' NOT NULL ,
Data_Field_1 varchar(100) ,
Data_Fi
Hello,
On 08/20/2003 03:23 PM, John Stoffel wrote:
I've been working on a database with a web interface for the past few
years in my spare time, and as you can guess, I haven't had much time
lately, and they people I'm doing this for would like to get it
wrapped up if possible.
You may want to try
Hi All,
I've been working on a database with a web interface for the past few
years in my spare time, and as you can guess, I haven't had much time
lately, and they people I'm doing this for would like to get it
wrapped up if possible.
I'm looking for someone to help me understand/write PHP cod
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 1:24 PM
Subject: [PHP-DB] Host check?
> http://www.beamhost.co.uk/hosting.html
>
> I'm moving hosts with our site at work...
> I found these guys and am very impressed.
> Has anyone ha
See the attached file for details
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
It tells PHP which way to format various locale specific functions. (date
stuff, money stuff, etc..)
-Micah
On Wednesday 20 August 2003 2:23 am, Lisi wrote:
> I saw it, at first I didn't think it would work but it's great - just what
> I need. I guess I was just surprised that there isn't an ea
I've solved the immediate problem by doing another temp query to make the
big table smaller - first doing the WHERE clause and the CONCAT to cut down
the work on the second temp query.
Thanks for all the suggestions.
However, while setting PHP/MySQL/Apache up on my computer to try solve this
I've
First FreeTDS should have built support for TDS protocol version 8.0.
The tds protocol version should also be set to 8.0 in interface file.
Details about this is included with the FreeTDS source distribution.
-- bob
On Mon, 18 Aug 2003, vish.kohli wrote:
> Thanks for your response.
> My script i
I would advise making your "search.php" a function. This offers a lot
of other flexibility.
On your searchform.php page just have an if() function to determine if
any search parameters were passed. If there are parameters, perform the
search. If there are results, display them, otherwise displa
http://www.beamhost.co.uk/hosting.html
I'm moving hosts with our site at work...
I found these guys and am very impressed.
Has anyone had any dealings with them? Know if they are any good?
Tris...
*
The information contained in
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> OK, I'll apologize in advance if this is a little off topic, but I think
> it'll be close enough.
>
> I have a form (searchform.php) that collects data for a search (e.g.,
> firstname, lastname). That form submits to a separate PHP scrip
if you're looking for a little more control over your documents, i'd try
this class. Its based on the WriteExcel Perl Module. Perl class docs can
be found
here--->http://search.cpan.org/author/JMCNAMARA/Spreadsheet-WriteExcel-0.41/WriteExcel.pm.
I've found _very_ few things for my needs that t
you can also send the appropraite headers to output directly to excel from the
browser, i.e something like this:-
this needs to be at the very start of the page and before any output to the browser,
also in this case you'll need to send FORMAT=XLS in the GET array but you can of
course take t
have you tried saving the data as a set of comma separated values (CSV
file)?
Microsoft Excel can open/import these files.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 4:58 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Savi
I've just done a search on goolge for this, and found several products
that do it, but I'm convinced there's gotta be an open source option?
Anyone able to point me in the right direction with this?
*
The information contained i
I saw it, at first I didn't think it would work but it's great - just what
I need. I guess I was just surprised that there isn't an easier way to do
this in PHP by switching from the default. I also like to write my own code
rather than use someone else's, since it's the best way to learn, but
hi,
i try
$serdb="LOCALMACHINE"; #the name of the SQL Server
$dbdb="dbname"; #the name of the database
$userdb="userdb"; #a valid username
$passdb="passdb"; #a password for the username
# one line
$con=odbc_connect("Driver={SQL
Server};Server=".$serdb.";Database=".$dbdb,$userdb,$passdb)or die("
I upgraded my server to RedHat 9 and the problem was solved.
Thanks
Emery
- Original Message -
From: "Micah Stevens" <[EMAIL PROTECTED]>
To: "PHP-DB List" <[EMAIL PROTECTED]>
Sent: Tuesday, August 19, 2003 22:32
Subject: Re: [PHP-DB] Queries probably timing out
> IF it's a linux server a
I have had 40+ virused emails to the address I use for this list. Possible
they came from another source but this is the most likely.
Curious - I've not seen any, so it must be someone
harvesting rather than using the list? Lets see if my
posting brings some actions ;)
Please check your virus sc
41 matches
Mail list logo
