Re: [PHP-DB] Passing form values with quotes, to itself

2002-02-14 Thread Faye Keesic
Hi - I actually got this to work for me - if you remember, I wasn't having problems writing values w/ double or single quotes to the database - it was passing the form values from page to page, inside text boxes, etc. What I had to do was use: Then if a user editted a field, clicked a button to

RE: [PHP-DB] Passing form values with quotes, to itself

2002-02-14 Thread Peter Lovatt
Hi I spent ages trying to get it to work. Echoing the " always closes the text area in an input box, so any data after the quotes isn't displayed. Its fundamental to the HTML, so adding slashes is irrelevant. What I did in the end was to swap double quotes " for two single quotes '' using ereg_

RE: [PHP-DB] Disable Right click w/ php?

2002-02-14 Thread Peter Lovatt
Hi I don't think it is possible without javascript, and it does not always work with javascript. Anybody with any real knowledge can bypass it anyway simply by saving the page and opening it in a text editor. So Javascript will stop casual right clickers, and the others will do it anyway, if the

Re: [PHP-DB] Disable Right click w/ php?

2002-02-14 Thread Richard Crawford
There is no way to do this in PHP. None. None at all. It simply cannot be done. Right-clicking is handled by the browser client only, along with things like the back button, etc. If you could have a server-side scripting language make changes in how the browser works, you'd be in some serious

Re: [PHP-DB] Disable Right click w/ php?

2002-02-14 Thread William Fong
I could wget these files and stick them in MySQL to organize ( had to make this a legit post in php/db )... vi them and dd out the javascript lines. There is no point in protecting html... -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7

[PHP-DB] MySQL gets blind!

2002-02-14 Thread João Verde
Hi! On a site I'm developing I need to conduct boolean searches. I use a piece of code I found on: http://www.evolt.org/article/comment/18/15665/ and I've got to say it works really well. The problem is I cannot search for one specific word because, even though the word exists on several reco

[PHP-DB] inserting a bitmap into an Image

2002-02-14 Thread Leotta, Natalie (NCI/IMS)
Does anyone know how to put a bitmap into an Image? I need to have a filled circle in a graph. This shouldn't be a problem except we have an older version of GD (and our network guy is overworked so it would take a few weeks to get a newer version installed) and the graph has gridlines. If I ma

RE: [PHP-DB] Deleting from a select list ? :-(

2002-02-14 Thread Rick Emery
Dave, First, you need a "SELECT" tags. print ""; $deloptions_sql = "select * from $tbn2"; $delresult = mysql_query($deloptions_sql, $con) or die("error:".mysql_error()); while ($listdelrows = mysql_fetch_array($delresult) ){ $name2 = $listdelrows[name]; $id2 = $listdelrows[id]

RE: [PHP-DB] Form Validation

2002-02-14 Thread Gurhan Ozen
addslashes(), stripslashes(), strip_tags(), nl2br() , htmlspecialchars() etc. etc ... check PHP online documentation for more info on them.. But even without those functions, the data inserted thru form wouldn't crash MySQL .. The worst that can happen is if the data has quotes or wrong format et

[PHP-DB] PHP/MySQL to DBF

2002-02-14 Thread Daniel Barton
Hello all, I'm looking for a PHP tool that would take the results of a MySQL query and send them to a client browser in DBF format. I wrote an output tool that sends a query result as CSV to the browser, but DBFs are much more handy in this particular case. Does this exist? I

RE: [PHP-DB] Form Validation

2002-02-14 Thread Rick Emery
addslashes() stripslashes() Your question is vague... -Original Message- From: jas [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Form Validation Anyone know of a good function to strip characters and stuff that would cau

RE: [PHP-DB] Disable Right click w/ php?

2002-02-14 Thread Miles Thompson
At a philosophical level, I don't think this should be done -- I don't want people messing with my browser settings, because sure as shooting they will not be restored when I leave the site. What is so precious in the HTML that one can't view the source? Miles At 12:12 PM 2/14/2002 -0600, Ric

[PHP-DB] Form Validation

2002-02-14 Thread jas
Anyone know of a good function to strip characters and stuff that would cause mysql to crash from forms? Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fwd: php-db Digest 11 Feb 2002 20:12:53 -0000 Issue 1046

2002-02-14 Thread DL Neil
Neil, > My 2 cents : > > In fact Todd has also been spouting ( moaning? ) on the Windows/PHP > list too ;-) > > Certainly, parsing Word docs is not necessarily a PHP-DB issue, but an > interesting problem or hack nonetheless. > IMHO M$ have set themselves up for 'illegal' hacking of their file f

RE: [PHP-DB] Time Question

2002-02-14 Thread Jacob Wyke
Use: date("n/j/Y g:i:s A"); If you need any more help on what the letters mean, or you need to change the layout visit: http://www.php.net/manual/en/function.date.php keTTle_drum. >>Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a >>mssql7.0 backend. Th

Re: [PHP-DB] Time Question

2002-02-14 Thread Lerp
Thx Rick :) Appreciate your help :) Cheers, Joe "Rick Emery" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > $t = date("m/d/Y h:i:s A", gettimeofday()); > print $t; > ?> > -Original Message- > From: Lerp [mailto:[EMAIL PROTECTED]] > Sent: Thursday, F

RE: [PHP-DB] Time Question

2002-02-14 Thread Rick Emery
CORRECTION: -- C:\>php -f a.php 02/14/2002 12:49:50 PM -Original Message- From: Lerp [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:45 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Time Question Hi there. Got a bit of a snag. I'm migrating an ASP app to P

RE: [PHP-DB] Time Question

2002-02-14 Thread Rick Emery
-Original Message- From: Lerp [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:45 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Time Question Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a mssql7.0 backend. The snag is this, I have a 'starttime' field

Re: [PHP-DB] A while loop prob ?

2002-02-14 Thread Jim Lucas [php]
Try this if ($submit) { if($search == "") { $error1 = "No Records found. Please use at least 1 character in search box"; } else { $srchsql = "select * from $tbn where name like \"%$search%\" "; $srchresult = mysql_query($srchsql, $con); $name =$srchrow[

[PHP-DB] Time Question

2002-02-14 Thread Lerp
Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a mssql7.0 backend. The snag is this, I have a 'starttime' field in my db using the 'datetime' format ... looks like this 2/14/2002 12:21:28 PM. Unfortuanely, I'm unable to convert this field to type integer at the present tim

Re: [PHP-DB] Passing form values with quotes, to itself

2002-02-14 Thread Jim Lucas [php]
it is called magic quotes and it can be enabled through the php.ini file. Jim Lucas - Original Message - From: "William Fong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 10:36 AM Subject: Re: [PHP-DB] Passing form values with quotes, to itself > Doesn'

Re: [PHP-DB] Disable Right click w/ php?

2002-02-14 Thread Andrey Hristov
No way. PHP is server-side. Javascript is mostly clientside. Best regards, Andrey Hristov - Original Message - From: "jas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 8:17 AM Subject: [PHP-DB] Disable Right click w/ php? > I have been looking on php.ne

RE: [PHP-DB] Disable Right click w/ php?

2002-02-14 Thread Rick Emery
You can't do this using PHP, because PHP is server-side. You will need JavaScript. -Original Message- From: jas [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:18 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Disable Right click w/ php? I have been looking on php.net for a

[PHP-DB] Disable Right click w/ php?

2002-02-14 Thread jas
I have been looking on php.net for a function to disallow people to right click to view source... anyone have a good idea of how to accomplish this without using java-script? Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/uns

Re: [PHP-DB] Deleting from a select list ? :-(

2002-02-14 Thread biorn
Is all of this code on one page or do you have the select part on a form on one page and the delete on another page? If this is all on one page, then it would only delete the last record because that was the last value of $id2 after the loop to fill the drop down. In order to select a certai

[PHP-DB] Deleting from a select list ? :-(

2002-02-14 Thread Dave Carrera
Hi All, I have this code creating a list in a select box. All works ok, I get my list BUT and a NIG BUT. When I select an item to delete it only ever deletes from the last record to the top. Err why ? I think all my code is in the right order but obviously not. Can anyone throw some light

Re: [PHP-DB] counting multiple columns based on different values

2002-02-14 Thread Peter Vervoorn
OK, this time tested :) SELECT Clients.ClientName, Ratings.Status, Count(*) FROM Clients LEFT JOIN Ratings ON Clients.ID = Ratings.ClientID GROUP BY ClientName, Ratings.Status HAVING Ratings.Status = 2 OR Ratings.Status = 3 regards, Peter Software Engineer / Trainer Vervoorn IT - Original M

Re: [PHP-DB] Logging visits using a database

2002-02-14 Thread Shooter
ummm i am currently using http://www.ezboo.com/ to look @ how it comes out hea to http://lollan.qldgamers.com/ I like it. Shooter - Original Message - From: Peter Lovatt <[EMAIL PROTECTED]> To: Jason Wong <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 9:05 PM

[PHP-DB] Re: How To Upload

2002-02-14 Thread Jonathan Underfoot
You can use the GD module in PHP to accept and resize the images. Currently (do to copyright restrictions) the GD libraries ONLY work with .jpg and .png graphics. This form will only allow you to upload one image at a time, so you'd have to 1) Make a script to accept and resize the files and the

RE: [PHP-DB] Logging visits using a database

2002-02-14 Thread Peter Lovatt
> On Thursday 14 February 2002 07:29, Peter Lovatt wrote: > > Hi > > > > Excuse the cross post > > > > I am thinking about building a logging tool to do visit > analysis using SQL, > > rather than doing log file analysis. > > > > The aim is to analyse requests for dynamic pages called via php > a

Re: [PHP-DB] counting multiple columns based on different values

2002-02-14 Thread DL Neil
John, > I'm gonna go out on a limb and guess that I'm missing > something obvious (and easy) because this sure seems > like it should be able to be done. > > Here's the issue: I need to pull the client name and > ID out of one table and then, count the records in a > different table (called ratin

Re: [PHP-DB] Logging visits using a database

2002-02-14 Thread Jason Wong
On Thursday 14 February 2002 07:29, Peter Lovatt wrote: > Hi > > Excuse the cross post > > I am thinking about building a logging tool to do visit analysis using SQL, > rather than doing log file analysis. > > The aim is to analyse requests for dynamic pages called via php as well as > static page

RE: [PHP-DB] RE: Logging visits using a database

2002-02-14 Thread Beau Lebens
i think i saw an article on phpbuilder.com regarding how to set up a good thing for the path taken - something along the lines of storing IP vs time vs page hit, then a good method for selecting from the db that shows the path of the visitor HTH beau // -Original Message- // From: Peter

Re: [PHP-DB] counting multiple columns based on different values

2002-02-14 Thread Peter Vervoorn
This should do the trick (untested): SELECT ClientName, Count(*) FROM Clients LEFT JOIN Ratings ON Clients.ID = Ratings.ClientID GROUP BY ClientName HAVING Ratings.Status = 2 OR Ratings.Status = 3 regards, Peter Software Engineer / Trainer Vervoorn IT - Original Message - From: "John H

[PHP-DB] RE: Logging visits using a database

2002-02-14 Thread Peter Lovatt
Thanks. Analog only does basic 'what files have people viewed?' type reports, which offers some of the insight I am looking for, but not the path through the site etc. Also the output confuses non techies. Any other thouhts? TIA Peter --- Excellence i