PHP - Splitting Sign-up Form Over Several Pages

Hello

I am after some help with a concept to allow us to import some data into our database.

I have a PDF which I have OCR'd and now have a word document... I then manually clean up the document to remove spurious characters, that part is fine.

Now, the word document contains an unknown number of lines and an unknown number of records... and within those records an uknown number of fields...

Here is an example of a single record:


Mr G Aldred, 26/11/08, Canvardine Chance, Wolfies Dawn Tilley, KENINE SECRET DESTINY, d, c. Grey & White, KENINE SHADES OF THE NIGHT, d, c. Grey & White, KENINE SILENT WHISPER, b, c. Seal & White, KENINE SOFT KISSES, b, c. Grey & White, KENINE SPIRIT OF THE STORM, d, c. Seal & White KENINE STAR QUALITY, d, c. Seal & White

And I could have multiple records like this, but with different number of names toward the end

So, if I manually put some delimiting character instead of coma's , can I get PHP to read the WHOLE document in, split the document into records and then split those records into subfields to populate a form which I can then automatically submit to my database?

Not sure if that is clear....

Thanks

Hello:

I wanted to see if I can make my password protected pages in my admin area, and the login form "more secure."
I was told I should use MD5 / SALTING / HASHING to do this.

I have tried some online tutorials, but am not understanding it, so I wanted to start from what I have and build upon it>

This is my database table storing the myAdmins data (when I initially insert it into the database):
Code: [Select]
CREATE TABLE `myAdmins` (
  `id` int(4) NOT NULL auto_increment,
  `myUserName` varchar(65) NOT NULL default '',
  `myPassword` varchar(65) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO myAdmins VALUES("1","abc","123");

This is the login form I use:
Code: [Select]
<?php

include('../include/myConn.php');
include('include/myAdminNav.php');

session_start();
session_destroy();

$message="";

$Login=$_POST['Login'];
if($Login){
$myUserName=$_POST['myUserName'];
$myPassword=$_POST['myPassword'];

$result=mysql_query("select * from myAdmins where myUserName='$myUserName' and myPassword='$myPassword'");
if(mysql_num_rows($result)!='0'){
session_register("myUserName");
header("location:a_Home.php");
exit;
}else{
$message="<div class=\"myAdminLoginError\">Incorrect Username or Password</div>";
}

}
?>

<form id="form1" name="form1" method="post" action="<? echo $PHP_SELF; ?>">

<? echo $message; ?>

Username: <input name="myUserName" type="text" id="myUserName" size="40" />
Password: <input name="myPassword" type="password" id="myPassword" size="40" />

<input name="Login" type="submit" id="Login" value="Login" />

</form>



This is the code on top of each page I password protect:
Code: [Select]
<?
session_start();
if(!session_is_registered(myUserName)){
header("location:Login.php");
}
?>

Works well, but can it be "better"??

And, if I am allowing the admin to update his/her username or password, I do it this way:
Code: [Select]
<?php

include('../include/myConn.php');
include('include/myCheckLogin.php');

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$myUserName = mysql_real_escape_string($_POST['myUserName']);
$myPassword = mysql_real_escape_string($_POST['myPassword']);

$sql = "

UPDATE myAdmins
   SET
      myUserName = '$myUserName',
      myPassword = '$myPassword'
  ";
mysql_query($sql) && mysql_affected_rows()

?>

<?php
}

$query=mysql_query("SELECT * FROM myAdmins") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))

{
  $myUserName=$result['myUserName'];
  $myPassword=$result['myPassword'];
}

?>


<form method="post" action="<?php echo $PHP_SELF;?>">
<input type="hidden" name="POSTBACK" value="EDIT">

Username: <input type="text" size="60" maxlength="60" name="myUserName" value="<?php echo $myUserName; ?>">
Password: <input type="password" size="60" maxlength="60" name="myPassword" value="<?php echo $myPassword; ?>">

<input type="submit" value="Submit" />
         
</form>


Should it be "better" .. ??

I don't seem to understand how to "encrypt" all of this to make it "stronger" ..

Ideas? Improvements?

I have an ordering process that consists of 3 pages:

1) Page1: Enter name/address
2) Page2: Based on address, determine availability of products, and let user choose which products, how many, etc.
3) Page3: Enter credit card info to send to the processor

What is the best way to store information fro page 1 to page 2, then from page 2 to page 3? I thought about just using hidden fields. Is this OK? Is there another preferred way?

Thanks!

Following is the form.Now i want to see if submit button is pressed or not.Usually if html had

Code: [Select]
<input type="submit" value="Submit" name = "submit" />
i would simply use
Code: [Select]
<?php
if(isset($_POST['submit']))
?>
But below is the form which has an image as a submit button

Form -
Code: [Select]
<form action="" method="post" id="sendemail">
            <ol>
              <li>
                <label for="name">Name (required)</label>
                <input id="name" name="name" class="text" />
              </li>
              <li>
                <label for="email">Email Address (required)</label>
                <input id="email" name="email" class="text" />
              </li>
              <li>
                <label for="email">Phone number</label>
                <input id="phone" name="phone" class="text" />
              </li>
               <li>
                <label for="address">Address(required)</label>
                <input id="address" name="address" class="text" />
              </li>
              <li>
                <label for="city">City(required)</label>
                <input id="city" name="city" class="text" />
              </li>
              <li>
                <label for="state">State(required)</label>
                <input id="state" name="state" class="text"/>
              </li>
               <li>
                <label for="zipcode">Pincode/Zipcode(required)</label>
                <input id="zipcode" name="zipcode" class="text" />
              </li>
              <li>
                <input type="image" name="submit" id="imageField" src="images/submit.gif" class="send" />
                <div class="clr"></div>
              </li>
            </ol>
          </form>   
How should i check if form is submitted or not when instead of submit button there is an image ?

----------------------------------------------------------------- Alternative Solution ----------------------------------------------------------------------------

 I tried sending it to other page but then i had to send an array back to this page and i didn't know how to send that either.I tried
Code: [Select]
<?php
$error = serialize($error);
  echo "<meta http-equiv='refresh' content='0;url=about.php?array=".$error."'> ";
?>
But even after

Code: [Select]
$array = unserialize($array);
$array contained nothing.

Can someone please show me how to send in array in between pages for future ?

  In the code below, I am trying to produce a google-like page where the user can type keywords
and pages of search results are displayed.
  The main difficulty I am encountering is that when the browser changes pages, it forgets everything about current data.    Perhaps I should include the display of pages inside the HTML form ? How can I fix this code ?
   Here is the contents of my searchpage.php file :

<?php



$keywords='';
$display_search_results='';

if(isset($_POST['search_submitted'])) {
    $keywords=$_POST['keywords'];
    $search_results=array();
    $totalNbrOfItems=20;
    for($k=1;$k<=$totalNbrOfItems;$k++) {
      $search_results[$k]='Your keywords '$keyowrds.' have been found in item number '.$k;
    }  

    $nbrOfItemsParPage = 5;
    $nbrOfPages = ceil($totalNbrOfItems / $nbrOfItemsParPage);
    // Compute current page
    $current_page = (isset($_GET['page']))?intval($_GET['page']):1;
    $display_pages=($nbrOfPages<2)?'<p>Page : ':'<p>Pages : ';
    for ($i = 1 ; $i <= $nbrOfPages ; $i++)
    {
        if ($i == $current_page) //No link to the current page
        {
            $display_pages=$display_pages.$i.' ';
        }
        else
        {
            $display_pages=$display_pages.'<a href="searchpage.php?'.
            'page='.$i.'">'.
            $i . '</a> ';
        }
    }
    $display_pages=$display_pages.'</p>';
    $display_items='';
    $start=$nbrOfItemsPerPage*($current_page-1);
    for($k=1;$k<=$nbrOfItemsParPage;$k++) {
      $display_items=$display_items.($search_results[$start+$k]).'<br>';
    }
    $display_search_results=$display_pages.$display_items;
}


echo '<form method="post" action="searchpage.php">'.
' Type your keywords here : <br><br>'.
'<textarea cols="65" rows="1" '.
'id="keywords_id" name="keywords">'.$keywords.'</textarea>'.
'<input type="submit" name="search_submitted" id="search_submitted_id" value="Search" /> '.
'</fieldset>'.
'</form>';

echo $display_search_results;

?>