Re: [PHP3] PHP Ticketing system

We took a look at Keystone, but we are having various problems with it and it doesn't have quite what we need. Does anyone know of another PHP based ticketing system? ------- Chris, this is what you need ?? http://phphelpdesk.sourceforge.net/ -- idban secandri, mail send on June 20, 2000 To have one joy, you must share it. http://php.klik.or.id || joy inside!

ereg_replace

I'm trying to edit a skeleton file and fill in the blanks, but ereg_replace() doesn't seem to work. I'd appreciate some insight from you php gurus out there. The error message: None, that's the problem. the script: <?php include "admin_header.inc"; $floorvar = "floor"; $long_floorvar = "long_floor"; $fd = fopen ("/usr/local/www/forums/skel/floor/index.phtml", "r+"); $contents = fread ($fd, filesize ("/usr/local/www/forums/skel/floor/index.phtml")); print $contents; ereg_replace("FLOORVAR", $floorvar, $contents);

R: [PHP3] oracle8: correct date insert??

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=20 Syntax TO_DATE(char [, fmt [, 'nlsparams'] ]) Purpose=20 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 form

[PHP3] Sessions - PHP Vs. ASP

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 : abraxastech@yahoo.com Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.

from Checkboxes to e-mail

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

from Checkboxes to e-mail

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

Twin Cities PHP User Group

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-subscribe@moewes.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@moewes.com h

Re: [PHP3] Query question about how to do a select which

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 tha

Re: [PHP3] Re: Communicating with FileMaker?

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"; $s

Multiple Recordsets

------=_NextPart_000_0021_01BFDA9C.A538F530 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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.=20 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? ------=_NextPart_000_0021_01BFDA9C.A538F530 Content-Type: text/html; charset=

Please do NOT open any email titiled "Funny" from me!

------=_NextPart_000_0000_01BFDA97.940D9C20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 C

Max execution time

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

Upload problems in Windows98, php3 and pws environment

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 =3D C:\Inetpub\tmp; ....but that doesn=B4t seem to take affect. What am I doing wrong? ___ file: upload.php <?=20 echo "<html><head><title>Multiparttest</title></head>\n"; echo "<body>\n\n"; echo "<H3>Upload file to server</H3>

Re: [PHP3] Copying a mySQL database

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

Again: Query question about how to do a select which returns thin gs that resemble the input

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

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.

Warning with PHP4

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 ?

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

Log report

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 fin

PHP and PostgreSQL's arrays

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"; ech

Re: [PHP3] syntax error creates empty document

Maybe your php file is wrong.You can open php.ini and find if= this line like below: "display_errors=09=3D=09On=09;" If "display_errors=3Doff",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/te

Re: Help on uploading files to NT with IIS

Hi Could anyone advice me on how to upload a file to an NT server running IIS? I can do this with apache but not IIS! I know one can use the file cpshost.dll but I have my own php3 script that needs to process the uploaded file? Also how can I avoid NT asking me for a username and password each time I want to upload a file? Thanks for any help Tim

include() question

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:

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 = 'b

Digital camera

Hello all, Has anybody got any suggestions or hints about taking a picture, adding a description and price and making it available to the browser. Any sample scripts would be appreciated. What is the best camera to buy? I'm trying to help an auctioneer put cars on his web site as soon as he gets them, he (and/or his guys) must be able to do the data entry. -- Pierre Marceau pierremarceau@hotmail.com Edit your PHP and HTML files right from your browser. Try EditPHP . . . http://www.skynet.ca/~pierre/ It's free! ________________________________________________

Installation of PHP3 under WINDOWS

--------------F9C900EAFAFF67B96CC2A521 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all beginners with PHP, (I am an absolute beginner, I started with PHP five days ago!) if you have problems to start PHP3 unter WINDOWS98 & APACHE like me, please have a look to your REGISTRY with "regedit" (be carefully!): HKEY_CLASSES_ROOT\.php3\phpfile\shell\command i.e. c:\php3\php.exe -q %1 You should see in the path the windows own backslashes! It have taken me three days to find out, that the installation routine had used in the registry

location.replace(url)

After a user submits a form, I want to prevent them from using the back button to revisit the form and = trying to correct their work. location.replace will replace the page in the history list with the next = page, but how do I use location.replace in the ACTION attribute of my = form? Thanks. Tim

Re: [PHP3] ODBC Num Rows

------=_NextPart_000_052C_01BFD9FB.46D8DF60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Jordan! Actually, there is a way...depending on the database. You can try a = Select Count() statement. They go something like this: SELECT Count(UserID) AS TotalUsers FROM UserTable; The result should be a single number giving you the total count of = users in the UserTable. Change it to narrow your results as you will = with Where clauses. <example> // This one gets the count $Query =3D "Select

ODBC Num Rows

------=_NextPart_000_010A_01BFD9FC.65E29F80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there any other way to get the number of rows that a query returns = other that the odbc_num_rows() function? That function is returning -1 = just like the manual says it could after a SELECT statement. I am hoping that there is another way to get the number other than going = through every row first and counting them. jordan ------=_NextPart_000_010A_01BFD9FC.65E29F80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Enco

Re: [PHP3] Re: Communicating with FileMaker?

Hi! >I guess that's the answer to my question and there is no other way of >doing this. Alas, not at the moment. >No to the final question - is it hard to do or is it as easy as with >MySQL? ;) It's all just as hard/easy. The only difference, from a code standpoint, is slightly different calls. odbc_do rather than mysql_query, etc, etc...no big deal. It's a bit of a switch if you're used to mysql_* calls because they use slightly different syntax. <example> mysql_query (query_string, connection) while odbc uses odbc_do(connection, query_string). </example> Th

RE: [PHP-GENERAL] PHP Ticketing system

> When you say ticketing system...what exactly do you mean? Like a bug tracking system. Chris

Re: Communicating with FileMaker?

>just use ODBC. I guess that's the answer to my question and there is no other way of doing this. No to the final question - is it hard to do or is it as easy as with MySQL? ;) I will try and se how it goes. Thanks. /Magnus

RE: [PHP3] Slash code

You know there is a PHP version of Slash, right? http://phplib.netuse.de/download/index.php3 -----Original Message----- From: Peter Smith [mailto:hoxis@hotmail.com] Sent: Sunday, June 18, 2000 8:54 PM To: php3@lists.php.net Subject: [PHP3] Slash code Hi guys, I'm looking for a PHP message board or forum with the look of Slashdot. Like you know, Slashdot is Perl based. The problem is that I hate Perl, so I'm trying to find any code like Slash but in PHP. Anyone? Best regards, Peter Smith ________________________________________________________________________ G