don't you need it to be SELECT login, password...
lowercase first letter? - if you're comparing the columns user.login and
user.password.
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: 09 November 2001 01:34
To: MPropre
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB]
I'd also be interested in what people are charging as I'm thinking of
setting up as a contractor myself and it would be nice to have a 'ball park'
figure of what the going rate is ...
Pls mail replies to [EMAIL PROTECTED]
Ta,
Steve
Leo G. Divinagracia III [EMAIL PROTECTED] wrote in message
I have code at work that encodes and decodes escape chars when inserted into
mysql or displayed as html.
Can't remember the syntax exactly but I did use htmlentities and then
array_flip on the way out. There is an example in the php help file.
Found it. I love it when PHP can do stuff like this
Dan,
This sorts out your problem completely.
htmlentities() will encode the data as it is inserted into the database and
get_html_translation_table will help you translate it so it can be viewed in
the browser. Have a look at the manual page for the
get_html_translation_table function displayed
There is a solution posted on the original thread.
PHP already has functions to deal with this problem.
str_replace is a waste of time.
Steve
Natalie Leotta [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
I would recommend that you try something like str_replace and replace all
of
I have an array coming from a form that I need to insert into mySQL.
example: name[], phone[], address[]
Use serialize() on the variable before inserting into the table and then
unserialize() after retrieving the data from the table.
Read up on both of the above functions for more information.
As we say here in Dallas: there are two kinds of people...those who live
in Texas...and those who wish they did.
Full Metal Jacket? ;)
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.295 / Virus Database: 159 - Release Date:
As we say here in Dallas: there are two kinds of people...those who live
in Texas...and those who wish they did.
Texas?? Never heard of it! Is that somewhere north of Manchester? ;-)
Russ
On Fri, 9 Nov 2001 14:22:22 - matt stewart [EMAIL PROTECTED] wrote:
As we say here in Dallas:
yeah, something like that only two kinds of people come from texas as i
recall...
ah, friday afternoon humour.
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 09 November 2001 14:31
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] inserting array into mySQL
Was that
Well we're a little far afield from Manchester.
However, in a match between the Dallas Cowboys (American Football team) and
Manchester United (Funny Football team), the win goes to the Cowboys.
yee...haaa...
-Original Message-
From: Russ Michell [mailto:[EMAIL PROTECTED]]
Sent: Friday,
I could only aspire to that... GRIN
We better end this thread. We are WAY OFF-TOPIC
-Original Message-
From: matt stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 8:37 AM
To: 'Rick Emery'; [EMAIL PROTECTED]
Subject: RE: RE: [PHP-DB] inserting array into mySQL
is
I'd also be interested in what people are charging as I'm thinking of
setting up as a contractor myself and it would be nice to have a 'ball park'
figure of what the going rate is ...
Pls mail replies to [EMAIL PROTECTED]
Feel free to post your responses to the list. I'm curious about it too.
When I try to copy some files from my local PC to the server there appears
a message
Warning: Unable to create '/xxx.gif': Permission denied in /xxx.php3 on
line xx
Where should I search the problem. In the apache server, php or linux.
--
PHP Database Mailing List (http://www.php.net/)
To
think the most likely is there is not a temporary upload directory set in
PHP on your server?
I'd check the relevant PHP settings first, also check the final destination
folder has relevant write permissions.
-Original Message-
From: Ivo [mailto:[EMAIL PROTECTED]]
Sent: 09 November 2001
This is a problem in your server.
Not apache, but the OS itself...
Linux gives user access based on certain values...
php normally runs as the user nobody, so what you have to do is to make
sure
user nobody has the right to read/write in your temp folder (defined in
php.ini)
Or else...
many thanks,
this may sound totally dumb but where do you find your work ?
is it via word of mouth or do you advertise etc ?
Steve
Tim Foster [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'd also be interested in what people are charging as I'm thinking of
Hi ,
I had this problem too so...
Say it is your pics directory that you want to upload to, I use Leech FTP
for my uploads, right click on the pics directory goto Set Attributes and
set it to 777. This is not very good practice, but since I don't have the
sites live it does'nt matter too much
However, in a match between the Dallas Cowboys (American Football team) and
Manchester United (Funny Football team), the win goes to the Cowboys.
yee...haaa...
=an unwise comparison, British football/soccer involves continuous play for two halves
of 45 minutes each.
American footballers keep
Im trying to obtain a list of tables in a database.
To do this, ive come up with the following code.
$conn = odbc_connect(mydsn, , );
$tablelist = odbc_tables($conn);
while(odbc_fetch_row($tablelist)) {
$tbname = odbc_result($tablelist, 3);
}
Now the page just times out. I believe its
Something that might be useful would be a sort of guide or list of tips
and tricks to creating a quotation for a programming job. I wouldn't know
where to find something like that though. Maybe the business section of a
larger bookstore?
rita.
-Original Message-
From: Steve Brett
Dave,
1. Yes
2. Compile --with-oci, as per the manual, and set all the appropriate ORACLE
environment variables before doing so.
3. oci should be available from Oracle's site.
4. Yes, unless you want to use ODBC, and then you would install --with-iodbc
per the HOWTO's on www.iodbc.org.
5. again,
I'd also be interested in what people are charging as I'm thinking of
setting up as a contractor myself and it would be nice to have a 'ball
park' figure of what the going rate is ...
A lot depends on what you've done and the image your customer has of the
value of what you are doing.
Many
Hi,
I'm preforming a join between 2 Mysql tables in this
way:
table_name: ID,name,ID_city
table_city: ID,city
when I query this:
SELECT table_name.name,table_city.ID,table_city.city
FROM table_name,table_city WHERE
table_name.ID_city=table_city.ID
The result is a new table with this fields:
-Original Message-
From: Kodrik [mailto:[EMAIL PROTECTED]]
The problem is that you have to be able to differentiate yourself from those
fakes, and it can be difficult. They usually have flashy sites that move and
make sound linked some database capability with access (like to
Pardon, another question:
Is there a way to say to Mysql to automatically detect
a relation between 2 table and perform the join
operation when there's a SELECT query ?
I Hope this isn't a stupide question! But I've seen
that in the detested MS Access, there a simple way so
make a visual join
Hello,
I'm trying to parse an XML file stored on MySQL. I'm using this code:
?php
global $CFG, $ME;
$qid = db_query(
SELECT texto
FROM articulos
WHERE id = $id
);
$r = db_fetch_object($qid);
$file = $r-texto;
$map_array = array(
ARTICULO = ,
VOLANTA = h2,
TITULO = h1,
select
n.name, c.city, c.ID
from
table_name n, table_city c
where
c.ID = n.ID_city
No sweat.
-Lorenzo
-Original Message-
From: Carlo Loiudice
Sent: Fri 11/9/2001 5:01 PM
To: PHP DB
Cc:
Subject: [PHP-DB] JOIN
MySQL does not enforce foreign key relationships.
So while I believe you can still do a natural/automatic join, the
fieldnames and datatypes must match.
-Lorenzo
-Original Message-
From: Carlo Loiudice
Sent: Fri 11/9/2001 5:11 PM
To: PHP DB
Cc:
Subject: [PHP-DB]
I've never parsed XML with PHP, but it might help if you can show the
document that's breaking the parser, and also let us know if other
documents are working fine...
-Lorenzo
-Original Message-
From: Tomas Garcia Ferrari
Sent: Fri 11/9/2001 5:14 PM
Inside a function, I am reading data from MySQL. In case any of these calls
fail I follow them with something like:
or echo Can't make query to database!;
The problem is, I want to do more things than just this... and then I want to
return out of the function rather than continuing to
Inside a function, I am reading data from MySQL. In case any of these calls
fail I follow them with something like:
or echo Can't make query to database!;
The problem is, I want to do more things than just this... and then I want to
return out of the function rather than continuing
have a look at get_html_translation_table() in the php manual.
there is an example of conversion of all special chars so they can be
inserted into the database as text (i.e. £pound) and a cool way of
'decoding' them if you need to write them to a file. A Browser wil interpret
them correctly when
See:
http://www.php.net/manual/en/faq.com.php#AEN63770
A+
Alain
On Fri, Nov 09, 2001 at 05:12:09PM +, GRI wrote:
Hi there,
I was wondering if it is possible to call a function from my self
created DLL from my PHP script.
Thanks in advanced.
--
PHP Windows Mailing List
See:
http://www.php.net/manual/en/faq.com.php#AEN63770
A+
Alain
That FAQ isnt totally right. With the new w32api extension you can do so but
its still very experimental so Id advise you either to write your own little
extension to PHP to access your dll (shouldnt take you more than a couple
You can system()/exec()/passthru() and run rundll32 on the library,
can't you?
-Original Message-
From: James Moore [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 12:34 PM
To: Alain Samoun; GRI
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
35 matches
Mail list logo