[PHP-DB] Set Cookies
Hi I'm trying to use the following simple script to set cookies but get the following error message cannot add header information - headers are already sent by(output started at c:\program files\php home edition 2\www\listing19.1.php:3) in c:\program files\php home edition 2\www\listing19.1.php on line 4 3 ?php 4 setcookie( vegetable, artichoke, time()+3600, /, $SERVER_NAME, 0 ); 5 ? 6 html 7 head 8 titleListing 19.1/title 9 /head 10 body 11 ?php 12 if ( isset($vegetable ) ) 13 print phello again your chosen veg is $vegetable/p; 14 15 else print phello your 1st visit ?/p; 16 17 ? 18 19 /body 20 /html Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. Furthermore, the content of this e-mail is the personal view of the sender and does not represent the advice, views or opinion of our company. Accordingly, our company disclaim all responsibility and accept no liability (including in negligence) for the consequences of any person acting, or refraining from acting, on such information prior to the receipt by those persons of subsequent written confirmation. In particular (but not by way of limitation) our company disclaims all responsibility and accepts no liability for any e-mails which are defamatory, offensive, racist or in any other way are in breach of any third party's rights, including breach of confidence, privacy or other rights. If you have received this e-mail message in error, please notify me immediately by telephone. Please also destroy and delete the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message is strictly prohibited. If you have received this E-mail in error, or suspect that the message may have been intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245 468555. ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] file upload and php (Not a begginer question!)
Hi, everyone know how to upload files from the browser to your web server using multipart-form method with move_downloaded_file() php function. But... It's a slow method for multiple files huge files transfert. I'm currently working on a big photo album tool, and I want to provide user the ability to upload a lot of jpeg files in one time... The big problem with form is it's too slow... Does anyone know how to by-pass this ( with java or other tools )? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MIME encoding and simplified chinese....help!
Hi, I had the same problem with traditional Chinese Big5. I tried two different php classes, the subject line still didn't change. I have not tried mimemessage class. This is what I did to make it work. I first convert the subject in Chinese to base64 encoding. Then I assigned =?big5?B?put-base64-encoding-here?= to subject. You must have =?big5?B??= and put your base64 encoded Chinese between the 3rd and 4th question marks. Make sure you change big5 to the simplified Chinese charset. Regards, Ellen --- Manuel Lemos [EMAIL PROTECTED] wrote: Hello, On 10/14/2002 09:34 PM, Nigel Dunn wrote: I have a PHP MIME class that works supurblymy big question is... Is there a way to convert the subject line to simplified chinese. The body of the email is fine but I havent been able to get the subject line to display chinese. I don't know what class are you using, but if it is this class, all you need to do is to specify the chinese encoding that you want to use in the optional charset argument of the SetHeader function. I meant this class: http://www.phpclasses.org/mimemessage -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: file upload and php (Not a begginer question!)
Hi! If you search for 4images on hotscripts.com (php section ofcourse), you will find an image gallerey with the function you ask for, multiple image uploads, there you can upload a total of 10 images at the same time :) But I havent had the time to look at the code yet, just know it works :) Good Luck :) Jøran Sørbø :: Norway Baroiller Pierre-Emmanuel [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, everyone know how to upload files from the browser to your web server using multipart-form method with move_downloaded_file() php function. But... It's a slow method for multiple files huge files transfert. I'm currently working on a big photo album tool, and I want to provide user the ability to upload a lot of jpeg files in one time... The big problem with form is it's too slow... Does anyone know how to by-pass this ( with java or other tools )? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Obsession for Oil
on 10/15/02 12:29 AM, CK Raju at [EMAIL PROTECTED] appended the following
bits to my mbox:
Reports of US annexing Iraq appears to be highly disturbing. The oil
If (!preg_match('/php/',$message_body)) {
redirect_message('/dev/null');
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] OCILogon Question
Hi everybody, I have set up a connection to an Oracle database using OCILogon. In general that works, but frequently (without a clear pattern) it does not. I know that the performance of the network is variying very much (tsnping takes between 20ms up to hundreds of ms). Does someone know whether this might have an impact on OCILogon or has anybody an idea, whether OCILogon has got a time limit, in which the database has to answer? BR Ernst -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] echo printing a cookie
Hi I'm trying to print the contents of a cookie (php 4.2.3) the syntax below
is wrong but what should it be?
if ($_cookie[cookiename]== TRUE) {
echopyour cookie is $_COOKIE[cookiename]/p;
}
Regards
Steve Dodkins
IMPORTANT NOTICE The information in this e-mail is confidential and should
only be read by those persons to whom it is addressed and is not intended to
be relied upon by any person without subsequent written confirmation of its
contents. ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the
accuracy or completeness of this message as it has been transmitted over a
public network. Furthermore, the content of this e-mail is the personal
view of the sender and does not represent the advice, views or opinion of
our company. Accordingly, our company disclaim all responsibility and accept
no liability (including in negligence) for the consequences of any person
acting, or refraining from acting, on such information prior to the receipt
by those persons of subsequent written confirmation. In particular (but not
by way of limitation) our company disclaims all responsibility and accepts
no liability for any e-mails which are defamatory, offensive, racist or in
any other way are in breach of any third party's rights, including breach of
confidence, privacy or other rights. If you have received this e-mail
message in error, please notify me immediately by telephone. Please also
destroy and delete the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message is strictly prohibited. If you have
received this E-mail in error, or suspect that the message may have been
intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245
468555.
ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] echo printing a cookie
I belive $_cookie is different then $_COOKIE
Jeff
Steve Dodkins
Steve.Dodkins@ebm-zi To: Php-Db (E-mail)
[EMAIL PROTECTED]
ehl.co.uk cc:
Subject: [PHP-DB] echo printing a
cookie
10/15/2002 09:21 AM
Hi I'm trying to print the contents of a cookie (php 4.2.3) the syntax
below
is wrong but what should it be?
if ($_cookie[cookiename]== TRUE) {
echopyour cookie is $_COOKIE[cookiename]/p;
}
Regards
Steve Dodkins
IMPORTANT NOTICE The information in this e-mail is confidential and should
only be read by those persons to whom it is addressed and is not intended
to
be relied upon by any person without subsequent written confirmation of its
contents. ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the
accuracy or completeness of this message as it has been transmitted over a
public network. Furthermore, the content of this e-mail is the personal
view of the sender and does not represent the advice, views or opinion of
our company. Accordingly, our company disclaim all responsibility and
accept
no liability (including in negligence) for the consequences of any person
acting, or refraining from acting, on such information prior to the receipt
by those persons of subsequent written confirmation. In particular (but not
by way of limitation) our company disclaims all responsibility and accepts
no liability for any e-mails which are defamatory, offensive, racist or in
any other way are in breach of any third party's rights, including breach
of
confidence, privacy or other rights. If you have received this e-mail
message in error, please notify me immediately by telephone. Please also
destroy and delete the message from your computer. Any form of
reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message is strictly prohibited. If you have
received this E-mail in error, or suspect that the message may have been
intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245
468555.
ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] echo printing a cookie
Here ya go..
if ($_cookie[cookiename]) {
echopyour cookie is.$_COOKIE['cookiename']./p;
}
Cheers
Simon
-Original Message-
From: Steve Dodkins [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 15:22
To: Php-Db (E-mail)
Subject: [PHP-DB] echo printing a cookie
Hi I'm trying to print the contents of a cookie (php 4.2.3) the syntax below
is wrong but what should it be?
if ($_cookie[cookiename]== TRUE) {
echopyour cookie is $_COOKIE[cookiename]/p;
}
Regards
Steve Dodkins
IMPORTANT NOTICE The information in this e-mail is confidential and should
only be read by those persons to whom it is addressed and is not intended to
be relied upon by any person without subsequent written confirmation of its
contents. ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the
accuracy or completeness of this message as it has been transmitted over a
public network. Furthermore, the content of this e-mail is the personal
view of the sender and does not represent the advice, views or opinion of
our company. Accordingly, our company disclaim all responsibility and accept
no liability (including in negligence) for the consequences of any person
acting, or refraining from acting, on such information prior to the receipt
by those persons of subsequent written confirmation. In particular (but not
by way of limitation) our company disclaims all responsibility and accepts
no liability for any e-mails which are defamatory, offensive, racist or in
any other way are in breach of any third party's rights, including breach of
confidence, privacy or other rights. If you have received this e-mail
message in error, please notify me immediately by telephone. Please also
destroy and delete the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message is strictly prohibited. If you have
received this E-mail in error, or suspect that the message may have been
intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245
468555. ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2
5EZ
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] echo printing a cookie
If (isset($_COOKIE[cookiename]) {
echo 'Your cookie is: '.$_COOKIE[cookiename].' br';
}
-Original Message-
From: Steve Dodkins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 9:22 AM
To: Php-Db (E-mail)
Subject: [PHP-DB] echo printing a cookie
Hi I'm trying to print the contents of a cookie (php 4.2.3) the syntax
below is wrong but what should it be?
if ($_cookie[cookiename]== TRUE) {
echopyour cookie is $_COOKIE[cookiename]/p;
}
Regards
Steve Dodkins
IMPORTANT NOTICE The information in this e-mail is confidential and
should only be read by those persons to whom it is addressed and is not
intended to be relied upon by any person without subsequent written
confirmation of its contents. ebm-ZIEHL (UK) Ltd. cannot accept any
responsibility for the accuracy or completeness of this message as it
has been transmitted over a
public network. Furthermore, the content of this e-mail is the
personal
view of the sender and does not represent the advice, views or opinion
of our company. Accordingly, our company disclaim all responsibility and
accept no liability (including in negligence) for the consequences of
any person acting, or refraining from acting, on such information prior
to the receipt by those persons of subsequent written confirmation. In
particular (but not by way of limitation) our company disclaims all
responsibility and accepts no liability for any e-mails which are
defamatory, offensive, racist or in any other way are in breach of any
third party's rights, including breach of confidence, privacy or other
rights. If you have received this e-mail message in error, please notify
me immediately by telephone. Please also destroy and delete the message
from your computer. Any form of reproduction, dissemination, copying,
disclosure, modification, distribution and/or publication of this e-mail
message is strictly prohibited. If you have received this E-mail in
error, or suspect that the message may have been intercepted or amended,
please notify ebm-ZIEHL (UK) Ltd on +44(0)1245 468555. ebm-ZIEHL (UK)
Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] echo printing a cookie
-Original Message-
From: Steve Dodkins [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 14:22
To: Php-Db (E-mail)
Hi I'm trying to print the contents of a cookie (php 4.2.3)
the syntax below
is wrong but what should it be?
if ($_cookie[cookiename]== TRUE) {
echopyour cookie is $_COOKIE[cookiename]/p;
}
if (isset($_COOKIE['cookiename'])) {
echo pyour cookie is {$_COOKIE['cookiename']}/p;
}
Cheers!
Mike
-
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySql problem..............
Hi People.
I need import some data from a Paradox table, i used the script below, it worked just
fine..but all the data was imported without the ç or á or é , understand???
portuguese words all this changes to some wierd caracter is there a way to fix
this, since my table is a Paradox 4 ANSI INTL850. am i fried??
?
$conexao = odbc_connect(rodrigo,,) or die();
$query = odbc_exec($conexao,Select * from clientes) or die();
include(link_db_pratic.php);
$delete = mysql_query(delete from cli);
while (odbc_fetch_row($query)) {
$clirep = odbc_result($query,1);
$clicod = odbc_result($query,2);
$cliemp = odbc_result($query,3);
$clinom = odbc_result($query,4);
$cliend = odbc_result($query,5);
$clitel = odbc_result($query,6);
$clifax = odbc_result($query,8);
$cliema = odbc_result($query,9);
$clibai = odbc_result($query,10);
$clicid = odbc_result($query,11);
$cliest = odbc_result($query,12);
$clicep = odbc_result($query,13);
$cliins = odbc_result($query,14);
$clifat = odbc_result($query,17);
$clicgc = odbc_result($query,19);
$clicta = odbc_result($query,21);
$clilic = odbc_result($query,22);
$clidia = odbc_result($query,25);
echo$clirepbr;
echo$clicodbr;
$insert = mysql_query(INSERT INTO cli (clirep, clicod, cliemp, clinom, cliend,
clitel, clifax, cliema, clibai, clicid, cliest, clicep, cliins,clifat, clicgc, clicta,
clilic, clidia) VALUES('$clirep', '$clicod', '$cliemp', '$clinom', '$cliend',
'$clitel', '$clifax', '$cliema', '$clibai', '$clicid', '$cliest', '$clicep',
'$cliins', '$clifat', '$clicgc', '$clicta', '$clilic', '$clidia'););
}
?
Equipe Pratic Sistemas
Rodrigo Corrêa
Fone: (14) 441-1700
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Re: [PHP-DB] OCILogon Question
On Tue, Oct 15, 2002 at 03:10:20PM +0200, [EMAIL PROTECTED] wrote: Hi everybody, I have set up a connection to an Oracle database using OCILogon. In general that works, but frequently (without a clear pattern) it does not. I know that the performance of the network is variying very much (tsnping takes between 20ms up to hundreds of ms). Does someone know whether this might have an impact on OCILogon or has anybody an idea, whether OCILogon has got a time limit, in which the database has to answer? no, you can only set timeouts etc in your tnsnames.ora file, ocilogon has no intelligence at all;-) re, tc -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Need security advice/direction.
We have plenty of PHP pages that select and display data (read: SELECT permissions only). Looking to have laboratories submit their samples via browser/PHP (read: INSERT permissions). SQL Server 7.0 back end. Need some direction here on security where to's and how to's before I take off on a wild journey to who knows where. A working example would be acceptabale too!! tia John A. Davis Information Systems Specialist State of Oregon DHS DWP State of Oregon If you had to identify in one word, the reason why the human race has not achieved and never will achieve its full potential, that word would be meetings. -- Dave Barry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] images
How can I allow the user to upload images to a php website and have the image stored in the mysql db? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] images
This has been asked many times before, but unless you have a really good reason for storing the image in the database, don't. Instead, upload the image file to a directory on the server and store the URL to the image in the database. Fewer db resources are consumed. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:23 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] images How can I allow the user to upload images to a php website and have the image stored in the mysql db? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] images
to upload use copy and the $_FILES array. then around mysql, I tend to store the path in mysql and the images on the server. I personally don't like to work with blobs and don't think it makes as much sense as they do on the server. the space they take up in the db seems like a waste. my $.02... jeff |---| | Jeff | KeaneIT - Presidents | | Landing | Suite: 200 | |Outside: 617 -517-1772 | | | E-mail: [EMAIL PROTECTED] | |[ Mailing: 10 Presidents | | Landing Medford, MA 02155 USA| | ] | |---| epeloke@echoma n.com (EdwardTo: [EMAIL PROTECTED] Peloke) cc: Subject: [PHP-DB] images 10/15/2002 03:23 PM How can I allow the user to upload images to a php website and have the image stored in the mysql db? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] images
thanks Jeff and Richard, I will give that a shot. Jeff, I see you aren't to far from here if you work at Keane, I live in NH. thanks again, Eddie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 2:59 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] images to upload use copy and the $_FILES array. then around mysql, I tend to store the path in mysql and the images on the server. I personally don't like to work with blobs and don't think it makes as much sense as they do on the server. the space they take up in the db seems like a waste. my $.02... jeff |---| | Jeff | KeaneIT - Presidents | | Landing | Suite: 200 | |Outside: 617 -517-1772 | | | E-mail: [EMAIL PROTECTED] | |[ Mailing: 10 Presidents | | Landing Medford, MA 02155 USA| | ] | |---| epeloke@echoma n.com (EdwardTo: [EMAIL PROTECTED] Peloke) cc: Subject: [PHP-DB] images 10/15/2002 03:23 PM How can I allow the user to upload images to a php website and have the image stored in the mysql db? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Server Upgrade and DB Move(s)
I am in the process of upgrading my UNIX hardware and moving web sites from two different servers on to one server. I am curious as to opinions about moving/replicating the databases and peoples experiences. For the two that i have already done, i have taken a rather manual approach which was easy, but the rest are more dynamically generated and dependent on MySQL and I was looking for a tool that could replicate the structure and data onto a new server. Anybody find an easy way to do this. I could write something in PHP, but if i could, it's probably already written Thanks in advance. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: file upload and php (Not a begginer question!)
Hi, I've taken a look at theses scripts but, they also works with the standard multipart-form data method... I don't want to use this because it's too long for users when you try to upload multiple huge files.. I'm looking for a tool or script that could work like a direct ftp browser where you can select files and upload them fast as possible. All i've found work with http forms... No one have an idea ? May be I had to work with another language, like java to do theses upload.. I don't knwo what to do... Joran [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] Hi! If you search for 4images on hotscripts.com (php section ofcourse), you will find an image gallerey with the function you ask for, multiple image uploads, there you can upload a total of 10 images at the same time :) But I havent had the time to look at the code yet, just know it works :) Good Luck :) Jøran Sørbø :: Norway -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Need help with HTTP-Authentication
Hi People,. I have a problem with HTTP-Authentication, i have 2 users in my database, and i want both to be able to login. However it works, but only the first user is able to login. I Use a MySQL 3.23.xx database, PHP 4.2.3 and Apache 2.0.40. Can anyone help me with this, any help would be greatly apreciated. Thanks already;-)Maybe some examples?? ;-) Best regards, Davy Obdam, mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Need help with HTTP-Authentication
Hi, a simple question.. :) how do you do ? You can use 2 methods : with a .htaccess file on your webserver, updated with your table fields or a direct authentification with http headers and a little bit of php... Tell me more? may be I could help you. Regards, P.E. Baroiller Davy Obdam [EMAIL PROTECTED] a écrit dans le message de news: 001901c2747e$fa0184a0$[EMAIL PROTECTED] Hi People,. I have a problem with HTTP-Authentication, i have 2 users in my database, and i want both to be able to login. However it works, but only the first user is able to login. I Use a MySQL 3.23.xx database, PHP 4.2.3 and Apache 2.0.40. Can anyone help me with this, any help would be greatly apreciated. Thanks already;-)Maybe some examples?? ;-) Best regards, Davy Obdam, mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Server Upgrade and DB Move(s)
On Wednesday 16 October 2002 03:14, [EMAIL PROTECTED] wrote: I am in the process of upgrading my UNIX hardware and moving web sites from two different servers on to one server. I am curious as to opinions about moving/replicating the databases and peoples experiences. For the two that i have already done, i have taken a rather manual approach which was easy, but the rest are more dynamically generated and dependent on MySQL and I was looking for a tool that could replicate the structure and data onto a new server. Anybody find an easy way to do this. I could write something in PHP, but if i could, it's probably already written For mysql, if you have the luxury of being to stop the server(s) then just stop mysqld and copy the data files across to the new server. Or if you need to keep the server running you can use mysqldump -- but if you have a busy server then as soon as you've used mysqldump the data is out of date! -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Blore's Razor: Given a choice between two theories, take the one which is funnier. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Need help with HTTP-Authentication
Hi There,
Hi,
a simple question.. :)
how do you do ?
I am doing fine, thanks ;-). How are u?
You can use 2 methods :
with a .htaccess file on your webserver, updated with your
table fields or a direct authentification with http headers
and a little bit of php... Tell me more? may be I could help you.
I would like to use PHP.. Well this is the code i have sofar:
?php
function authenticate()
{
Header( WWW-authenticate: basic realm=\Gastenboek admin
pagina\);
Header( HTTP/1.0 401 Unauthorized);
echo U moet een geldinge loginnaam en wachtwoord invoeren om
deze functie te kunnen gebruiken!\n;
exit;
}
function CheckPwd($user,$pass)
{
//Open database connectie
include(scripts/db_connect.php);
//Maak query
$sql_query = SELECT DISTINCT loginname, password FROM
gebruikers WHERE loginnaam='$user';
//Verstuur query
$sql_id = mysql_query($sql_query, $link) or die(error in
query);
//Resultaat
$sql = mysql_fetch_assoc($sql_id);
$username = $sql['loginnaam'];
$password = $sql['password'];
return ($user != $username || $pass != $password) ? false :
true;
//Sluit database connectie
mysql_free_result($sql_id);
mysql_close($link);
}
if(!isset($PHP_AUTH_USER))
{
authenticate();
}
elseif(!CheckPwd($PHP_AUTH_USER,$PHP_AUTH_PW))
{
authenticate();
}
?
I cannot get it to work correctly.. I have two users in my
'gebruikers'(means users) table, but i can only login with the first
user. When i try the 2nd user nothing happends. Do u know a solution or
maybe some better http-authenticate script?
Thanks alot:-)
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
Regards,
P.E. Baroiller
Davy Obdam [EMAIL PROTECTED] a écrit dans le message de
news: 001901c2747e$fa0184a0$[EMAIL PROTECTED]
Hi People,.
I have a problem with HTTP-Authentication, i have 2 users in my
database, and i want both to be able to login. However it
works, but
only the first user is able to login. I Use a MySQL 3.23.xx
database,
PHP 4.2.3 and Apache 2.0.40. Can anyone help me with this, any help
would be greatly apreciated. Thanks already;-)Maybe some examples??
;-)
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] images
hello,
you can do it this way (using mysql):
?php
/*
create table images(
img_id int(4) NOT NULL auto_increment,
img_name varchar(60),
img_file_type varchar(10),
img_content blob,
PRIMARY KEY (img_id)
) TYPE=MyISAM;
*/
if (empty($imgfile) or $go!==uploadimg)
{
// Generate the form to upload the image
$form = form method=\post\ action=\\ enctype=\multipart/form-data\
Specify a name for your image : input type=\text\ name=\imgname\br/
Select your image file : input name=\imgfile\ type=\file\br/
input type=\submit\ value=\Submit\
input type=\hiddent\ name=\go\ value=\uploadimg\
/form;
echo $form;
} else {
// You have an image that you can insert it in database
/* Connecting, selecting database */
$link = @mysql_connect(mysql_host, mysql_user, mysql_password)
or die(Could not connect);
@mysql_select_db(my_database) or die(Could not select database);
// if the file uploaded ?
if (is_uploaded_file($imgfile))
{
// Open the uploaded file
$file = fopen($imgfile, r);
// you can get the $imgtype also here ;)
// Read in the uploaded file
$image = fread($file, filesize($imgfile));
// Escape special characters in the file
$image = AddSlashes($image);
}
else
$image = NULL;
$query = INSERT INTO images VALUES (NULL, '$imgname', '$imgtype',
'$image');
$result = mysql_query( $query ) or die(Query failed);
echo Hope this will help ;);
}
?
Regards,
Hatem
- Original Message -
From: Edward Peloke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 9:23 PM
Subject: [PHP-DB] images
How can I allow the user to upload images to a php website and have the
image stored in the mysql db?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Server Upgrade and DB Move(s)
At 03:14 PM 10/15/02 -0400, [EMAIL PROTECTED] wrote: I am in the process of upgrading my UNIX hardware and moving web sites from two different servers on to one server. I am curious as to opinions about moving/replicating the databases and peoples experiences. For the two that i have already done, i have taken a rather manual approach which was easy, but the rest are more dynamically generated and dependent on MySQL and I was looking for a tool that could replicate the structure and data onto a new server. Anybody find an easy way to do this. I could write something in PHP, but if i could, it's probably already written So how different are the servers? Moving databases between similar servers can be as simple as copying the database directories, and executing a CREATE DATABASE dbname command for each. You will also need to GRANT access to various users as needed. That is part of the mysql database and the easiest way to merge them is by issuing the needed commands. Rick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Need help with HTTP-Authentication
Ok.
It may works with some little correction :
in you function CheckPwd...
You get loginname,password in your query but, you look at loginnaam and
passwod in your $sql array..
one of theses :loginname or loginnaam is not the good field :)
after this, you check if user OR password ...
It would be better to check user AND password
So, function may look like this :
function CheckPwd($user,$pass)
{
//Open database connectie
include(scripts/db_connect.php);
//Maak query
$sql_query = SELECT DISTINCT loginnaam, password FROM
gebruikers WHERE loginnaam='$user';
//Verstuur query
$sql_id = mysql_query($sql_query, $link) or die(error in
query);
//Resultaat
$sql = mysql_fetch_assoc($sql_id);
$username = $sql['loginnaam'];
$password = $sql['password'];
//Sluit database connectie
mysql_free_result($sql_id);
mysql_close($link);
return ($user == $username $pass == $password) ? true : true;
}
An other thing, you may not need to open close your mysql connection in
the function, simply open it at the beginning of your script.
And, for testing, don't forget that you need to close all your browser
window each time ( browser keep information into memory when an
authentication is done).
Regards,
P.E.B
You can use 2 methods :
with a .htaccess file on your webserver, updated with your
table fields or a direct authentification with http headers
and a little bit of php... Tell me more? may be I could help you.
I would like to use PHP.. Well this is the code i have sofar:
?php
function authenticate()
{
Header( WWW-authenticate: basic realm=\Gastenboek admin
pagina\);
Header( HTTP/1.0 401 Unauthorized);
echo U moet een geldinge loginnaam en wachtwoord invoeren om
deze functie te kunnen gebruiken!\n;
exit;
}
function CheckPwd($user,$pass)
{
//Open database connectie
include(scripts/db_connect.php);
//Maak query
$sql_query = SELECT DISTINCT loginname, password FROM
gebruikers WHERE loginnaam='$user';
//Verstuur query
$sql_id = mysql_query($sql_query, $link) or die(error in
query);
//Resultaat
$sql = mysql_fetch_assoc($sql_id);
$username = $sql['loginnaam'];
$password = $sql['password'];
return ($user != $username || $pass != $password) ? false :
true;
//Sluit database connectie
mysql_free_result($sql_id);
mysql_close($link);
}
if(!isset($PHP_AUTH_USER))
{
authenticate();
}
elseif(!CheckPwd($PHP_AUTH_USER,$PHP_AUTH_PW))
{
authenticate();
}
?
I cannot get it to work correctly.. I have two users in my
'gebruikers'(means users) table, but i can only login with the first
user. When i try the 2nd user nothing happends. Do u know a solution or
maybe some better http-authenticate script?
Thanks alot:-)
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
Regards,
P.E. Baroiller
Davy Obdam [EMAIL PROTECTED] a écrit dans le message de
news: 001901c2747e$fa0184a0$[EMAIL PROTECTED]
Hi People,.
I have a problem with HTTP-Authentication, i have 2 users in my
database, and i want both to be able to login. However it
works, but
only the first user is able to login. I Use a MySQL 3.23.xx
database,
PHP 4.2.3 and Apache 2.0.40. Can anyone help me with this, any help
would be greatly apreciated. Thanks already;-)Maybe some examples??
;-)
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: file upload and php (Not a begginer [sic]question!)
on 10/15/02 4:11 PM, BAROILLER at [EMAIL PROTECTED] appended the following bits to my mbox: No one have an idea ? Maybe it's because this isn't really database related and you posted to the PHP-DB list instead of PHP-GENERAL? I don't want to use this because it's too long for users when you try to upload multiple huge files.. No matter what, it's going to take a long time to upload multiple huge files. There may or may not be less overhead using the ftp protocol, but it will still take a long time. In general, all you have with PHP is the web browser interface and that means HTML forms. Any decent browser (read: one that doesn't have huge security holes, i.e., Windows Internet Explorer) won't give you access to any files on the user's filesystem except for those specified by the user in a file type input box. I'm looking for a tool or script that could work like a direct ftp browser where you can select files and upload them fast as possible. There may be Java applets that do that, but there are probably security issue notices for the user. Time your FTP upload and your HTTP upload and see what the difference is. I don't think there's as big a difference protocol wise as you believe. If you're on a shared host, the problem is more likely other traffic on port 80 or that your web traffic is being throttled somehow. If you run your own server, try a different port 8000 to see if the speed improves. I do think that HTTP is often better for downloading because if you support HTTP-KeepAlive, you have only one connection instead of the two or more needed for each FTP request. It also works reliably in nearly all browsers whereas some may not support ftp. HTH, Paul -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Server Upgrade and DB Move(s)
thanks guys. that is how i planned to do it, but i wanted to hear this from others. This is how i accomplished the other two moves. sometimes you just want to see if anyone has a better way. and the file copy method just seems to easy, it almost seems wrong ;-), but it doesn't stop me from using it all the time. thanks again. jd Rick Widmer php3@developer To: [EMAIL PROTECTED], [EMAIL PROTECTED] sdesk.comcc: Subject: Re: [PHP-DB] Server Upgrade and DB Move(s) 10/15/2002 04:35 PM At 03:14 PM 10/15/02 -0400, [EMAIL PROTECTED] wrote: I am in the process of upgrading my UNIX hardware and moving web sites from two different servers on to one server. I am curious as to opinions about moving/replicating the databases and peoples experiences. For the two that i have already done, i have taken a rather manual approach which was easy, but the rest are more dynamically generated and dependent on MySQL and I was looking for a tool that could replicate the structure and data onto a new server. Anybody find an easy way to do this. I could write something in PHP, but if i could, it's probably already written So how different are the servers? Moving databases between similar servers can be as simple as copying the database directories, and executing a CREATE DATABASE dbname command for each. You will also need to GRANT access to various users as needed. That is part of the mysql database and the easiest way to merge them is by issuing the needed commands. Rick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: file upload and php (Not a begginer [sic]question!)
Use SmartFtp connect ot your website open the directory open windows explorer open the directory and the files you want to upload drag and drop to Smart Ftp. I you want to drop in to www or htdocs, simply double click on htdocs or...www Then select the complete directory of files and folders that you want uploaded and it will create any folders needed and fill or overwite any directories or files. Russell Griechen - Original Message - From: Paul Burney [EMAIL PROTECTED] I'm looking for a tool or script that could work like a direct ftp browser where you can select files and upload them fast as possible. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] images [Oops]
Oops sorry for never testing before sending :P the script works fine
but there is a little change, there is a hiddent should be changed to hidden
in the form ;)
that's all,
enjoy
- Original Message -
From: Hatem Ben [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 9:46 PM
Subject: Re: [PHP-DB] images
hello,
you can do it this way (using mysql):
?php
/*
create table images(
img_id int(4) NOT NULL auto_increment,
img_name varchar(60),
img_file_type varchar(10),
img_content blob,
PRIMARY KEY (img_id)
) TYPE=MyISAM;
*/
if (empty($imgfile) or $go!==uploadimg)
{
// Generate the form to upload the image
$form = form method=\post\ action=\\
enctype=\multipart/form-data\
Specify a name for your image : input type=\text\
name=\imgname\br/
Select your image file : input name=\imgfile\ type=\file\br/
input type=\submit\ value=\Submit\
input type=\hiddent\ name=\go\ value=\uploadimg\
/form;
echo $form;
} else {
// You have an image that you can insert it in database
/* Connecting, selecting database */
$link = @mysql_connect(mysql_host, mysql_user, mysql_password)
or die(Could not connect);
@mysql_select_db(my_database) or die(Could not select database);
// if the file uploaded ?
if (is_uploaded_file($imgfile))
{
// Open the uploaded file
$file = fopen($imgfile, r);
// you can get the $imgtype also here ;)
// Read in the uploaded file
$image = fread($file, filesize($imgfile));
// Escape special characters in the file
$image = AddSlashes($image);
}
else
$image = NULL;
$query = INSERT INTO images VALUES (NULL, '$imgname', '$imgtype',
'$image');
$result = mysql_query( $query ) or die(Query failed);
echo Hope this will help ;);
}
?
Regards,
Hatem
- Original Message -
From: Edward Peloke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 9:23 PM
Subject: [PHP-DB] images
How can I allow the user to upload images to a php website and have the
image stored in the mysql db?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Set Cookies
Because there is no complete code, I'm not sure, but I think: you already have code above the cookie. The cookie has to come before any other: e.a. 1 ?PHP 2cookie 3 ? 4 HTML 5 HEAD etc. Jacco Steve Dodkins [EMAIL PROTECTED] wrote in message 416B83EEF0C5D4119731000255589B77A3BC67@ebmnt01">news:416B83EEF0C5D4119731000255589B77A3BC67@ebmnt01... Hi I'm trying to use the following simple script to set cookies but get the following error message cannot add header information - headers are already sent by(output started at c:\program files\php home edition 2\www\listing19.1.php:3) in c:\program files\php home edition 2\www\listing19.1.php on line 4 3 ?php 4 setcookie( vegetable, artichoke, time()+3600, /, $SERVER_NAME, 0 ); 5 ? 6 html 7 head 8 titleListing 19.1/title 9 /head 10 body 11 ?php 12 if ( isset($vegetable ) ) 13 print phello again your chosen veg is $vegetable/p; 14 15 else print phello your 1st visit ?/p; 16 17 ? 18 19 /body 20 /html Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. Furthermore, the content of this e-mail is the personal view of the sender and does not represent the advice, views or opinion of our company. Accordingly, our company disclaim all responsibility and accept no liability (including in negligence) for the consequences of any person acting, or refraining from acting, on such information prior to the receipt by those persons of subsequent written confirmation. In particular (but not by way of limitation) our company disclaims all responsibility and accepts no liability for any e-mails which are defamatory, offensive, racist or in any other way are in breach of any third party's rights, including breach of confidence, privacy or other rights. If you have received this e-mail message in error, please notify me immediately by telephone. Please also destroy and delete the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message is strictly prohibited. If you have received this E-mail in error, or suspect that the message may have been intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245 468555. ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Paying host is better
Hi everyone, I know the answer: get a payed host. question, I'm looking for a FREE MySQL provider. I already have PHP support, just no MySQL, so anything will do now. Thank you, Jacco -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: file upload and php (Not a begginer question!)
If you don't want to use HTML, then you'll have to use a Java, C/C++, etc... type program... ---John Holmes... -Original Message- From: BAROILLER [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 4:12 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: file upload and php (Not a begginer question!) Hi, I've taken a look at theses scripts but, they also works with the standard multipart-form data method... I don't want to use this because it's too long for users when you try to upload multiple huge files.. I'm looking for a tool or script that could work like a direct ftp browser where you can select files and upload them fast as possible. All i've found work with http forms... No one have an idea ? May be I had to work with another language, like java to do theses upload.. I don't knwo what to do... Joran [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] Hi! If you search for 4images on hotscripts.com (php section ofcourse), you will find an image gallerey with the function you ask for, multiple image uploads, there you can upload a total of 10 images at the same time :) But I havent had the time to look at the code yet, just know it works :) Good Luck :) Jøran Sørbø :: Norway -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] file upload and php (Not a begginer question!)
Have you considered some kind of solution using FTP? I don't know exactly how you would integrate that with PHP, but it's an option that is more suited to transferring large files. You might be able to set up a link from one of your pages and use PHP and/or a database solution to authenticate the user prior to accessing the link to the FTP server/folder. I'm really just throwing ideas out here without knowing their viability in your or any solution, but I thought it might give you another option. -Original Message- From: Baroiller Pierre-Emmanuel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 4:42 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] file upload and php (Not a begginer question!) Hi, everyone know how to upload files from the browser to your web server using multipart-form method with move_downloaded_file() php function. But... It's a slow method for multiple files huge files transfert. I'm currently working on a big photo album tool, and I want to provide user the ability to upload a lot of jpeg files in one time... The big problem with form is it's too slow... Does anyone know how to by-pass this ( with java or other tools )? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] hotlink MySQL
Is it possible to hotlink a MySQL database? my site location is different then my MySQL location. (or at least a site). Is it possible to use the database for both sites or should I set up the database at both locations? The reason for asking is that one of the locations doesn't provide MySQL DB's anymore (max number of DB's is limited) Pls let me know if this is possible, and if so, how. Thanx, Jacco http://seabird.coolfreepage.com/main2.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] hotlink MySQL
Is it possible to hotlink a MySQL database? my site location is different then my MySQL location. (or at least a site). Is it possible to use the database for both sites or should I set up the database at both locations? The reason for asking is that one of the locations doesn't provide MySQL DB's anymore (max number of DB's is limited) Pls let me know if this is possible, and if so, how. It's possible as long as your database allows remote access. You just give the IP address of the mysql server in your mysql_connect() function. $link = mysql_connect(192.168.0.1,user,password); ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] hotlink MySQL
At 07:55 PM 10/15/2002 +0200, Seabird wrote: yes - just specify the hostname that your mysql DB resides on. And make sure that your mysql users is allowed to connect from the host that your APP or page or whatever is on. ~kurth Is it possible to hotlink a MySQL database? my site location is different then my MySQL location. (or at least a site). Is it possible to use the database for both sites or should I set up the database at both locations? The reason for asking is that one of the locations doesn't provide MySQL DB's anymore (max number of DB's is limited) Pls let me know if this is possible, and if so, how. Thanx, Jacco http://seabird.coolfreepage.com/main2.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Multiple MSSQL Server connections (per script)
I am in need of connecting to seperate MSSQL databases (two seperate hosts even). When I attempt this, the second one always seems to segfualt Apache (and thus returns no data. Has anyone succeeded in connecting to two datasources in the same PHP script? I am running... FreeTDS 0.53 Apache 1.3.12 PHP 4.0.6 Linux box (I know your first suggestion would be to upgrade, which I am working on. However, I rather that not be the real solution at this time). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Multiple MSSQL Server connections (per script)
We have had two or more MySQL datasources in the same PHP script on a few different sites. Can't really tell you much though as we didn't do anything out of the norm to do it. Just connected to them. Thought you might like reassurance that it has been done. Cheers, Owen Prime http://www.noggin.com.au Benji Spencer wrote: I am in need of connecting to seperate MSSQL databases (two seperate hosts even). When I attempt this, the second one always seems to segfualt Apache (and thus returns no data. Has anyone succeeded in connecting to two datasources in the same PHP script? I am running... FreeTDS 0.53 Apache 1.3.12 PHP 4.0.6 Linux box (I know your first suggestion would be to upgrade, which I am working on. However, I rather that not be the real solution at this time). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Multiple MSSQL Server connections (per script)
Thanks...while I was awaiting responses, I thought I would investigate this further as this problem arose just right before the end of work Well, I am a big moron :) It was a coding error, and not a problem with anything else. I am polling the needed information for the database connection from an array, and mis-looped. Oh well. Thanks for your help. benji Owen Prime wrote: We have had two or more MySQL datasources in the same PHP script on a few different sites. Can't really tell you much though as we didn't do anything out of the norm to do it. Just connected to them. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] desperate need for MySQL host
Hi everyone, as a pilot in difficult times, I'm not in the position to pay for my webhosting. My solution that I have right now is less then desirable, as I have either PHP support and no ads, or PHP and MySQL (limit one DB) with pop-up ads. I'm looking for a place that is willing to provide me with minimum space to host 2 DB's with outside acces so that I can use it via my PHP provider. No Warez, No Porn, No Illegal things. Just some airline and airport Db's. Pls, due to my situation, don't refer me to paid hosting (no matter how cheap). I appreciate the thought you put in. Jacco Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Passing string variable to HTML TITLE tag fails within Netscape but works well within IE.
Passing string variable to HTML TITLE tag fails within
Netscape but workwell within IE.I have a single page consisting of
inventory items to be sold. When an itemis selected, it passes the product
name to a DETAIL page as part of theTITLE tag for the DETAIL page. My
problem is: Netscape does not like theSPACES between the text and refuses to
display the DETAIL page.Initially, I thought there might be some way to
parse the string and add theascii code for SPACE, but I wasn't sure if I was
on the right track. Doesanyone have a proven solution to this
problem?I thought the pseudo code might look something like
this:?phpfunctionparse_and_change(grab_string){
$string_holder=$grab_string; while
stepping through the characters in this $string_holder
{ if character = " " (or some other representation)
replace it with
something that doesn't
scare netscape or title tag
} return $string_holder;
}?
?php if (isset($HTTP_GET_VARS["itemname"])) {
$title = (parse_and_change($HTTP_GET_VARS["itemname"] ));
}else{ $title="Generic Product
Title";
}? html title?php echo
$title ? /title/html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Server Upgrade and DB Move(s)
On Tue, 2002-10-15 at 15:31, [EMAIL PROTECTED] wrote: and the file copy method just seems to easy, it almost seems wrong ;-), This is a feature that is pretty nice about MySQL. You cannot do this with Postgres, which caused my quite a few nice headaches over the summer. You must dump the tables to an SQL file and read it into the new database. MySQL is pretty cool. --Dave -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] desperate need for MySQL host
I know and use a very good one, if you can understand French: www.ovh.net Free PHP, MySQL, XSLT support. Ignatius - Original Message - From: Seabird [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 9:46 PM Subject: [PHP-DB] desperate need for MySQL host Hi everyone, as a pilot in difficult times, I'm not in the position to pay for my webhosting. My solution that I have right now is less then desirable, as I have either PHP support and no ads, or PHP and MySQL (limit one DB) with pop-up ads. I'm looking for a place that is willing to provide me with minimum space to host 2 DB's with outside acces so that I can use it via my PHP provider. No Warez, No Porn, No Illegal things. Just some airline and airport Db's. Pls, due to my situation, don't refer me to paid hosting (no matter how cheap). I appreciate the thought you put in. Jacco Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
