code for database backup???

garryrj · December 15th, 2008, 06:19 AM

hello everybudy,
i am begginer in php, i hv two problems right now
1) i developing a site in which flat_no is same and i want to insert multiple member name and their blood group resp(with same flat no)....by using single textbox!
2) i wanna take backup of database!!!
can anybudy provide me the code for my problems.....
plz help me out...
Thank you.

GreenCore · December 17th, 2008, 10:56 PM

Quote:

multiple member ... using single textbox!

Example:

Input page

HTML Code:

...
<form action="savedata.php" method="post">
    <textarea name="patientdata"></textarea>
    <input type="submit" value="Save"/>
</form>
...

Save page
(example name: "savedata.php")

PHP Code:


			
<?php

// After testing, delete row below
$testdata = "Barack Obama, A; Jorge Bush, AB; Bill Clinton, B";

/*
    Please always use a Secure Server and think's like SSL / HTTPS for Patient Data
*/

//HTML Form input

//temp off for single page test
/*
if (isset($_POST["patientdata"])){
    $pdata = $_POST["patientdata"];
} else {
    die("Please fill field Patient Data");
}

//Your SQL injection protection
//$pdata

*/



// After testing, delete row below
$pdata = $testdata;

// Change explode to your own format
$PatientsArray = explode(";", $testdata);

// After testing, delete row below
var_dump($PatientsArray);

foreach ($PatientsArray as $key => $value) {
    // And so on...
    // 
    
    $SinglePatientArray = explode(",", $value);
    
    //Your valid data test funtions
    // for $SinglePatientArray
    
    // After testing, delete row below
    var_dump($SinglePatientArray);
    
    /*
    $query = sprintf("mysql insert query", $SinglePatientArray[0], $SinglePatientArray[1]);
    mysql_query($query);
    */
}

?>

Quote:

...take backup of database...

http://www.phpmyadmin.net