|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Subject: php3 Digest 20 Jun 2000 16:57:25 -0000 Issue 1746
From: php3-digest-help
lists.php.netDate: Tue Jun 20 2000 - 11:57:25 CDT
- Next message: php3-digest-helplists.php.net: "php3 Digest 23 Jun 2000 22:35:26 -0000 Issue 1747"
- Previous message: php3-digest-helplists.php.net: "php3 Digest 20 Jun 2000 04:57:27 -0000 Issue 1745"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
php3 Digest 20 Jun 2000 16:57:25 -0000 Issue 1746
Topics (messages 93899 through 93955):
include() question
93899 by: Samantha Savvakis
93906 by: Alfred Perlstein
syntax error creates empty document
93900 by: Scott Moser
93903 by: rainfall
Re: using preg_replace when searching for a literal '\'char?????
93901 by: Michael Dearman
93907 by: Pavel Jartsev
Re: install php3
93902 by: Gary Bickford
Last Modified getlastmod()
93904 by: Rick Proctor
Open source editor for windows?
93905 by: gfunk007
93910 by: Meir Kriheli - MKsoft
93911 by: Opec Kemp
93938 by: Erik Mathy
PHP and PostgreSQL's arrays
93908 by: Pavel Janík ml.
Re: Multiple includes.
93909 by: Nick Talbott
Re: rollback in oracle8i
93912 by: Colin McKinnon
Log report
93913 by: Sheni R. Meledath
Query question about how to do a select which returns things that resemble the input
93914 by: Maarten Stolte
93916 by: Steven Glogger
93918 by: Jason Brooke
93921 by: Mark Selby
Re: Err 1067 Installation NT
93915 by: Phil Driscoll
Warning with PHP4
93917 by: David THOMAS
Copying a mySQL database
93919 by: Mark Selby
93922 by: Mark Selby
93929 by: Nick Talbott
foreign charcaters
93920 by: Reiner Peterke
PHP4 Warning
93923 by: David THOMAS
Upload problems in Windows98, php3 and pws environment
93924 by: Tobias Stenmark
memory-friendly chat/irc - script
93925 by: dIVUS
download http file
93926 by: Martin A. Marques
93928 by: Jonatan Bagge
Again: Query question about how to do a select which returns thin gs that resemble the input
93927 by: Jeroen Wesbeek
Re: [PHP-DB] Query question about how to do a select which return s things that resemble the input
93930 by: Boaz Yahav
Re: Simple counter
93931 by: Paul Fontenot
93945 by: Paul Fontenot
Please do NOT open any email titiled "Funny" from me!
93932 by: Iris Zhong
93933 by: The Hermit Hacker
require() problem
93934 by: ¾çÀϵî
Re: testing for image file
93935 by: Tim Thompson
Multiple Recordsets
93936 by: Ben Souther
Re: Communicating with FileMaker?
93937 by: Magnus Hammar
ODBC DSN not found
93939 by: michel
Printing highlighted PHP syntax
93940 by: Tyler Longren
Re: Query question about how to do a select which
93941 by: Einar Le Blanc
IMAP (cyrus)
93942 by: Markus Harma
Re: I wish to contact you on the ICQ Network
93943 by: Jim Brown, Sr.
Re: correct date insert??
93944 by: Dieter Kneffel
from Checkboxes to e-mail
93946 by: Martin E. Koss
93947 by: Martin E. Koss
93950 by: Steve Veltkamp
93952 by: TomHenry
Sessions - PHP Vs. ASP
93948 by: Thomas Edison Jr.
Twin Cities PHP User Group
93949 by: christopher.moewes.com
MySQL returns data-set even if where clause doesn't match ???
93951 by: Jan Mussler
R: [PHP3] oracle8: correct date insert??
93953 by: Roberto Sartor
Re: [PHP-DB] oracle8: correct date insert??
93954 by: CJ Romberger
Max execution time
93955 by: Ken N
Administrivia:
To subscribe to the digest, e-mail:
php3-digest-subscribelists.php.net
To unsubscribe from the digest, e-mail:
php3-digest-unsubscribelists.php.net
To post to the list, e-mail:
php3lists.php.net
----------------------------------------------------------------------
attached mail follows:
Hi,
I'm having a problem with an "include()". I'm using php 3.0.16 with Apache
1.3.11.
Basically, what I'm trying to do this is:
put the name/value pairs into a include file
and then perform a header("Location:...") using those name/value pairs.
eg. test.php3(This code works)
<?php
$value = "name=test&address=test";
header("Location: destination.php3?".$value);
exit();
?>
If I take the $value = "name=test&address=test" and put it into a separate
file:
details.inc:
============
<?php
$value = "name=test&address=test";
?>
Then the test.php3 looks like this:
<?php
include("details.inc");
header("Location: test.php3?".$value);
exit();
?>
I get the error that the header was already sent. I don't have any
print/echo statements.
I'm sure it's something obvious, but I can't see it. I have many
include/require statements in the rest of my site and haven't come across
this problem, but I've never tried to put a variable inside the include file
and use it the way I am here.
Any suggestions?
Thanks!
Sam
attached mail follows:
* Samantha Savvakis <samanthacfs.net.au> [000619 22:15] wrote:
>
> details.inc:
> ============
> <?php
> $value = "name=test&address=test";
> ?>
>
> Then the test.php3 looks like this:
>
> <?php
> include("details.inc");
> header("Location: test.php3?".$value);
> exit();
> ?>
>
> I get the error that the header was already sent. I don't have any
> print/echo statements.
> I'm sure it's something obvious, but I can't see it. I have many
> include/require statements in the rest of my site and haven't come across
> this problem, but I've never tried to put a variable inside the include file
> and use it the way I am here.
>
> Any suggestions?
Make sure you don't have any trailing newlines or whitespace in your
include file outside of the <? and ?>.
-Alfred
attached mail follows:
If I have a syntax error using PHP4 in a php script, instead of getting a
message telling me about the error like I would on php3, I'm getting an
error:
The document contained no data
Try again later or contact the server's administrator
you can see my problem at http://www.brickies.net/~smoser/test.php and the
source to the script at http://www.brickies.net/~smoser/test.phps . I'm
guessing that its something to do with my php.ini file, so check out the
output to my phpinfo() at http://www.brickies.net/~smoser/info.php
What could I have done wrong, any suggestions?
Thanks in advance,
sm
attached mail follows:
Maybe your php file is wrong.You can open php.ini and find if this line like below:
"display_errors = On ;"
If "display_errors=off",change it and try again.If you get same results,I think I
can't help you.In fact,I am a newbie to php too. ;-)
>If I have a syntax error using PHP4 in a php script, instead of getting a
>message telling me about the error like I would on php3, I'm getting an
>error:
> The document contained no data
> Try again later or contact the server's administrator
>
>you can see my problem at http://www.brickies.net/~smoser/test.php and the
>source to the script at http://www.brickies.net/~smoser/test.phps . I'm
>guessing that its something to do with my php.ini file, so check out the
>output to my phpinfo() at http://www.brickies.net/~smoser/info.php
>
>What could I have done wrong, any suggestions?
>
>Thanks in advance,
>sm
>
>
>
>
>
>--
>PHP 3 Mailing List <http://www.php.net/>
>To unsubscribe, send an empty message to php3-unsubscribelists.php.net
>To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
>To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
>To contact the list administrators, e-mail: php-list-adminlists.php.net
rainfall
·É»¨ÎÞÃÎ,ËéÓêÈô³¾
attached mail follows:
Zak Greant wrote:
>
> At 06:41 PM 6/19/00 -0400, Marc Swanson wrote:
> >In perl, one would expect s/\\//g to replace all instances of the '\'
> >charachter with nothing in whatever string you apply it to.. This is why I
> >am perplexed as to why this does NOT yield the desired result:
> >
> >$foo = "some \ chars \\";
> >
> >$foo = preg_replace("/\\/","",$foo);
> >
> >Doing this results in an error!!! It comes back saying that no ending
> >delimiter was found since apparently the php interpereter doesn't realize
> >that the backslash is being escaped? What do I need to do to get the
> >desired result here?
>
> I get the same result - after doing a few tests (/[\\]/, |\\|, etc..) it
> looks like backslash cannot escape itself... ?
>
> Zak Greant
>
Hey Marc, Zak,
I can't ever explain why you have to do it this way but try this out.
$foo = <as above>;
$replace = " ";
$pat = "/ *\\\\ */";
$foo = preg_replace($pat, $replace, $foo);
MD
attached mail follows:
Marc Swanson wrote:
>
> In perl, one would expect s/\\//g to replace all instances of the '\'
> charachter with nothing in whatever string you apply it to.. This is why I
> am perplexed as to why this does NOT yield the desired result:
>
> $foo = "some \ chars \\";
>
> $foo = preg_replace("/\\/","",$foo);
>
> Doing this results in an error!!! It comes back saying that no ending
> delimiter was found since apparently the php interpereter doesn't realize
> that the backslash is being escaped? What do I need to do to get the
> desired result here?
>
> Thanks
>
> -Marc-
>
Hi!
I got desired result with 'ereg_replace':
<?
$foo = ereg_replace("[\]", "", $foo);
?>
-- Pavel a.k.a. Papi
attached mail follows:
My install of suse 6.4 installed apache with php and mysql automatically. RU sure you're not already running PHP? There's a test link on the suse front page on http://localhost/ (however the test page didn't get installed on my system, though PHP is running) I did the 'install pretty much everything' and I was upgrading from 6.3.
The server hierarchy is in /usr/local/httpd, and the conf and logs are in /etc/httpd GB
ronen wrote:
> I'm trying to install php 3 on suse linux 6.4 > i tried to do what it is written in the install instructions > but i don't know where to run them (which directory) > example gunzip apache_1.3.x.tar.gz gives me > the line file not found... > and that line AddType application/x-httpd-php3 .php3 > already appears in my httpd.conf file > please help[ if you can > > Ronen
attached mail follows:
Hi,
I'm using date( "D M d, Y \ h:i a", getlastmod() ) in one of my scripts
but need it to do a specific page, I'm running a script inside a page and I
need it to do the last update of the script, not the page it's on...
Any suggestions ?
Rick
attached mail follows:
Hi, is there an open-source editor for windows that's good for php? I know there's a couple of windows php editors, but none seem to be open source, which defeats the purpose, as there's some thngs I want to put into a decent text editor so I don't have to start from scratch, which I haven't time for.
I have jedit, but can't download 50mb for the JDK to run it.
Any help?
-Josh
attached mail follows:
You don't have to download the JDK to use jEdit.
You can download JRE which is smaller.
Meir Kriheli
MKsoft computer systems
----- Original Message -----
From: "gfunk007" <joshgfunk007.com>
To: <php3lists.php.net>
Sent: Tuesday, June 20, 2000 8:26 AM
Subject: [PHP3] Open source editor for windows?
Hi, is there an open-source editor for windows that's good for php? I know there's a couple of windows php editors, but none seem to be open source, which defeats the purpose, as there's some thngs I want to put into a decent text editor so I don't have to start from scratch, which I haven't time for.
I have jedit, but can't download 50mb for the JDK to run it.
Any help?
-Josh
attached mail follows:
Hi, Try vim : http://www.vim.org
-----Original Message-----
From: gfunk007 [mailto:joshgfunk007.com]
Sent: Tuesday, June 20, 2000 4:27 PM
To: php3lists.php.net
Subject: [PHP3] Open source editor for windows?
Hi, is there an open-source editor for windows that's good for php? I know there's a couple of windows php editors, but none seem to be open source, which defeats the purpose, as there's some thngs I want to put into a decent text editor so I don't have to start from scratch, which I haven't time for.
I have jedit, but can't download 50mb for the JDK to run it.
Any help?
-Josh
attached mail follows:
Hi all!
I myself also like phpED ( http://www.soysal.com ) a great deal. This is a topic (editors for PHP) that has come up pretty often in the past. Try going to Geocrawler ( http://www.geocrawler.com ) and search the PHP archive.
- Erik
-----Original Message-----
From: Meir Kriheli - MKsoft <mksoftnetvision.net.il>
To: gfunk007 <joshgfunk007.com>; php3lists.php.net <php3lists.php.net>
Date: Tuesday, June 20, 2000 1:30 AM
Subject: Re: [PHP3] Open source editor for windows?
>You don't have to download the JDK to use jEdit.
>
>You can download JRE which is smaller.
>
>Meir Kriheli
>MKsoft computer systems
>----- Original Message -----
>From: "gfunk007" <joshgfunk007.com>
>To: <php3lists.php.net>
>Sent: Tuesday, June 20, 2000 8:26 AM
>Subject: [PHP3] Open source editor for windows?
>
>
>Hi, is there an open-source editor for windows that's
>good for php? I know there's a couple of windows
>php editors, but none seem to be open source, which
>defeats the purpose, as there's some thngs I want
>to put into a decent text editor so I don't have to start
>from scratch, which I haven't time for.
>
>I have jedit, but can't download 50mb for the JDK to
>run it.
>
>Any help?
>
>-Josh
>
>
>
>--
>PHP 3 Mailing List <http://www.php.net/>
>To unsubscribe, send an empty message to php3-unsubscribelists.php.net
>To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
>To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
>To contact the list administrators, e-mail: php-list-adminlists.php.net
attached mail follows:
Hi,
how can I easily access to PostgreSQL's arrays in PHP? Look at this snippet:
test=# CREATE TABLE foo (bar char[]); CREATE test=# INSERT INTO foo VALUES ('{f,b,n,h}'); INSERT 19241 1 test=# SELECT * FROM foo; bar ------------------- {"f","b","n","h"} (1 row)
test=#
When I tried to read this stuff from the db with:
$con=PG_Pconnect("", "", "", "", "test"); $res=pg_Exec($con, "SELECT bar FROM foo"); $record = pg_fetch_array($res, 0); echo "Num of Fields: ".pg_numfields($res)."\n"; echo "Name of Field: ".pg_fieldname($res,0)."\n"; echo "Type of Field: ".pg_fieldtype($res,0)."\n"; $bar = $record["bar"]; echo "bar=".$bar."\n";
I will get:
Num of Fields: 1 Name of Field: bar Type of Field: _bpchar bar={"f","b","n","h"}
Ie. it is only in one field with {,}," and comma between them and I really do not want to parse it on my own, because there can be special characters etc. Yes, I can do it as
SELECT bar[1] AS bar1,bar[2] AS bar2 FROM foo
But I do not think that it is good solution :-) There should be (hopefully is :-) simpler solution to work with PostgreSQL's arrays. What is it?
-- Pavel Janík ml. Pavel.Janik
attached mail follows:
Travis - I actually like the approach of confining most code to include files and having one short master file that ties it all togther. So my typical approach to any non-trivial project might look like this:
main file: ----------
include ( - global definitions - ) include ( - security and session checking stuff - ) include ( - login if required - )
switch ( on basis of value attached to a submit button in a form) case 1: include (first module); exit; case 2: include (next module); exit; ... default: include (main menu module);
module files: -------------
include( - standard html page header -) // do what ever is required here // target any form back at the main module // form submit button has value that main file uses to work out what to do next include( - standard html page footer -)
I've not done any tests on performance but I suspect that this approach actually results in the parser having less work to do than if it had to parse a whole large file skipping bits that were only relevant to certain parts of the process.
My two pence worth!
Nick Talbott IT Policy and Strategy Manager, Powys County Council, UK
email nicktpowys.gov.uk
FAX +44 (0) 1597 824781
web http://www.powys.gov.uk and http://www.powysweb.co.uk
-----Original Message-----
From: Travis Ruthenburg <listboiwacko.trickster.net>
To: php3lists.php.net <php3lists.php.net>
Date: 19 June 2000 18:12
Subject: [PHP3] Multiple includes.
>As my first project with php grows, I'm finding myself lacking good
>organization in my files. I was wondering what the disadvatages to having
>multiple includes (such as one for each function) are.
>
>Are there performance or stylistic reasons I should not go with a
>relatively small file consisting mainly of includes?
>
>Better ideas?
>
>Regards,
>
>Travis
>
>
>--
>PHP 3 Mailing List <http://www.php.net/>
>To unsubscribe, send an empty message to php3-unsubscribelists.php.net
>To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
>To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
>To contact the list administrators, e-mail: php-list-adminlists.php.net
>
>
attached mail follows:
At 18:48 20/06/00 +0700, Nguyen Van Minh wrote: > hi all have any have problem with rollback function of oracle 8i my >problem is when i insert values to orders table (if call rollback >immediatly it's OK) and next i insert values to orderlineitem table and i >check if this insert fail for any reasons and then call ocirollback the >connection that insert into order table but it's not work (that mean there >is order_id in order table but no item in order line table) any reply are >welcome M
Did you tell Oracle to begin a transaction before the first insert? AIR, if not it will automatically commit each INSERT if the subsequent statement is not ROLLBACK.
(i.e. nothing to do with PHP)
Colin
attached mail follows:
Dear PHP3 Masters,
PHP3: I have created a PHP3 application with MySQL database for member registration. And its online now. Its working properly from my machine and some other computers (IBM PC's with Windows 95/98) using Netscape & IE. But some users (some on Mac )were complaining that they were getting errors while accessing some part of the script. I have checked these sections from my computer and its working fine. While setting cookies is there any compatibility problem with different OS and browsers.
Is there any log file created by the PHP3 module on the server to find out the usage of my script and errors occured in the script. I am using the module 'mod_php3-module-mysql.so' for PHP on our server.
I have worked on the script a lot and I couldn't find out the exact problem. If anybody can help me out in any way, it will be very helpful for me.
thanks & regards
Sheni R Meledath
shenicyber-gear.com
attached mail follows:
Hi,
I'd like to know how to return some possibilities based on a users input, e.g: The users input is "terdam", and the db returns 'rotterdam,amsterdam,tordam' How do i do this?
Maarten
attached mail follows:
try it with: select * from gna where location RLIKE '%terdam%'
greetings
steven
-----Ursprüngliche Nachricht-----
Von: Maarten Stolte [mailto:M.StolteSamhoud.nl]
Gesendet: Dienstag, 20. Juni 2000 10:48
An: 'php3lists.php.net'; php-generallists.php.net;
php-dblists.php.net
Betreff: [PHP3] Query question about how to do a select which returns
things that resemble the input
Hi,
I'd like to know how to return some possibilities based on a users input, e.g: The users input is "terdam", and the db returns 'rotterdam,amsterdam,tordam' How do i do this?
Maarten
-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe
attached mail follows:
Do you have an SQL reference?
This would work in MySql:
select * from yourtable where town like '%t%rdam'
jason
> Hi, > > I'd like to know how to return some possibilities based on > a users input, e.g: > The users input is "terdam", and the db returns 'rotterdam,amsterdam,tordam' > How do i do this? > > Maarten
attached mail follows:
<? $link=mysql_connect('localhost','user','pass'); mysql_select_db('mydatabasename',$link); if($submit == 'search') { $query = "SELECT * FROM towns WHERE towns.name LIKE '".$inputbox."'"; echo $query; // Shows you the query that was built } $result_set = mysql_query($query,$link); while($row = mysql_fetch_row($result)) { echo $row[0].$row[1].$row[2].'<HR>'; } ?> <FORM METHOD="POST" TARGET="thisfilename.php3"> <INPUT TYPE="TEXT" NAME="inputbox"> <INPUT TYPE="submit" NAME="submit" VALUE="search"> </FORM>
Something along these lines will help to show you what's going on.
Moderator guys - How about a 'canned samples' area where these things can be put and searched?
Mark.
--- Jason Brooke <jasonqgl.org> wrote:
>
> Do you have an SQL reference?
>
> This would work in MySql:
>
> select * from yourtable where town like '%t%rdam'
>
> jason
>
>
> > Hi,
> >
> > I'd like to know how to return some possibilities
> based on
> > a users input, e.g:
> > The users input is "terdam", and the db returns
> 'rotterdam,amsterdam,tordam'
> > How do i do this?
> >
> > Maarten
>
>
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to
> php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail:
> php3-digest-subscribelists.php.net
> To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail:
> php-list-adminlists.php.net
>
__________________________________________________ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/
attached mail follows:
I haven't had the problem before - I don't use ISAPI, however I thought I'd look up what the error 1067 actually meant. Sadly, its no great help, but here's what winerror.h says:
// // MessageId: ERROR_PROCESS_ABORTED // // MessageText: // // The process terminated unexpectedly. // #define ERROR_PROCESS_ABORTED 1067L
The error message is lumped in with errors generated by NT services.
Sorry not to be too helpful!
-- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org
attached mail follows:
I have
Warning: Unable to fork [scopy c:\temp\test c:\temp\dasdda /s] in D:\www\index1.php on line 44
php4, IIS4, NT4.
Any idea ?
attached mail follows:
Hi All,
How do I copy a database from a remote mySQL server to a local mySQL server? I want to append the new records from the web server to the master database on the local server. The records don't need modifying in any way. What's the quickest / best way?
Thanks,
Mark.
__________________________________________________ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/
attached mail follows:
Hi Andy, I have myadmin running on both servers. I guess I'm asking for a command which copies directly between the databases without intermediate text files being involved, and no FTP'ing (might not be possible and have to go the suggested route though.) I remember seeing something which included compression options etc but might not be it. The other possibility I guess will be a script to do this manually, but, yuk, no unless I have to!
Thanks, Mark
--- Andy <andyangelsolutions.co.uk> wrote:
> If you have MyAdmin running on the server you can
> take a database dump which
> lists all the sql commands to insert the values into
> the local database as
> well as the commands that you need to create all the
> tables!
>
> Do you have this on your webserver?
>
> Andy
>
> -----Original Message-----
> From: Mark Selby [mailto:selby_markyahoo.com]
> Sent: 20 June 2000 10:10
> To: php3lists.php.net
> Subject: [PHP3] Copying a mySQL database
>
>
> Hi All,
>
> How do I copy a database from a remote mySQL server
> to
> a local mySQL server? I want to append the new
> records
> from the web server to the master database on the
> local server. The records don't need modifying in
> any
> way.
> What's the quickest / best way?
>
> Thanks,
>
> Mark.
>
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages with Yahoo! Messenger.
> http://im.yahoo.com/
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to
> php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail:
> php3-digest-subscribelists.php.net
> To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail:
> php-list-adminlists.php.net
>
>
__________________________________________________ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/
attached mail follows:
Mark
I'd try something using the mysqldump and mysql command line utility programs that come with mysql and are available for UNIX and Win32.
mysqldump --host=the.remote.ip -t databaseName tableName
will output the data in the table in sql statement format. You may will almost certainly need to add --password=xxx and --user=aaa options. the -t option means "just the data"
If you direct that output to a file called "mydump" you can then feed it all in to the master database using
mysql --host=the.master.ip databaseName < mydump
Again, add user and password options as required.
If you're feeling brave, do it all in one line: (parameters not shown for simplicity)
mysqldump -parameters | mysql -parameters
Regards
Nick Talbott IT Policy and Strategy Manager, Powys County Council, UK
email nicktpowys.gov.uk
FAX +44 (0) 1597 824781
web http://www.powys.gov.uk and http://www.powysweb.co.uk
-----Original Message-----
From: Mark Selby <selby_markyahoo.com>
To: php3lists.php.net <php3lists.php.net>
Date: 20 June 2000 10:09
Subject: [PHP3] Copying a mySQL database
>Hi All,
>
>How do I copy a database from a remote mySQL server to
>a local mySQL server? I want to append the new records
>from the web server to the master database on the
>local server. The records don't need modifying in any
>way.
>What's the quickest / best way?
>
>Thanks,
>
>Mark.
>
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages with Yahoo! Messenger.
>http://im.yahoo.com/
>
>--
>PHP 3 Mailing List <http://www.php.net/>
>To unsubscribe, send an empty message to php3-unsubscribelists.php.net
>To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
>To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
>To contact the list administrators, e-mail: php-list-adminlists.php.net
>
>
attached mail follows:
i have data in my data base that contains german umlaut characters in html format. ie v = 'ö' the semicolon causes my statments to be abnormally terminated. when i try a mysql> select name, replace(name,'ö','v') from info; i get the following error
ERROR 2013: Lost connection to MySQL server during query mysql> bin/safe_mysqld: 16652 Memory fault - core dumped mysqld daemon ended
replace(name,'t','i') works
any suggestions on how i can correct my data
r
attached mail follows:
I have
Warning: Unable to fork [scopy c:\temp\test c:\temp\dasdda /s] in D:\www\index1.php on line 44
php4, IIS4, NT4.
Any idea ?
attached mail follows:
Upload problems in Windows98, php3 and pws environment
I have made thiese simple upload scripts below, but I get an error message while trying to run it: Warning: Unable to open 'c:\\windows\\TEMP\\php2' for reading: Unknown error in C:\Inetpub\wwwroot/php/upload3.php on line 7
I have tried to set the php3.ini file like this: upload_tmp_dir = C:\Inetpub\tmp; ...but that doesn´t seem to take affect.
What am I doing wrong? ___
file: upload.php <?
echo "<html><head><title>Multiparttest</title></head>\n"; echo "<body>\n\n"; echo "<H3>Upload file to server</H3>\n"; echo "<form enctype=\"multipart/form-data\" action=\"upload3.php\" method=\"post\">\n"; echo "<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"1000\">\n"; echo "Send this file: <input name=\"userfile\" type=\"file\"><br><br>\n"; echo "<input type=\"submit\" value=\"send file\">\n\n"; echo "</body>\n"; echo "</html>\n";
?>
file: upload3.php <? echo "\$userfile: " . $userfile . "<br>\n"; echo "\$userfile_name: " . $userfile_name . "<br>\n"; echo "\$userfile_size: " . $userfile_size . "<br>\n"; echo "\$userfile_type: " . $userfile_type . "<br>\n";
if ( !copy ($userfile, "files\\" . $userfile_name)) { print ("<FONT COLOR=\"#FF0000\">Was not able to copy <I>".$userfile."</I> to <I>filer\\$userfile_name</I></FONT><br>\n"); }
?>
attached mail follows:
Hi all,
I heard some PHP-chat/irc-scripts use a lot of memory from the server. Does anyone know a memory-friendly chat/irc - script ?
TNX in advance
dIVUS
attached mail follows:
Is there a command in PHP4 to download a URL file. I need the script to download something like http://where.ever.com/path/index.html
Is there a funtion in PHP for doing this?
Thanks
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Martín Marqués email: martinmath.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------
attached mail follows:
Go to http://www.php.net and search the mailinglist archives for "fopen" or something similar. Please always seacrh for old posts before you post a new one.
<SNIP> $up = fopen('http://someURL'); if ($up) { while (!feof($up)) { echo fread($up, 1024); } fclose($fp) } </SNIP>
"Martin A. Marques" wrote:
> Is there a command in PHP4 to download a URL file. I need the script to
> download something like http://where.ever.com/path/index.html
>
> Is there a funtion in PHP for doing this?
>
> Thanks
>
> "And I'm happy, because you make me feel good, about me." - Melvin Udall
> -----------------------------------------------------------------
> Martín Marqués email: martinmath.unl.edu.ar
> Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net
attached mail follows:
Thank you all for the swift replies, but I think the question was not completely clear. Your answers all search for exact data matches though we would like to find data that is the closest match to the search argument.
Let's say we've got a table that contains the following data in a column
teststring thisisnothing test strong west ring best-thing nomatchatall
and we search that column for let's say 'press thing'. We would like that the database would come up with the closest matches like: teststring west ring best-thing
we are going to use a MSSQL server is this possible (it should be because nummerous sites use the same concept) and, if so, how? :)
Jeroen Wesbeek Webprogrammeur &Samhoud NetVenture St. Jacobsstraat 16 3500 AK Utrecht
030-2348110
[ Roses are red, violets are blue, I am schizophrenic and so am I ] [ If you don't understand it, get rid of it ]
-----Original Message-----
From: Mark Selby [mailto:selby_markyahoo.com]
Sent: dinsdag 20 juni 2000 11:27
To: php3lists.php.net
Subject: Re: [PHP3] Query question about how to do a select which
returns things that resemble the input
<? $link=mysql_connect('localhost','user','pass'); mysql_select_db('mydatabasename',$link); if($submit == 'search') { $query = "SELECT * FROM towns WHERE towns.name LIKE '".$inputbox."'"; echo $query; // Shows you the query that was built } $result_set = mysql_query($query,$link); while($row = mysql_fetch_row($result)) { echo $row[0].$row[1].$row[2].'<HR>'; } ?> <FORM METHOD="POST" TARGET="thisfilename.php3"> <INPUT TYPE="TEXT" NAME="inputbox"> <INPUT TYPE="submit" NAME="submit" VALUE="search"> </FORM>
Something along these lines will help to show you what's going on.
Moderator guys - How about a 'canned samples' area where these things can be put and searched?
Mark.
--- Jason Brooke <jasonqgl.org> wrote:
>
> Do you have an SQL reference?
>
> This would work in MySql:
>
> select * from yourtable where town like '%t%rdam'
>
> jason
>
>
> > Hi,
> >
> > I'd like to know how to return some possibilities
> based on
> > a users input, e.g:
> > The users input is "terdam", and the db returns
> 'rotterdam,amsterdam,tordam'
> > How do i do this?
> >
> > Maarten
>
>
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to
> php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail:
> php3-digest-subscribelists.php.net
> To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail:
> php-list-adminlists.php.net
>
__________________________________________________ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/
-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe
attached mail follows:
Use LIKE
SELECT * FROM MyTable WHERE MyField LIKE '%MyWord%'
Sincerely
berber
Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow.
-----Original Message-----
From: Maarten Stolte [mailto:M.StolteSamhoud.nl]
Sent: Tuesday, June 20, 2000 10:48 AM
To: 'php3lists.php.net'; php-generallists.php.net; php-dblists.php.net
Subject: [PHP-DB] Query question about how to do a select which returns
things that resemble the input
Hi,
I'd like to know how to return some possibilities based on a users input, e.g: The users input is "terdam", and the db returns 'rotterdam,amsterdam,tordam' How do i do this?
Maarten
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe
attached mail follows:
Take a look at http://www.code-slinger.com There is a counter I use there that if you are interested I will gladly post source to.
-Paul
-----Original Message-----
From: Tim Homes [mailto:timhtimaru.com]
Sent: Monday, June 19, 2000 8:51 PM
To: php3lists.php.net
Subject: [PHP3] Simple counter
Someone requested a simple counter a day or two ago,
You need to set the counter name in the second line (var/count/COUNTERNAME). It will automatically set up the counter name if it does not exist.
To view it in use check out the following; www.timaru.com/railway
<?php $fname="/var/count/count"; if (file_exists($fname)){ $ct = file($fname); } else{ $ct[0] = 0; } $ct[0]++; $fp = fopen($fname, "w+"); fputs ($fp, $ct[0]); fclose($fp); print "<p>"; print "<table border = '1'><tr><td >"; print "Hit Counter"; print "</td></tr>"; print "<tr><td border = '1' bgcolor = 'black'>"; print "<font face = 'arial black' color = 'white'>"; printf("%06d", $ct[0]); print "</font>"; print "</td></tr></table>"; ?>
Tim Homes
Baycity Internet& Multimedia Ltd. www.baycity.net.nz Timaru, New Zealand. www.timaru.com
-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe
attached mail follows:
When I get home from work I will be posting PHP source and supplying instructions on its use.
-Paul
>Feel free to post it to me if you like. >tnx // Jonatan Bagge > > >Paul Fontenot wrote: > >> Take a look at http://www.code-slinger.com There is a counter I use there
>> that if you are interested I will gladly post source to. >> >> -Paul > http://netwinsite.com
attached mail follows:
Hi All,
This morning I opened an email titled with the subject "Funny". And later when I read news online, it says a new email virus just found, and usually contains "Funny" in the subject. And it doesn't hurt any system file, but it would send email automaticaaly to the addresses listed in the contacts book. Therefore, please do not open any email from me with attachment , and this one is the only email I sent to you today! Iris Zhong TEK DigiTel Corporation Tel: 301.916.7600 ext 127
attached mail follows:
For more information on this new worm: http://www.zdnet.com/zdnn/stories/news/0,4586,2590403,00.html?chkpt=zdhpnews01
On Tue, 20 Jun 2000, Iris Zhong wrote:
> Hi All, > > This morning I opened an email titled with the subject "Funny". > And later when I read news online, it says a new email virus just found, > and usually contains "Funny" in the subject. And it doesn't hurt > any system file, but it would send email automaticaaly to the addresses > listed in the contacts book. > Therefore, please do not open any email from me with attachment , > and this one is the only email I sent to you today! > > Iris Zhong > TEK DigiTel Corporation > Tel: 301.916.7600 ext 127 > >
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator hub.org
primary: scrappyhub.org secondary: scrappy{freebsd|postgresql}.org
attached mail follows:
<HR><table align=left><tr> <td width="50" align=left><a href="http://hyundai.orgio.net" target=_top><IMG SRC="http://www2.orgio.net/orgiomail/stamp.gif" border=0></a></td> </tr></table><BR><BR>
attached mail follows:
here's my 1/2 of .02 cents worth:
if (file_exists("{path to folder}/families/$family_no.jpg")) { $pic = "$family_no.jpg"; } else { $pic = "noimage.jpg"; }
print ("<td><valign='top'><img src='/families/$pic' alt='$family_name'
Rossi Designs wrote:
>
> Use the file_exists() function
>
> http://www.php.net/manual/function.file-exists.php
>
> if (file_exists("xxxxxx.jpg") {
> ...do this..
> } else {
> ... do that ...
> }
>
> AFAIK they need to be local files for this to work.
>
> Rossi Designs
> PO Box 1084
> Holly Hill, FL 32125-1084
> Phone : (904) 226-8979
> URL : http://rossidesigns.net
> ----- Original Message -----
> From: Patrick Larkin <plarkinbeth.k12.pa.us>
> To: php <php3lists.php.net>
> Sent: Wednesday, June 14, 2000 5:25 PM
> Subject: [PHP3] testing for image file
>
> |
> | Hello:
> |
> | I'm using Apache, php3 and MySQL on LinuxPPC.
> |
> | I have the following code:
> |
> | if ($schoolnumber == 50) {
> | PRINT "<img src=\"$picture\" width=\"128\" height=\"160\">";
> | } elseif ($schoolnumber == 53) {
> | PRINT "<img src=\"$picture\" width=\"128\" height=\"160\">";
> | } else {
> | PRINT "<img src=\"$nopicture\" width=\"128\" height=\"160\">";
> | }
> |
> | Basically, it tests does this:
> |
> | If the school is 50, show a picture.
> | If the school is 53, show a picture.
> | If its any other school, show a blank placeholder.
> |
> | I do this because we only have pictures for people in Schools 50 and 53.
> |
> | My issue is now that not all people have pictures, even in schools 50 or
> 53.
> | I need to test whether the picture exists and if not, display the
> | placeholder.
> |
> | Each person has an ID (xxxxxx) and their picture is xxxxxx.jpg. How can I
> | test to see if http://webserver/xxxxxx.jpg exists? Like this:
> |
> | $id = 123456
> |
> | if http://webserver/123456.jpg exists
> | display http://webserver/123456.jpg
> | else
> | display placeholder
> |
> |
> |
> | Can php do this? Thanks
> |
> |
> |
> |
> | --
> | Patrick Larkin
> | Network Automation
> | BASD
> |
> |
> | --
> | PHP 3 Mailing List <http://www.php.net/>
> | To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> | To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> | To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> | To contact the list administrators, e-mail: php-list-adminlists.php.net
> |
> |
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net
attached mail follows:
Looking for a way to retrieve multiple recordsets generated by a MS SQL Server Cursor with the odbc functions.
I do this quite regularly in ASP using ADO. I'm hoping that I can eliminate the use of ADO with PHP.
Also I've recently downloaded PHP 4 for Windows and the MS SQL Server DLL wasn't included. Does anyone know where I can go to download the DLL?
attached mail follows:
Thanks.
>>I will try and se how it goes. > >Do so, you might like using odbc. It has it's uses, to be sure! I don't mind >either route. Whatever tool works best for the job. Good thing that PHP >gives you so damn many tools. ;)
I just realized something. How do I do a connection to tha datbase so I can communicate with it?
If I have a webserver with php at 192.168.100.1 and want to connect to a filemaker database with ODBC, how do I do that? The database is called "test.fmp".
<? // ----------------------------------------------------------- $database = "test.fmp"; $server = "localhost"; $user = ""; $pass = ""; // ----------------------------------------------------------- $odbc_connection = odbc_connect($database, $user, $pass); // ----------------------------------------------------------- ?> is there something else I need or how does it work?
Can someone please explain it to me :)
(Isn't this fun?!)
Thanks. /Magnus
attached mail follows:
Hi, I have installed php4 (cgi) with odbc (--with-iodbc=/usr/local) and under /usr/local/etc/ I have the file odbc.ini with this into it: ; ; odbc.ini ; [ODBC Data Sources] OpenLink = OpenLink (MT) NETWORK = DB2
[OpenLink] Driver = /home/openlink/lib/oplodbc.so.1 Description = Sample OpenLink MT DSN Host = localhost ServerType = Oracle 8 FetchBufferSize = 99 UserName = Password = Database = ServerOptions = ConnectOptions = Options = ReadOnly = no
[NETWORK] Driver = /usr/local/lib/libiodbc.so Description = DB2 Host = x.y.z ServerType = DB2 FetchBufferSize = 99 UserName = MyUser Password = MyPasswd Database = SHOP ServerOptions = ConnectOptions = Options = ReadOnly = no
[Default] Driver = /usr/local/lib/libiodbc.so Description = DB2 Host = x.y.z ServerType = DB2 FetchBufferSize = 99 UserName = MyUser Password = MyPasswd Database = SHOP ServerOptions = ConnectOptions = Options = ReadOnly = no
but when I try to exec it (php db2.php) I get this error: X-Powered-By: PHP/4.0.0 Content-type: text/html
<br> <b>Warning</b>: SQL error: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQL state IM002 in SQLConnect in <b>/home/michel/web/db2.php</b> on line <b>3</b><br>
my line 3 in db2.php file is:
$connection = odbc_connect("NETWORK","","") or die("Non riesco a collegarmi");
where is my error? Tnx in advance
L'amore è: la felicità di essere in due, il dispiacere di diventare tre, la fregatura di rimanere soli.
-- Michel <ZioBudda> Morelli michelICQ UIN: 58351764 PR of PhpItalia.com http://www.ziobudda.net http://faq.ziobudda.net
attached mail follows:
I've asked a question similar to this before on this list. But how do I print "pretty php" onto a webpage without using the .phps extension or by show_source("file.php"); ? I have some PHP code in a MySQL database that needs to be displayed onto a webpage and it needs to be pretty. Does anybody know how to do this?
Regards, Tyler Longren
attached mail follows:
Many databases support a function called SOUNDEX. This function converts a string into a 4 character value. Now to get my "snipe" in. Most real databases support the function. Its a published algorithm so if SQL Server doesn't support it you should still be able to find it on the net. I'm fairly sure SQL Server does support it. These values can then be compared to see if the strings "sound similar". The most common use of this function is for name matching - such as Rubinstein, Runenstein, Rubinstien, Rubenstien. It will work with any string. Not sure how well it will do with more than one string. Here's some results from some of the examples in your mail:
T1COL SOUNDEX -------------------- ---- test string T232 west ring W236 best-thing B233 test strong T232
If your DB doesn't support it, you can store the result of the function in the table and use the function from your PHP code.
Einar
attached mail follows:
Is there any way to change the ACL of an cyrus IMAPD from PHP?
Creating user-mailboxes works just fine by just logging in as someone defined as 'admin', but deleting a mailbox (user.<user>) is impossible (as the admins lack the D flag in the ACL for that mailbox).
Therefore I need to change the ACL - any way to do this using PHP?
(or is there any way to set the default flags to include delete permissions for admins?)
Also - is there any way of setting the Quota using PHP when creating the mailbox? (or a way to set default quota? ;))
Finally, any way to GET the quota minus the used space (to be able to warn the user when his/her mailbox starts to get full)?
I think that's all for now ;)
r. Markus
attached mail follows:
Did anyone else get this sh*t in thier email?? Why is this guy spamming the list? Can't they just leave us alone? We get thier spam enough through our normal mail now it's being posted here.
I hope PHP has a spammer filter :o)
jamesadd.com wrote:
>
> Hello!
>
> I have tried to contact you through ICQ but couldn't find you in the ICQ Community! If you are using ICQ, please send me your ICQ number by ICQ Email Express to 77977525pager.mirabilis.com
>
> If you are not using ICQ, I would like to invite you to join the ICQ community so we can send messages, chat and find more friends to join us.
>
> Download ICQ by going to:
>
> http://www.icq.com/
>
> Once you do so, we can communicate online.
>
> Seek you ICQ
> James Cloud
> ICQ #: 77977525
>
> Here are the 4 ways you can find me in the ICQ community:
> - My ICQ number is 77977525
> - My Personal Communication Center on the Web, from which you can send me a message without having the ICQ program is: http://wwp.icq.com/77977525
> - You can send me an Email Express which will appear directly on my computer screen to 77977525pager.mirabilis.com.
> - My ICQ Web Front is members.icq.com/77977525. If I am online and activated my ICQ Web Front, you will be able to have a 2 way dialog with me from this page.
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net
-- James Brown, Sr. CIO | DNS/System/Network Administrator Sys-Admin
attached mail follows:
help, please: What is the proper format to perform an insert of date and time information into a date field using oracle8.
the following just does not work: 'insert into my_table ( my_date_field )VALUES( '2000-06-20 12:05:01') using other notation, e.g. slashes (01/01/2000) nstead of minus (as above) works, but only on dates. I am not able to insert date and time! the my_date_field is simply defined as 'date' In some manuals, I have seen a notion like ... TO_DATE() where you have to supply the date/time as an integer and give formatting information. Is this the only way?
Please give me an example!
thanks,
dieter
attached mail follows:
Hi, I've read numerous entries about getting selected checkbox values recognised but haven't been able to figure out my dilema.
I hava group of check boxes on a form:
<INPUT TYPE=CHECKBOX NAME="Options" VALUE=Black>Black <INPUT TYPE=CHECKBOX NAME="Options" VALUE=White>White <INPUT TYPE=CHECKBOX NAME="Options" VALUE=Grey>Grey
And when I compile the e-mail, I want to slot these selected itmes into the message:
mail("$SentBy", "$Subject", $Message, "From: $Email\nReply-To: $Email\n Options - $Options <-- NEED THEM HERE ");
Any suggestions?
Thanks.
Martin E. Koss Active Media Solutions / Paradox IT Limited
attached mail follows:
Hi, I've read numerous entries about getting selected checkbox values recognised but haven't been able to figure out my dilema.
I hava group of check boxes on a form:
<INPUT TYPE=CHECKBOX NAME="Options" VALUE=Black>Black <INPUT TYPE=CHECKBOX NAME="Options" VALUE=White>White <INPUT TYPE=CHECKBOX NAME="Options" VALUE=Grey>Grey
And when I compile the e-mail, I want to slot these selected itmes into the message:
mail("$SentBy", "$Subject", $Message, "From: $Email\nReply-To: $Email\n Options - $Options <-- NEED THEM HERE ");
Any suggestions?
Thanks.
Martin E. Koss Active Media Solutions / Paradox IT Limited
attached mail follows:
I think the simple solution is to give each of the checkboxes a unique name value. The form will pass the name value as a variable, and if they are all the same then you'll only get one.
INPUT TYPE=CHECKBOX NAME="Black" VALUE=Black> instead of INPUT TYPE=CHECKBOX NAME="Options" VALUE=Black>
Quoting "Martin E. Koss" <mekmek.co.uk>:
> Hi,
> I've read numerous entries about getting selected
checkbox values
> recognised
> but haven't been able to figure out my dilema.
>
> I hava group of check boxes on a form:
>
> <INPUT TYPE=CHECKBOX NAME="Options" VALUE=Black>Black
> <INPUT TYPE=CHECKBOX NAME="Options" VALUE=White>White
> <INPUT TYPE=CHECKBOX NAME="Options" VALUE=Grey>Grey
>
> And when I compile the e-mail, I want to slot these
selected itmes into the
> message:
>
> mail("$SentBy", "$Subject", $Message,
> "From: $Email\nReply-To: $Email\n
> Options - $Options <-- NEED THEM HERE
> ");
>
> Any suggestions?
>
> Thanks.
>
> Martin E. Koss
> Active Media Solutions / Paradox IT Limited
>
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-
unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-
subscribelists.php.net
> To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-
adminlists.php.net
>
>
For mutual success, Steve Veltkamp http://bizshop.com, http://learnhow.to, http://webmasterbiz.com BizShop, 1713 E 3rd St, Pt Angeles WA 98362-4909 General: 360-452-2418 Sales: 1-800-949-8029 Fax: 604- 761-1410
-----------------------------------------------------
attached mail follows:
See changes below
First the following change,. make Options a PHP array by using $Options[] as the name for the checkbox element as follows.
><INPUT TYPE=CHECKBOX NAME="Options[]" VALUE=Black>Black ><INPUT TYPE=CHECKBOX NAME="Options[]" VALUE=White>White ><INPUT TYPE=CHECKBOX NAME="Options[]" VALUE=Grey>Grey > >And when I compile the e-mail, I want to slot these selected itmes into the >message:
Then
while(list($k,$v)=each($Options)){ $FormOptions .= " $v "; }
>mail("$SentBy", "$Subject", $Message, >"From: $Email\nReply-To: $Email\n
And then:
>Options - $FormOptions ");
HTH get you started -------------------------------------------------------------------- Strategic Business Systems (978) 745-2332 http://BusinessWebs.com/ --------------------------------------------------------------------
attached mail follows:
How different are PHP sessions from ASP sessions? How do u really use sessions in PHP? I'm from an ASP background and i always found sessions to be one of the most usefull things in ASP.
Regards, T. Edison jr.
=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : abraxastechyahoo.com
Tel : 91-4546512/4522124
*******************************************
__________________________________________________ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/
attached mail follows:
After a small technical fiasco the Twin Cities PHP User Group is
reorganizing itself and planning its next meeting. If you are
interested in getting involved with the group, check out
http://www.moewes.com/tcphp.php3, or send an email to
tcphpug-subscribemoewes.com. If you were previously subscribed to
this emai list, please resubscribe to guarantee that you are still
there.
If you are looking for a PHP User Group in your area, or have a group and want to help people find it, visit http://www.moewes.com/phpug.php3
---- Christopher R. Moewes-Bystrom cmoewes
attached mail follows:
Hi!
I've got a large problem. Using my own function to verify if the userpassword and firmid is right some strange things happen, or at least I don't understand them
username, password and firmid are passed to the following function. In my view the mysql query now tries to fetch all passwords, and acountIDs where a_name is like the username and the firmID passed is like the value stored in the a_firmennummer column.
Now what happens:
If I pass a right user + password + firmid evrething works. If the password is wrong it works. But if the firmid differs from the one which is stored in the a_firmennummer column it doesn't do anything. The user can still log in.
As I understand my script, the query should not return anything and the script should return 0;
TIA Jan M.
P.S.: Script and Table Content is listed below (PHP 3.0.16 & MYSQL 3.22.32)
function check_user($username,$firmenid,$userpw) // checks username and password { if( $userpw == "") { return 0; }
if($firmenid == "") { return 0; } $result = mysql_query("SELECT acountID,a_pass FROM acounts WHERE (a_firmennummer = $firmenid) AND (a_name like '$username');"); if($result) { if($row = mysql_fetch_row($result)) { $pw = $row[1]; $id = $row[0]; } else { return 0; // I think the script should stop here if the $firmid isn't found in any cell, becaue it returns an emtpy set. } } else { $pw = ""; } if(!strcmp(md5($userpw),$pw) && $pw != "") { return $id; } else { return 0; } }
mysql> select * from acounts\G
*************************** 1. row ***************************
acountID: 2
a_firmennummer: 13
a_name: freud
a_pass: b3bd1282fec5427aac0cadda95a5a6aa
a_email: jan4freedom.de
a_admin: 1
1 row in set (0.01 sec)
mysql>
attached mail follows:
try the following:
INSERT INTO my_table (my_date_field) VALUES (to_date('2000-06-20 12:05:01','yyyy-mm-dd hh24:mm:ss'));
or
INSERT INTO my_table (my_date_field) VALUES (to_date('200600','ddmmrr'));
From Oracle7.3.4 manual:
TO_DATE Syntax TO_DATE(char [, fmt [, 'nlsparams'] ])
Purpose
Converts char of CHAR or VARCHAR2 datatype to a value of DATE datatype. The fmt is a date format specifying the format of char. If you omit fmt, char must be in the default date format. If fmt is 'J', for Julian, then char must be an integer. For information on date formats, see the section "Format Models" .
The 'nlsparams' has the same purpose in this function as in the TO_CHAR function for date conversion.
Do not use the TO_DATE function with a DATE value for the char argument. The returned DATE value can have a different century value than the original char, depending on fmt or the default date format.
For information on date formats, see page 3 - 64.
Example
INSERT INTO bonus (bonus_date) SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = American') FROM DUAL
or jump into http://technet.oracle.com (free subscription)
-----Messaggio originale-----
Da: Dieter Kneffel [mailto:datawap4.com]
Inviato: martedì 20 giugno 2000 18.02
A: php3lists.php.net; php-db
Oggetto: [PHP3] oracle8: correct date insert??
help, please: What is the proper format to perform an insert of date and time information into a date field using oracle8.
the following just does not work: 'insert into my_table ( my_date_field )VALUES( '2000-06-20 12:05:01') using other notation, e.g. slashes (01/01/2000) nstead of minus (as above) works, but only on dates. I am not able to insert date and time! the my_date_field is simply defined as 'date' In some manuals, I have seen a notion like ... TO_DATE() where you have to supply the date/time as an integer and give formatting information. Is this the only way?
Please give me an example!
thanks,
dieter
-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe
attached mail follows:
I'm pretty sure you need to use a to_date('string','format') on it.
to_date('06/06/2000','MM/DD/YYYY') ...or something fairly close to that.
CJ
"No other personal quality contributes to success more than relentless persistence in the pursuit of one's goals."
-----Original Message-----
From: Dieter Kneffel [mailto:datawap4.com]
Sent: Tuesday, June 20, 2000 11:02 AM
To: php3lists.php.net; php-db
Subject: [PHP-DB] oracle8: correct date insert??
help, please: What is the proper format to perform an insert of date and time information into a date field using oracle8.
the following just does not work: 'insert into my_table ( my_date_field )VALUES( '2000-06-20 12:05:01') using other notation, e.g. slashes (01/01/2000) nstead of minus (as above) works, but only on dates. I am not able to insert date and time! the my_date_field is simply defined as 'date' In some manuals, I have seen a notion like ... TO_DATE() where you have to supply the date/time as an integer and give formatting information. Is this the only way?
Please give me an example!
thanks,
dieter
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe
attached mail follows:
Hi, I'm working on some scripts that haev to edit a huge httpd.conf file. I have no problem writing to the file however I need to do some error checking to make sure the name doesn't already exist in the file and even if I just try to print it out with a for loop I get
Fatal error: Maximum execution time exceeded in /web/sites/roy20/lapidary.com/stats-new/ereg-test.php3 on line 16
I'm assuming this is due the file size. Any suggestions?
Thank you Ken N
http://cleveland.lug.net/~rocket/
The answer is simple if you grant that ironies are like submarines; dangerous only when submerged.
- Next message: php3-digest-helplists.php.net: "php3 Digest 23 Jun 2000 22:35:26 -0000 Issue 1747"
- Previous message: php3-digest-helplists.php.net: "php3 Digest 20 Jun 2000 04:57:27 -0000 Issue 1745"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]