PHP :: Best Solution For Testing PHP/MySQL Offline?

Can Php And Mysql Process Stored Form Data Created Offline?
A customer of mine has given me a task that has me stumped...

My customer meets with his new clients away from his office with a laptop. At his office he is running a redhat server, apache, php, mysql....the usual stuff. His laptop has windows xp.

When he meets with the new client, he wants to fill in a from and have the data stored on his laptop. After returning to the office he would like to upload via his web app (php/mysql based) the new client data into his database. Basically:

fill in form offline ---> return to office and connect to web app ---> upload and review stored form data ---> process new client data into database

Where do I begin? How do your create the form? How would you process the form? What's the simplest way to process the data into the database? I'm sure I'm missing a few questions here.

Passing PHP Arrays To Mysql Best Solution
I am relatively new to PHP and until now I have only needed to use relatively simple php/mysql solutions.

I am working on a problem where I need to store CD information (Artist Name, Album Name, Track Names, Catalog Number)

I am working on a solution with two tables "album" and "tracks" and I am using the catalog number as a key to link the two.

The problem I am having is coming up with the best way to populate the tracks table as there are several tracks for each release. I am assuming that an array would be the correct way and maybe a dynamic form to input the tracks where you decide the number you need to add and this then creates a form with "n" input boxes?

Looking For PHP Solution To Adding Content To MySQL Database
I have recently used aedpro to quickly make pages for my client to be
able to /add/edit/delete/view all/ content in their MySQL database.
Though these pages work, they are limited to an all-or-nothing type
view within their returned record pages. You can't sort the edit or
delete pages to find your information quickly/easily, you have to
scroll through all the records to find your record of interest. The
database contains over 2000 horses, so scrolling to find a particular
horse takes too long. Or, when trying to edit a horse's record, or
group of records, you have to scroll to find the record(s) instead of
being able to type in the record's horseID number and then go just to
that record or group of records to edit.

Do any of you gurus out there know of a PHP based MySQL database
management system that you have used that is both flexible in its use
and easy to install? I have Googled, but nothing is coming up but CMS
type systems, which we don't need. Perhaps I am calling this something
it is not, thus I can't find it. Any help or direction appreciated.

MySql Not Enable From IIS But Worksfrom Command Line -- With Partial Solution
Problem: MySQL library bound ONLY when PHP is run from the
command prompt, and NOT when PHP is run from an IIS Web page.
(Error indicates that mysql_connect is an unknown function.)
Not only does the library bind from the command prompt but data is
retrieved using the EXACT same program file that fails under IIS....

Testing Mysql Query
Basically I am using PHP 5.1.2 with Apache 2.0.5 on a FreeBSD 5.4 box
with Mysql 4.1.1 running.

I am attempting to write information to a Mysql table called Jabber. I
can connect successfully, query data, and write data pretty much
without problem. My problem is this.

I am trying to do some duplicate checking on this table so I query the
dbase with the following:

/* Searching for username in Authreg database and assiging it to
variable */
$query1 = "SELECT * FROM `$table` WHERE username='$username'";
$query1_results = mysql_query($query1) or die("Query Failed");
$existing = mysql_result($query1_results, 0,0);

Problem is this.

When a user already exsits in database I have a conditional if
statement that looks like such:

/* Conditional statement that searches for exsiting username */
if ($username == $existing) {
die ("Please select a unique username");
} else {
....
}

And it errorr out telling me to, "Please select a unique username" as
stated above.

When I am adding a new user to the database above I get the following
error in my logs or in the browser depending on what --display-errors=
is set to in my php.ini.:

Warning: mysql_result() [function.mysql-result]: Unable to jump to row
0 on MySQL result index 4 in /usr/local/www/sfg/add_jabber/add_test.php
on line 38

I know this error is happening as a result of the following line when
the user is not present in the database:

$existing = mysql_result($query1_results, 0,0);

What Is Better - One Field Or Eight - Mysql Bit Testing
I have to store up to eight boolean bits of information about an item
in my database.

e.g.

[ ] with restaurant
[ ] drive-through facility
[ ] yellow windows
[ ] wifi factilities
etc...

There are three ways of storing this information in my mysql database
A. add eight fields (tiny integer)
B. add one tiny integer and create a function in PHP that can translate
the number stored into a eight boolean values (the bits)
C. create a table which list
ItemID
Associated characteristics
In C, you will only list the characteristics that are true for the item
listed.

Option B is the most efficient in MySql, but would you recommend it
when creating a PHP website. The problem is that the user needs to
enter them with a nice webform, etc...

Testing If A Mysql Table Exists
Is there a simple way to test if a mysql table exists?
JUST One line !

Testing MySQL And Preventing String From Crashing It.
I read somewhere that there are some tricks that a hacker can use to break
into the db table.
But how can i test against that? Is there a function to convert all strings
to 'safe' strings?

Can errors occur with integers or string only?

My main worry is for legitimate users that wish to save something that might
cause an error.

Can apostrophes, (" and ' ), cause errors? can a user wanting to save a
legitimate SQL query highjack my queries?

Pear All Packages For Offline Use
I need pear for an offline laptop so the standard install method is no
possible.
how to install pear on the laptop, does anyone
have a zip of all pear packages that I can download ?

Offline Update To Database
We have a web page where they can enter sales call information. They want to be able to enter this information at any time, while in the car, at home etc. What would be the best way to have information entered offline, then when they get connected to our intranet it would sync or upload all their data ?

I thought about creating some type of web page, that would write the information out to a file. Then they would have a "sync" button or something on the intranet web page that would read this file in.

Contingency For Form Input When Db Is Offline
My mysql server and web server are on different machines. Potentially, the db server may be offline, but requests to add to the db may still happen. I would like to develop a contingency plan so when the php script can't connect to the db, it writes the form data in a text file and sends someone an email, with a link to process the information later.

My problem is there are textarea boxes on the form, so potentially the data could contain hard returns and such, which will throw off a script that would use file() and parse each line for a separate query. What other options do I have?

Online Or Offline Server Report
I am going to be making a script that reports whether or not a server is online or offline. I have a download page, and the page has six different hosts for a file. I wanted to make a small script that would report whether the server is online or offline, so you know which one to chose.

I am unsure as to what will check and see if its on or off. Is there a boolean statement that will connect to a page and tell if you if it is there or not? DNS is not enough, it has to actually make a connection with the server.

Combatting Mass Downloads For Offline Use
We run a busy site that is powered by PHP and MySql, we provide a lot of free training content and have over 35,000 files totalling over 500mb. We are getting mass downloaded far too often and our bandwidth costs are crippling us. Does anyone know a way to stop this mass download of our site.

Using PHP we check the browser type against our list of banned browsers and don't provide the links if a banned browser is being used - this has helped. However the banned browser list grows everyday and a new offline browser becomes available nearly everyday and not only that most of them allow you to spoof the browser type anyway.

We are thinking of introducing a session based site that monitors timestamps against session id's and bans users that download too quickly, does anyone have any thoughts on this?

Using PHP Offline To Manipulate Text Files
I need to create an application that will do fairly simple text manipulation
on 20,000 files in text format (html files). The files exist both on my
Windows machine and on a FreeBSD server. I prefer to do the manipulation on
my machine where it's easier to create backup copies, recover from
programming errors and so on, then upload the files to the server. All I'm
doing is extracting certain elements from each file and creating a different
file with the same content that will look better. I could do this in
FrontPage (or even Notepad) if I didn't have 20,000 files, so I need to
write an application that go through each file in a directory, open it,
locate the relevant text elements and create a new file that has these text
elements in an appropriate format.

I'm comfortable that I can write an application like this in PHP, even
though I do not have PHP installed on my computer, which is a Windows box
and is not being used as a server. Does this make sense? Can I install and
use PHP for this purpose without lots of server-related baggage?

User Status Online/Offline?
I want to know how to check that user is online or offline by Php.If
he visit pages then he is online, if he not accessed page he is
offline. How to handle this is in PHP...I set session of each user......

Headers Already Sent Problem Online, But Not Offline
I have a problem where when I run the PHP code offline, there are no errors
produced and the code runs as expected. However when I uploaded the same
script and run it, it says the headers have already been sent.

The script is for a "downloader" type script, where the user clicks on a
file link (to the PHP script) using $_GET to pass the selected files ID to
the script, and the information about the file is read out from a database,
also updating a field in the database on how many times a file has been
accessed, and then produces the browsers "save as" dialog box according to
which file type was accessed.

Below is the code, if anyone can help how to sort this problem out. I put
line numbers in to show where the errors occur, along with the error
report.

// Connect (log on) to the database
$connection = @mysql_connect("localhost", "xxx", "xxx");

mysql_select_db($DatabaseName);

// Display database entries
$sql = mysql_query("SELECT * FROM $TableName WHERE f_id='$FileID'");

$FileInfo = mysql_fetch_row($sql); <-- Line 22
// Read from the array the files URL
$FileURL = 'http://'.$FileInfo[0];
// Read from the array the files name
$FileName = $FileInfo[1];
// Read file size from the database
// Problem using the built-in function to read file size of stated file
$FileSize = $FileInfo[2];
// Write code for number of accesses a file has had
$FileAccessed = $FileInfo[3];

$FileAccessed = $FileAccessed + 1;

$sql = ("UPDATE $TableName SET f_accessed=$FileAccessed WHERE
f_id='$FileID'");
$result = @mysql_query($sql, $connection);

$FileType = substr($FileID, 0, 3);

MYSQL_CLOSE();

//Screensavers
if ($FileType == 'scr')
{
// We'll be outputting a screensaver
header('Content-type: application/octet-stream'); <-- Line 46
// Filename
header("Content-Disposition: attachment; filename=$FileName;"); <-- Line48
header('Content-Transfer-Encoding: binary'); <-- Line 49
// Calculate file size
header('Content-Length: '.$FileSize); <-- Line 51
// The location of the file
readfile($FileURL); <-- Line 53
}

Errors:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in /home/php/downloader.php on line 22

Warning: Cannot modify header information - headers already sent by (output
started at /home/php/downloader.php:22) in /home/php/downloader.php on line
46

Warning: Cannot modify header information - headers already sent by (output
started at /home/php/downloader.php:22) in /home/php/downloader.php on line
48

Warning: Cannot modify header information - headers already sent by (output
started at /home/php/downloader.php:22) in /home/php/downloader.php on line
49

Warning: Cannot modify header information - headers already sent by (output
started at /home/php/downloader.php:22) in /home/php/downloader.php on line
51

Warning: readfile(http://): failed to open stream: Success in
/home/php/downloader.php on line 53

Offline Php Documentation With User Notes
I want have documentation in form like in subject.
I think: get from cvs, run makefile target and zip all html files (i want use it id phpeclipse plugin).
In php documentation faq i found that transformation from xml form is time consuming.
Have you any experience in php doc from php user point of view?

How To Detect User Online/offline?
how to detect user online/offline?
by storing user login status inside mysql?
wat if user go offline? how php know when user get offline or close the browser?

Offline Function, Variables With No Data In Them
I've been trying to figure this out for a while, the function returns a result but its not the result l want. I've tried to debug the function and it seems that $groupid and $status aren't being set as when l echo'ed them out they both had no data in them.

If l set the variables data inside the function the code executes perfectly, so l cant understand why it isnt working.

What l need the code to do is check to see if the member logging in is an admin (group id or a root admin (group id 9) and if the game is offline (status 1) to only only admin and root admin. However is the game is offline but status is set to 2, then only root admin can login. If the game is offline, normal members are not allowed to login.

Clearance is there so l can check to see whether or not to allow them pass or stop them from logging in. Code:

To Change Online Status To Offline
If a user logged in ,his status should become online and when user close his brower at that moment,status of the user should change to offline.

Do People Develop Live On The Server Or Offline?
I have been developing on our server in a 'spare' domain up to now which makes for a lot of time spent uploading/testing changes as I go along. I was wondering do the majority of PHP/MySQL folks do this or do do you set everything up on your own machines?
I have seen the downloads available and was wondering is it straightforward to get going offline. As soon as I had everything runnung on our server, I stuck to that.

Pear Pkgs For Offline WinXP Machine
I've got one computer in a remote-location without Internet access and
I'd like to get some Pear Pkgs installed on it.

What happens during the "pear install" process ?
Is an Inet connection absolutely neccessary or could I get the modules
first, and install on this offline machine ?
If I remember right, there's a tar process, even for WinXP.

Adobe, Macromedia (view .PHP Pages Offline)
Is there some Adobe or Macromedia program that allows you to view .PHP pages offline?

Email Message With HTML And Image To Be Viewable Offline
How do you insert an image file, jpg, into an email created using php and the mail() function. I would like the server to send the message with out needing to link back to it for the image file.

Basically, send an HTML file with a jpg that would be viewable offline in a users email.

I have successfully sent an email message as HTML with the jpg linking back to the server, now how do I imbed the image?

Redirect Page On Remote Web Host When Local Server Is Offline
Hope some one can help . I have my web site hosted on powweb (my remote web host)and I want a user to be redirected when they access my local server through a link on my remote web site to another page on my remote web site when my local server is offline.

Need A Php Solution
I understand my question might not necessarily be a issue specific
for PHP. However since my current development is conducted with
PHP so I definitely need a PHP solution for it. Here is the situation:

1. A Login form page for user to keyin username/password.
2. After user input correct login info a small window will popup
and the parent window (the login form page) still stay unchanged.
3. If user click "accept" on the popup window then the parent window
changed.

Step 3 is not a big issue for me. But step 2 is a big headaque.

PGP Solution
I would like to be able to take the data submitted to a form, encrypt it using a specified PGP key and email it to a specified recipient. All in PGP.

Looking For An ILS Solution
I'm hoping someone knows of an Integrated Library System that
uses PostgreSQL.

The group I'm working for had an old system and decided to upgrade.
Previously, they were using PHP, MySQL and Koha (www.koha.org) to run
their library interface. The new system they have is PostgreSQL, which
means I cannot use Koha anymore. Converting the MySQL dump has been
hard enough. The Postgres version is 7, so it seems that exporting the
dump with phpMyAdmin does not want to work. But thats a different
problem all together.

So I need to find a replacement for Koha, all I've seem to come up with
is a list of ILSs (http://www.anctil.org/users/eric/oss4ils.html) that
either use MySQL, or only come in a completely different language. If
anyone has any ideas or could point me in the right direction

Help Require For Map Solution
Here is a problem which i'm facing. Now i'm working on a site in which a user will provide the pincode(zipcode) of two positions and a line will
be draw on that map between the two pincodes(zipcodes). Now the solution which i found requires a databse storing the details of longitutde and latitude for
each pincode(zipcode). Also we do need to provide the latitudinal and longitudinal range of that particular map. Now i want to ask you friends if anybody has got any better solution which is more effective.

Cant Fiugre Out The Solution....
PHP and MYSQL and have been working on a form that
when it is submitted stores the information into a mysql database.
The main problem is that i'm trying to finish up my script for almost
a week now and I still cant get it right.
here is the code

<?php

include ("ES_includes/appconst.inc.php") ;
// Ceck of begin datum juist is
if (!checkdate ($_POST['maand_van'],$_POST['dag_van'],$_POST['jaar_van'])){
echo "De begin datum die u hebt opgegeven is ontjuist "
..$_POST['dag_van']. "/" .$_POST['maand_van']. "/" .$_POST['jaar_van'].
". ";
}
else
{
//check of begin datum reeds in het database staat
$datum= $_POST['jaar_van']."-".$_POST['maand_van']."-".$_POST['dag_van'];
$db = mysql_connect("$dbHost", "$dbUser","$dbPwd");
mysql_select_db($dbName,$db);
$sql_check = "SELECT * FROM verlof WHERE
gebruikersID='$_POST['gebruikersID']' AND datum='$datum'";
$check = mysql_query($sql_check,$db);

if (mysql_num_rows($check) != 0){
echo "Deze datums staan reeds in het databse op uw naam.
";
}
else
{
$sql = "INSERT INTO verlof (gebruikersID, datum, voormiddag,
namiddag, opm_aanvrager) VALUES
('$_POST['gebruikersID']','$datum','$_POST['voormiddag']','$_POST['namiddag']','$_POST['opm_aanvrager']')";
$result = mysql_query($sql);
echo "Uw verlof aanvraag is aangevraagd.
";
}
}
echo " <input type=button value="Terug"
onClick="history.go(-1)"> ";

$datum_van= $_POST['dag_van']."/".$_POST['maand_van']."/".$_POST['jaar_van'];
$datum_tot= $_POST['dag_tot']."/".$_POST['maand_tot']."/".$_POST['jaar_tot'];

$day1="Monday";
$day2="Tuesday";
$day3="Wednesday";
$day4="Thursday";
$day5="Friday";

$mydate=$datum_van;
$newsplit = explode("/", $mydate);
$dat1=mktime(0,0,0,$newsplit[1],$newsplit[0],$newsplit[2]);

$mydate=$datum_tot;
$newsplit = explode("/", $mydate);
$dat2=mktime(0,0,0,$newsplit[1],$newsplit[0],$newsplit[2]);...

What's The BEST PHP Template Solution?
What's the BEST PHP Template solution?

Pagination Solution
how to createa pagination just like the one in vBulletin. Yesterday, I asked a question about making sure that I get 10 pages per page, even though some of the things get deleted. I went back to work on that right now, and I can't imagine how easy it is - it's logical too!! I present my solution for those who MIGHT want to know. PHP Code:

PHP EAI Solution? (vs BizTalk)
I'm tasked with a project where I am responsible for designing and
implementing a solution to an enterprise application integration problem.
This is an e-commerce site which needs to exchange messages with multiple
disparate systems on a frequent basis.

I'm looking for an existing PHP (I would consider other open source)
solutions for consideration.

The features I'd like would be thus:
1. Configurable adapters for connecting to data sources (ftp, soap, file,
db, etc.)
2. Modular pipelining for transforming data and encapsulating business
rules.
3. Both scheduled and event triggered message exchange.
4. Robust logging and notification when failures occur.

There is some internal pressure within the organization to utilize BizTalk
for this problem, but I feel this would be overkill in both capital and
labor costs.

If I can make a convincing argument for linux/apache/php, I can overcome the
pressure to utilize Microsoft and BizTalk.

I'd appreciate being pointed in the direction of any existing php/opensource
framework for this. Having to design and program the solution from scratch
in PHP would be less desirable, but may be possible.

Looking For A Php Application/solution..
Knowing that there are hundreds of php applications and solutions out there,
and I don't want to re invent the wheel, I am looking for something in php
that will provide a web based solution for me to add/edit/delete records in
a MySQL database/table that must include one BLOB (JPEG) image field.

It's a PEOPLE application that has details on the people that includes a
picture. So, must be able to add(upload) or delete a JPEG image as a BLOB
field to the Table.

(the Table already exists with some 20+ records and most if not all have a
BLOB {jpeg} field included.)

Perhaps there's something out there already that will simply read and
examine an existing table and fields, then generate a simple data
entry/update type page.

Or maybe someone else out there has something like this, or knows of
something like this in GPL, open source, or other?

PHP Vs JAVA - Is PHP An Enterprise Solution?
I am commencing a project with a guy - and have just received an email of him saying that the project should be writtin all in Java! Now I code in PHP and was interested in his comments:

However there are many things to consider. First we have to standardise on one language to code in. It should be Java and only Java. All professional organisations use Java because it is the language of the network and the internet. Its scalable, reusable, object oriented and extremely powerful.

There is no other means if you want to get this right first time and professionally. There are all too many people out there using languages like Perl and PHP. These are not what we call "Enterprise" solutions

I would like your thoughts on this as I belive as many others that PHP is indeed the language of e-commerce and the Internet.

Also I heard Microsoft was scaling out Java cause of legal action and SUN might not now be able to continue its production due to losing its biggest client.

Timestamp Or Microtime? Which Is The Better Solution?
I have always used timestamp but see alot of microtime in code I read.

Is there a good reason to use one solution vs. the other?

PHP Solution To ASP Include Function
I've been offering UNIX based hosting for awhile, but for a prospective client I wish to set up a system where he can update a section of his homepage without having access to the whole webpage.

I wish to show him how to create an MSWindows.doc that he can export as a "Web Page", then FTP it to a special directory. I wish to then have the actual home page access this other page as an "include", placing his data on the home page in its correct place. This keeps him from wrecking the homepage. On a Windows server, I would put an include on the HTML page leading to the content page as in:



but this solution will not work on a UNIX system.

On Line Store Solution
I've been looking for "open-source-on-line-stores-php-apache-mysql
powered solutions", and I found mainly two:

osCommerce
Zencart

I'm just beginning so I've to choose one of them to give it a try...
Which one you would opt for?

Looking For Visual Php Development Solution
I have recently been implementing php code in some web pages and am
now looking for a more visual oriented php development environment
because for example creating php/html forms by hand for the x'th time
is not exactly my idea of working efficiently. (Unlike some guys i
work with who seem to think this is an extremely cool working method.
:-/) I'm looking for something with an interface like delphi or vb,
and some of the more visual GUI based web scripting systems out there.
Something where i can click on a web site item, get to the code part
and then work on the code, or maybe first grab some prefab code by
using a template or some kind of code library. I'm sure someone has
implemented such a thing for php, but so far i haven't been able to
locate it.

PHP Diary/Journal Solution
I've been messing around with my demo Blog page (using the script I
released as open source).

For those that are interested, feel free to visit the URLs below, and
take a copy of the blog script to try for yourself.

BLOG Demo Site
http://www.pluggedout.com/blog

BLOG Development Forum
http://www.pluggedout.com/developme...ewforum.php?f=5

The main reason for writing Blog was to give something back to the
open source community - it's a pretty good example of good programming
style so should be helpful to newbies. So far there are more instances
of the code than I ever imagined there would be, and people are
modifying it to an extent I never though they would either :)

At some point soon I'll try and find time to do the "multiblog"
solution I've been talking about doing for so long. I have the beta
code to do a multi-user version of Blog - it's just a case of wrapping
it up nicely for others to use...

PHP Pattern Matching - Is There A Better Solution?
One of my weaknesses has always been pattern matching. Something I
definitely need to study up on and maybe you guys can give me a pointer
here.

I'm looking to remove all of this code and just use pattern matching to
determine if the proper amount of numeric characters has been met. Here is
the function I've already done. Any help you can give in a pattern matching
solution would be much appreciated and very educational.

//the $area option is for determining if the user need (or need not) type in
their area code.

function check_phone($phone,$area='y'){
if($area=='y'){
$min=10;
} else {
$min=7;
}

//is there a more direct approach to just count the amount of numbers in
the string by pattern matching?
$phone=str_replace('-','',$phone);
$phone=str_replace('(','',$phone);
$phone=str_replace(')','',$phone);
$phone=str_replace(' ','',$phone);

if(!preg_match('/[d]{'.$min.',}/',$phone)){
return(FALSE);
} else {
return(TRUE);
}
}

Messy Form Solution
My web-form process input and sends it to me as mail. Fine. But I also would
love to have this input put onto a PDF-document which will be generated on
the fly during post. The PDF will be saved on my server AND mailed to
myself.
I thought that maybe it is possible to get the posted form input on a
csv-file on my web-server (I don't have MySQL). And then, during the process
get this csv data reorganised and to appear organised on a already nearly
finished PDF with prefixed header and footer. The document is mailed to me
and visible in the user window.
I have not invented the power and have to ask: is this possible, anyone who
knows if such a funcationality already exist?

Seeking Mod_rewrite Solution
I have a people-networking type site in which each user has their own
profile page, with their user id encoded. So, for example, the web
address of their page might look like
"www.example.com/my_profile.php?user_id=fdjkhfh2489298hf298h3s0dhfx j".
I want the users to be able to choose their own web address that would
look like "www.example.com/Joel", and then when they type in that
address, they are automatically redirected to their profile page with
the more complex address.

I believe mod_rewrite is the solution to this?

Reading a little bit about mod_rewrite, I believe the rule I want is
something like the following:

RewriteRule ^/(.*) /redirect_user.php?user_name=$1

So 2 simple questions:
1) does this rule look like what I want?
2) how do I install and hook up the module, and do I write this rule
in the .htaccess file?

Php Display Solution Required
I have a table in mysql with 2 columns.group name and the group parameters.
There is one group name with several group parameters.

I would like to retrieve this from the database such that it will only display one group and the other several parameters in it,for all the diffrent groups.

does anyone know how i can go about this?

Shopping Cart Solution
i'm looking for a shopping cart that is low in cost say under 100$ but is totally customizable. i have about 40 products and i would like it to work with pay pal as well does anyone know of anything?

Solution For Redirect At Page Index
by php which the fast solution for make redirection at homepage ?
Time ago read some solutions, but one most fast because not load
or not make a reload of itself page, not remember
exactly but was a solution more fast...

File Download Solution Tidbit
I struggled with getting file downloads to work in PHP by using various headers. Some earlier posts reported problems with browsers' "save as" dialog box showing the name of the PHP script rather than the file they wanted to download. I was having the same problem until I noticed an example that stripped the path from the filename. The header: PHP Code:

Solution For Preventing Injection Attacks
I have an idea for preventing sql injection attacks, however it would
have to be implemented by the database vendor. Let me know if I am on
the right track, this totally off base, or already implemented
somewhere...

Lets say you could have a format string such as in printf

$format=" SELECT %s FROM %s WHERE id='%s' ";
$fieldname="last_name";
$tablename="personel";
$id="425";

and you could execute a query like

mysql_query_formatted($format, $fieldname, $tablename, $id);

now, the key is that instead of just adding the $fieldname, $tablename,
$id to the $format string and passing it to mysql_query, it would be
passed to the parser as separate strings. The parser should know how
to handle that format. That way, the parser would always know where
the different tables names, field names, and other strings start and
end. So, the problem of injection attacks caused by some one confusing
the parser by entering things like ' and " is gone.

It would be easier on the programmer. There would be no need to worry
about escape characters when passing to this function, the strings
would not have to be escaped.. The parser would no longer have to
guess where the boundaries are. No more worrying about injection
attacks.

does that make sense?

Best Solution For Testing PHP/MySQL Offline?

Can someone please tell me the best solution for testing PHP/MySQL offline on a WindowsME machine please?