PHP - Php 4 To 5 Migration - Need Help!

I am in the process of creating a web page form and related scripts that will take a file (or listing of files) posted in a form and enter the data into a database and then use rsync to move from a staging web server to a production web server. With the current form i have written i am able to do a single file and i am able to handle an entire directory (basically because there is only a single row of data extracted from and inserted into the database that rsync then reads and moves. So, my problem is the form page and related insert into the database. I am not sure what i need to do in the form to be able to allow a developer or qa person to drop a listing of files into it, and have that then get extracted and inserted as individual rows into the database. Does anyone have any thoughts on a good way to do this? Basically taking this snippet

    <form method="post" action="<?php echo $PHP_SELF;?>">
        File Name:<input type="text" size="12" maxlength="12" name="name"><br />
        File to Sync:<input type="text" size="12" maxlength="255" name="dir_path"><br />
        <br />
            <input type="submit" value="submit" name="submit">
    </form>

and re-working it to handle a listing of fully pathed files and then insert that into the db, which is done currently by this snippet

     $conn=mysql_connect (DB_HOST, DB_USER, DB_PASS) or die(mysql_error($conn));
            mysql_select_db(DB_NAME);
            $sql="INSERT INTO fsfiles (name, dir_path)
                VALUES
            ('$_POST[name]','$_POST[dir_path]')";
                if (!mysql_query($sql,$conn))
                    {
                        die('Error: ' . mysql_error());
                    }
                       echo "File: ".$name." added for sync<br />";
            mysql_close($conn);

Any help would be GREATLY appreciated. Thank you in advance

Any pointers would be much appreciated.

I got my PHP app working (not without some great help from this forum) but when I migrated my PHP scripts and MySQL database to my ISP's platform the app fell apart since the web is the destination for this app, I then had to diagnose and fix what happened.

The problem:
On the ISP's platform, a query string  passed unescaped with say a QUOTE in it came in on the subsequent GET ESCAPED. On my platform they arrived UNESCAPED.

Is this a php.ini discrepancy or a version discrepancy between us please?

Thing is I'd like to get the local version working again after all the changes because what worked on one broke on the other, now the other is fixed the one is broken if you get my drift.

Platform / Version variations:
Local implementation is Win7, Apache 2.2.19 / PHP 5.3.6 / MySQL 5.5
ISP is Linux not sure of the Apache version believe it is 2.? PHP 5.2.14 / MySQL Client Api 4.1.22

Any input or links for reading would be appreciated.

Jamie

Hi,

Having completed a site migration this am everything went well aside from issues with logging into and out of our site where two files are used and appear as white pages.

When logging into our site, proc_login.php is used and when logging out proc_logout.php is used.

Both processes result in a white "blank" page instead of the php files forwarding on.

I've no idea about php generally and have been trying my best to find useful and similar information online to attempt to resolve the problem.  I am now stuck.

The site works perfectly on my local web server, and what is really baffling me is the site also works perfectly on Domain B on the exact same server I'm trying to get the site running under as Domain A.  In other words as both Domain A & B are configured on the same host server I'm thinking all the inherited php/apache/mysql settings should be identical (or pretty much thereabouts) and therefore am more confused than ever! 

I simply don't know where to start therefore in resolving this problem.  I've tried looking in the error log file and have also played around with turning on error enabling on those specific php files to try and follow any errors, however the "errors" generated are no different than the ones present on sites where the login/logout process works just fine.

I've hopefully attached both files and if anyone could assist in helping me narrow down my search for a solution I'd be very appreciative.

Thanks.