Hi people,
I was approached by my boss today to construct a page to draw out the data
from a recent survey that was conducted via the web. The data is stored in a
mysql database by fieldname and the data that the user entered.
The problem lies in the way that he wants the page constructed.
The
Hi All
Does anyone know of tutorials I can use to learn how to properly use the
Metabase Database Class library?
I have read the tutorial that accompanies the library and the documentation
but I'm still uncertain in how to properly use it.
Neil Craig
QEDI (Pty) Ltd
--
PHP Database Mailing
I'm running an Apache 1.3.19 on a Windows NT server using PHP 4.05 and
Intersolv 3.11 ODBC.
I upgraded the NT server from SP5 to SP6. The ODBC connections became
3-5 times slower (a return of data went from 10 seconds to 50 seconds).
Some of my stuff now times out and crashes PHP - my timeout is
Brian,
It sounds like an issue between your Driver Manager (MDAC) which was
probably upgraded with the SP6 and the Intersolv driver.
You should follow up with Merant to see if there are any issues with their
driver and SP6, or you can examine an ODBC Trace (Tracing tab in the ODBC
Administrator)
Hello,
Neil Craig wrote:
Hi All
Does anyone know of tutorials I can use to learn how to properly use the
Metabase Database Class library?
I have read the tutorial that accompanies the library and the documentation
but I'm still uncertain in how to properly use it.
There is a tutorial
Yeah, it really worked, only the char I had to put it at the beginning
of the string too and not only before the second and every consecutive
name-value pair. So the right string I had to output was:
var1=value1var2=value2var3=value3
Thank you for your help!
Atanas Vassilev
[EMAIL PROTECTED]
Hi list members!
I have a doubt regarding how can I INSERT and SELECT an IMAGE from a MYSQL
database. I'm using , in the DB, the BLOB field, so, I will be able to
receive binary data. Thnaks for any help!
Best Regards,
Felipe Moreno
--
PHP Database Mailing List (http://www.php.net/)
To
Hi,
The following statement will not work:
$sql = select * from sometable t1, sometable t2 where t1.field1 =
t2.field2;
do you get an error? It should work.
Johannes
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
How can i import data from an access database to a mysql db.
Thanks in advance,
Gabriel.
I don't understand xcount().
Instead of xcount(), why not use strlen()?
Say we have 7100 chars
If you step through, first pass
$i = 0
$chunk_count = 2
$start = 0
$final = 3500
$text[] is chars 0-3499
second pass
$i = 1 // from $i++
$chunk_count = 2
$start = 3501 // problem is here - note
Export as a comma-delimited file, explode() the file one line
at a time along commas, and use insert via normal methods.
Not sure if MySQL has a parser for comma-delim (probably
does) but this way you have more control over how it goes in.
-Szii
- Original Message -
From: Gabriel
Oh, btw, if you're splitting along chars, make sure you don't munge your
data TOO much.
Breaking mid-word can be annoying, esp if it's to be displayed as a page.
I have a splitter I wrote that'll either break along word boundries, or
along sentance
boundries.
Haven't pounded it yet, but it
Steve,
I'm going to assume that you meant I don't think the standard PHP file
functions support HTTPS, because they definitely DO support HTTP. Check
http://www.php.net/file if you don't believe me. :)
As for whether or not PHP support HTTPS, I'm not sure ... but I'd be curious
to know the
Used Prompt in Win2k. Moved to the apache/mysql/bin directory
and typed mysql.
Jeff Oien
You said you could connect through the command-line. How did you do that?
Jonathan
Here is sample code:
?
$connection = @mysql_connect(localhost, jeff, *)
or die(Couldn't connect.);
if
Hi,
How can I detect client's OS/platform with PHP? (Win, Mac, etc.)
with PHP_OS. $os = PHP_OS;
See Chapter 8 - Constants of the manual.
Johannes
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
Yes it is running. I don't need to use a password when running from the
command line but I am when connecting through PHP. This is exactly
how I did it on my Win98 machine but it isn't working with W2k.
Jeff Oien
Well the mysql tool doesn't need any authentication usually when you first
set it
When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
peter;
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query: DESC tbl_name_1; he can see all the
structure of that table.
From 'Shawn Reed':
I'm going to assume that you meant I don't think the standard PHP file
functions support HTTPS, because they definitely DO support HTTP. Check
http://www.php.net/file if you don't believe me. :)
I meant HTTPS.
--
Tired of Earthlink? Get JustTheNet!
Nationwide Dialup,
It's hard to comprehend how this is a MySQL problem as my SQL commands work
perfectly when entered at the command line. This fact is a pretty strong
pointer to PHP being the culprit. Why empirical test would suggest otherwise?
CC Zona wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED]
My specific return is
Couldnt execute query :
select dtype, dloc, iprice from descriptions d,
items i where d.iid = i.iid ;
If I reduce this to
select dtype, dloc, iprice from descriptions d,
items where descriptions.iid = items.iid;
I'm not sure but couldn't it really be that this is
due to the MySQL version? PHP is just passing
a string which is then executed by MySQL. I think
I recall having no problems with aliases. I don't quite
remember which version it was but I think it was 3.23.*.
Now I am using a shareware version
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (cameron walker) wrote:
It's hard to comprehend how this is a MySQL problem as my SQL commands work
perfectly when entered at the command line. This fact is a pretty strong
pointer to PHP being the culprit. Why empirical test would suggest
Newbie question
I am trying to get a linux (redhat 7.0) box running apache (1.3.19) and php
(4.0.5) to communicate with Microsoft Sql Server version 7 or 2000. I am
trying to use the iodbc driver manager with the OpenRDA odbc driver.
Following all the instructions i have managed to install and
you have to specify what table you are selecting each of the fields from
select dtype, dloc, iprice from descriptions d,
items i where d.iid = i.iid ;
should be
select d.dtype, d.dloc, i.iprice from descriptions d, items i where d.iid
= i.iid ;
At 03:49 PM
Dammit, that code looks right.
So
1. Have you tried it at the mysql console? What results?
2. How accurately does day match $day? Have you tried = instead of LIKE?
Maybe it's doing it twice?
3. Is day distinct? How do you know you have only one?
When you tested with 2, assuming i had a
Sorry, last message was a little vague.
Your SQL will fail because of the ',' after the SET clause.
Therefore affected_rows shows 0, and inserts a new row.
Then when you match with the LIKE clause, it's going to match
multiple times.
Miles, you were SO close with #2. =)
-Szii
- Original
WOW - sharp eyes!!
Miles
At 04:02 PM 5/16/01 -0700, Szii wrote:
Remove the comma after the SET clause?
-Szii
- Original Message -
From: Miles Thompson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 3:50 PM
Subject: Re: [PHP-DB] mySQL Addition Problem
Here is sample code:
?
$connection = @mysql_connect(localhost, jeff, *)
or die(Couldn't connect.);
if ($connection) {
$msg = success!;
}
?
This is on my machine only used by me. I also tried connecting to
IP address and 127.0.0.1 and it still won't work. Thanks.
Jeff Oien
Are
Ok This one has me stumped.
I'm working on a survey for an author. There is already a total of 35
questions and their corresponding columns in the main table. She has three
other questions that have identical checkboxes, 30 each. I want to put
them in the second table and just make reference to
I'm just winging this off the top of my head.
If you are absolutely sure that the order of the checkboxes will NOT
CHANGE, and that is a very risky assumption. And assuming that you have an
array to hold the values for the checked box, why not just store the value
of the index for each
Hi All,
I'm building a standard shopping cart style e-commerce site using PHP
and MySQL running on Apache.
I store my users' cart info in this table:
++--+--+-+-+---+
|
| Field | Type | Null | Key | Default | Extra |
+
Yeah. I'm gonna have to go with this one. Thanks. But one other question:
what should the variable be echoing.
.input type=checkbox name=cb_name['value']this here option/input
if ( $HTTP_POST_VARS ) {
echo $cb_name['value'];
}
It's not coming up with anything. (Yeah, the norm
Here is sample code:
?
$connection = @mysql_connect(localhost, jeff, *)
or die(Couldn't connect.);
if ($connection) {
$msg = success!;
}
?
This is on my machine only used by me. I also tried connecting to
IP address and 127.0.0.1 and it still won't work. Thanks.
Jeff
Hello php-db,
we know that every password in mysql was encryption using PASSWORD
function. i have case that make me to send user password bymail.
how can i get this user password ?
--
Best regards, TIA
andrie mailto:[EMAIL PROTECTED]
--
PHP Database Mailing
on 5/16/01 10:44 PM, andrie at [EMAIL PROTECTED] wrote:
we know that every password in mysql was encryption using PASSWORD
function. i have case that make me to send user password bymail.
how can i get this user password ?
You can't. It's a one way encryption. You'll need to log into MySQL
35 matches
Mail list logo