> 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 con
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 ex
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
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] Auto
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 op
Hello,
I'm trying to parse an XML file stored on MySQL. I'm using this code:
> 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" =>
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 betw
> -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 ca
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:
r
> >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.
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]
S
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,
These are pretty basic questions, but I would appreciate help:
I need to access Oracle (already running on a separate server) via PHP4 from
a FreeBSD Server.
1) Can this be done?
(if so...)
2) Where do I find instructions?
3) Where do I get php_oci8
4) Do I HAVE to install code from Oracle (the
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 [mail
> 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 coup
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 Lis
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 Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
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 believ
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. £>£) and a cool way of
'decoding' them if you need to write them to a file. A Browser wil interpret
them correctly when the
> 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 ke
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 yet
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 thinkin
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...
>
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 1
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
>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 to
I could only aspire to that...
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 that you
is that you John Wayne?
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 09 November 2001 14:33
To: [EMAIL PROTECTED]
Subject: RE: RE: [PHP-DB] inserting array into mySQL
Well we're a little far afield from Manchester.
However, in a match between the Dallas Cowboys
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 li
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, N
Hi,
I faced unexpected problems while trying to execute IBM DB2 stored
procedures from PHP4. Procedures include only in-type parameters and they do
work fine when executed from command line. When adding {} around the
callable statement, the procedure seemed to work but I got an error message:
W
Was that line in the movie? If so, wisely said.
-Original Message-
From: matt stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 8:22 AM
To: 'Rick Emery'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] inserting array into mySQL
>>As we say here in Dallas: there are two kinds
> >>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 Dall
>>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: 0
> 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
mySQL does not directly support arrays. I'm going to assume that there is a
relationship between entries in each array to entries in the other arrays.
Therefore, create mysql records which reflect that relationship. Something
like:
CREATE TABLE people (
name varchar(50) NOT NULL default "",
pho
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 al
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 b
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
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
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] No
41 matches
Mail list logo
