Yep. Been using Mac OS X (10.1 - 10.2.3) with mySQL no problems. I
built it from source first time, but now I just use Mac OS X packages
from Mark Liyanage. You can find them here. Also he has a good
pre-compiled PHP4 you can download and use.
http://www.entropy.ch/software/MacOSx/mysql/
Adam
on 1/6/03 8:24 PM, David Chamberlin at [EMAIL PROTECTED] appended the
following bits to my mbox:
Is there any way to set the time format so that any time values in my
SELECT call are in a speicified format (e.g., HH:MM instead of HH:MM:SS).
Basically I've got a table of a variety of
How can i find out the day of the week in one date??
like = 07/01/2002 the day of the week is 3 thurday
like = 18/01/2002 the day of the week is 6 saturday
is there a way to do that?
Equipe Pratic
You can do it very nicely with MySQL:
$query = SELECT WEEKDAY( '{$mydate}' ) ;
Provided your date is correctly formatted ( -mm-dd )
Ignatius
- Original Message -
From: Rodrigo Corrêa [EMAIL PROTECTED]
To: PHP1 [EMAIL PROTECTED]
Sent:
with mysql its:
WEEKDAY(date)
Returns the weekday index for date (0 = Monday, 1 = Tuesday, ... 6 =
Sunday):
mysql SELECT WEEKDAY('1998-02-03 22:23:00');
- 1
mysql SELECT WEEKDAY('1997-11-05');
- 2
http://www.mysql.com/doc/en/Date_and_time_functions.html
in php its:
string date (
If you use sessions, you can pass the variables without having to
wory about interim pages. Another option (I don't know if it will
actually work) is to put the variables in the the URL of the location
redirect. Something like:
$loc=http://www.yourdomain.com/nextpage?var1=$var1var2=$var2;;
Paul Burney wrote:
Why not add the TIME_FORMAT calls to the original query rather than
performing all the extra queries? Is your first select something like the
following?
That's what I'd like to do, but not sure how to do that in this context.
SELECT
Hi,
I have been developing a Java Swing UI for MySQL and I am to a point where I
need to have some PHP developers try it out. This is NOT an interface that
manages your databases, tables and columns. What it does is allows you to
connect to a database on your MySQL server, select a table and get
My head is sore from banging my head on my desk, so I will now ask
the gurus...
I am trying to get a canned Calendar application working, and I am
running into problems. The application is phpCommunityCalendar by
AppIdeas.com. The calendar is currently semi-functional, but for
Heh. I used this app in one of my sites, (www.9250x.com) it has some
nice features, but whoever programmed it didn't intend for anyone else
to make changes, that's for sure.
The '%%' in the first snippet is some SQL code, '%' is a wildcard in
SQL, so the gist of that section is If
Hi to all,
I want to be able to load PDFs into mysql DB, but I'm not very familiar with
the blob data type?
Can someone point me on the right direction how to do this?
Thanks in advance
Nato
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Keep in mind that BLOB is up to 64k thus you may need larger BLOB.
Look at the mysql's documenations for more information
http://www.mysql.com/doc/en/
Andrey
P.S.
Have a nice night.
- Original Message -
From: Natividad Castro [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday,
Why not upload the PDF file to a files directory and just put the path and
filename in your database.
Natividad Castro [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi to all,
I want to be able to load PDFs into mysql DB, but I'm not very familiar
with
the
On Tue, 2003-01-07 at 15:52, [EMAIL PROTECTED] wrote:
I agree with this method. i have not yet seen an advantage of storing
blobs in a database. Is there one? i'm sure those on this list would have
an opinion if there was one. personally, i like storing all this stuff on
the file system.
I agree with this method. i have not yet seen an advantage of storing
blobs in a database. Is there one? i'm sure those on this list would have
an opinion if there was one. personally, i like storing all this stuff on
the file system.
Jeff
Hi guys,
Would someone mind pointing me to a function, or some code, or give me a
seudo-code start for the following:
I'm using the mail() function.
If someone submits the form with text in the multi-line textarea, any
carrige returns (ie, by pressing ENTER) are taken out the body is sent
as a
Hello,
On 01/07/2003 10:11 PM, Gavin Amm wrote:
Would someone mind pointing me to a function, or some code, or give me a
seudo-code start for the following:
I'm using the mail() function.
If someone submits the form with text in the multi-line textarea, any
carrige returns (ie, by pressing
using the same extensions path as the previous version I get:
Content-type: text/html X-Powered-By: PHP/4.3.0 PHP Warning: Unknown(): Unable to load
dynamic library 'C:\Program Files\PHP\extensions\php_ldap.dll' - The specified module
could not be found. in Unknown on line 0
when using PHP
Thanks for your reply.
Word wrap seems to be ok.
What does seem to be a problem is the line breaks...
For example, they might type in the following (between the dashed
lines):
--
Hi,
Please send me some info.
Thanks,
Gav
--
When
hi,
i just got my windows/php/db3 env compiled. But
when I run a simple test script, I get this error:
C:\TEMPphp -f simple.php
Notice: dba_open()
[http://www.php.net/function.dba-open]: read:
0x12f8f4, 256:
Permission denied in C:\TEMP\simple.php on line 3
Notice: dba_open()
I agree with Dave. I wrote an application to allow a client to upload/manage
images and categorise them into diff. parts of their website.
Images were stored as normal image files after upload and a pointer made to
them from the appropriate database record (which had additional image info
e.g.
More info on this:
I tried to create a root directory c:\extensions and put the module in there on the
off chance that the bug in 4.3 comes from the space in the directory path. It didn't
help. Nothing seemed to work. If I comment out the line to load the module everything
works fine (except
Hello,
On 01/07/2003 10:41 PM, Gavin Amm wrote:
Thanks for your reply.
Word wrap seems to be ok.
What does seem to be a problem is the line breaks...
For example, they might type in the following (between the dashed
lines):
--
Hi,
Please send me some info.
on 1/7/03 7:41 PM, Gavin Amm at [EMAIL PROTECTED] appended the following bits
to my mbox:
For example, they might type in the following (between the dashed
lines):
--
Hi,
Please send me some info.
Thanks,
Gav
--
When I receive
Would someone mind pointing me to a function, or some code, or give me
a
seudo-code start for the following:
I'm using the mail() function.
If someone submits the form with text in the multi-line textarea, any
carrige returns (ie, by pressing ENTER) are taken out the body is
sent
as a
I have a database: web_feedback, and it has 5 columns:
Firstname varchar(40) not null
Lastname varchar(40) not null
Email varchar(40) PRIMARY KEY not null
ServList varchar(40) not null
Timestamp not null
I run a query in a PHP script to retrieve the email address the line of code
looks like
I have a database: web_feedback, and it has 5 columns:
Firstname varchar(40) not null
Lastname varchar(40) not null
Email varchar(40) PRIMARY KEY not null
ServList varchar(40) not null
Timestamp not null
I run a query in a PHP script to retrieve the email address the line
of
code
I have a database: web_feedback, and it has 5 columns:
Firstname varchar(40) not null
Lastname varchar(40) not null
Email varchar(40) PRIMARY KEY not null
ServList varchar(40) not null
Timestamp not null
I run a query in a PHP script to retrieve the email address the line of code
looks like
Sessions are better. If you want to use the header to pass the
variable:
header(Location:5-14_select_area.php?department=$department); (use an
ampersand for adding additional variables as mentioned by Mark.
You should call a clean function from an include file (add the document
root directory
[snip]
In a receipt to the customer you might want to show them their date of
order and other information using:
$query=SELECT DATE_FORMAT(o.date, '%m/%d/%Y'),
it.cost
FROM order o, item it
WHERE cust_id = $custId;
To
I want to be able to load PDFs into mysql DB, but I'm not very familiar
with
the blob data type?
Can someone point me on the right direction how to do this?
Use fopen() in binary mode and fread() to read the file into a string, then
insert it into the
database as you would any other variable
31 matches
Mail list logo
