PHP - How To Backup Mysql Database Through Php?

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=314405.0

At the moment  I am creating a search function for my website.
The approach I have in mind is a pseudo-PHP database. To give an example:

A HTML form will submit the results to a PHP file.

HTML FORM - Colour: Black
PHP RESULT PAGE - if ($_POST['color'] == 'Black') {readfile("./products/black/*.html");}
HTML FORM - Price: <$50
PHP RESULT PAGE - if ($_POST['Price'] == '<$50') {readfile("./products/less50/*.html");}

The problem here is if there is an item that is black and costs less than $50, then its going to be listed twice. There is probably some code I can write to ommit the listing of duplicate entries, but it is probably going to be messy, so I am wondering if its better to use a centralized MySQL database, rather than a pseudo-PHP database? I've never used MySQL and don't know much about it and this is my first real attempt at using PHP.

Hello all,

I need to be able to create file backups on different types of servers running php (windows or linux). I was hoping that there was a good php class out there that would already handle this for me but I have not come across anything as of yet. I can do it perfectly fine in the linux environment but was hoping to find something that would work on a variety of servers running php. I was hoping that it would support php 4 for older sites. If anyone has any good resources for this please let me know.

Thanks

Ok. I managed to do something like this:

I used CreateZipFile classs from php classes!

Code: [Select]
<?php
include_once 'CreateZipFile.inc.php';

$createZip = new CreateZipFile;

$createZip->zipDirectory('binary', '');

$zipFileName = 'backup.zip';
$handle       = fopen($zipFileName, 'wb');
$out           = fwrite($handle, $createZip->getZippedFile());

fclose($handle);

$createZip->forceDownload($zipFileName);

@unlink($zipFileName);
?>

but there is still one small issue. The archive doesn't contain any empty folders within the binary folder.

Hi

This is a really basic question but i am trying to understand the process of uploading to amazon S3, I dont want to just download a pre-wriiten script that i dont understand whats happen.

I am using the s3.php class

require_once('S3.php');

$s3 = new S3('[EDITED]', '[EDITED]');

$ourFileName = "files/test.txt";
$ourFileHandle = fopen($ourFileName, 'r') or die("can't open file");
fclose($ourFileHandle);

if ($s3->putObjectFile("files/test.txt", "mybucket", "test/test.txt", S3::ACL_PUBLIC_READ)) {
               echo "<strong>We successfully uploaded your file.</strong>";
}else{
               echo "<strong>Something went wrong while uploading your file... sorry.</strong>";
}

Ok so i am just doing this to figure it out, so i create a file and then upload to amazon s3 this works fine, where i am confused is when you backup all files and directories in a site, i dont want all the backup files in the root off my website i want them to automatically upload to amazon.

So how does the process work?
if i upload a file it works great but i am still upload a file form my server.

How does amazon automatically grab files from my server and upload them.

Anyone no any basic step by step tutorials i have googled loads but they are all massive pre written classes and stuff which i can get working, but looking for a basic example.

Thanks

hi, im looking for a way to make a page that will backup my mysql when i click a button and i can save it locally on any machine i use.  anybody able to help me out with what to search in google?

thanks!

hi all

i am looking for the quickest way to zip all files and folder of a website i am currently using the followning.

<?php
$date = date("F-j-Y-g-ia");

if(exec("cd /home/isd/public_html/bk/files;tar -cvpzf backup-$date.tar /home/isd/public_html")) {

echo "done";

 
 

}  

?>

This works but was just wondering if anyone can give me and insight on a better solution??

Thanks

Hi, I have a some online backup software call ahsay, I' am looing to create a API call with a form in PHP

Please check out this link www.123-backup.com/obs-admin-guide.pdf

this is the guide to create a api for the  online backup (page 69)

Would some be intrested in creating this api call and php form for me ?

p.s please see attached image this is something i'am looking for.

if so how much would it be please email me if you want more info!

Here is function that backup mysql database. It's working fine, but I want to download file instead of creating it.




/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*')
{

$link = mysql_connect($host,$user,$pass);
mysql_select_db($name,$link);

//get all of the tables
if($tables == '*')
{
$tables = array();
$result = mysql_query('SHOW TABLES');
while($row = mysql_fetch_row($result))
{
$tables[] = $row[0];
}
}
else
{
$tables = is_array($tables) ? $tables : explode(',',$tables);
}

//cycle through
foreach($tables as $table)
{
$result = mysql_query('SELECT * FROM '.$table);
$num_fields = mysql_num_fields($result);

$return.= 'DROP TABLE '.$table.';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
$return.= "\n\n".$row2[1].";\n\n";

for ($i = 0; $i < $num_fields; $i++) 
{
while($row = mysql_fetch_row($result))
{
$return.= 'INSERT INTO '.$table.' VALUES(';
for($j=0; $j<$num_fields; $j++) 
{
$row[$j] = addslashes($row[$j]);
$row[$j] = str_replace("\n","\\n",$row[$j]);
if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
if ($j<($num_fields-1)) { $return.= ','; }
}
$return.= ");\n";
}
}
$return.="\n\n\n";
}

//save file
$date= date("d-M-Y_h-i");
$handle = fopen('Backup-'.$date.'.sql','w+');
fwrite($handle,$return);
fclose($handle);
}


Usage:
Quote

backup_tables('HOST','USER','PASS','TABLE');

But this will create backup file on server.


I also tried to add following code in function (at the end):

echo $return;
header('Content-type: text/plain');
header("Content-Disposition: attachment; filename=\"$filename\"");


How to just download file, without showing it on screen instead of using fwrite/fclose function?

How would I go about doing the following:

I have a csv like this
Quote

"Division","Section","Group","Product Code","Description","Description + Secondary Description"
"Division 1","Section 1","Group 1","BMSLPL25","Test Name","Test Description"
"Division 1","Section 1","Group 2","BMSLPL26","Test Name 2","Test Description 2"
"Division 2","Section 2","Group 2","BMSLPL27","Test Name 3","Test Description 3"



I have a database structured like this
Quote

Divisions
---
id
name
parent_id

Groups
---
id
name
division_id

Products
---
id
code
description
secondary_description



Section is a sub division. What is the best way to get the information from CSV into this database? Should I have another table and store the CSV data as is and then query that to make the other tables.
Any help much appreciated.

Hey guys,

I'm working a project that requires sessions be stored within the database, as the project I'm working on is on a shared host. But I'm having a problem with getting the data of a session in the database, the other fields like session_id, session_updated, session_created are working fine. I think I've got a bug in my code, but I just can't detect it (frustrating).

Database connection

class db extends mysqli {
private $host;
private $user;
private $pass;
private $db;

function __construct( $host='localhost', $user='user', $pass='pass', $db='website' ) {
$this -> host = $host;
$this -> user = $user;
$this -> pass = $pass;
$this -> db = $db;

parent::connect( $host, $user, $pass, $db );

if( mysqli_connect_error( ) ) {
die( 'Connection error ('.mysqli_connect_errno(  ).'): '.mysqli_connect_error(  ) );
}

}

function __destruct(  ) {
$this -> close(  );
}
}


Session handler

class sessionHandler {
private $database;
private $dirName;
private $sessTable;
private $fieldArray;

    function sessionHandler() {
        // save directory name of current script
$this -> database = new db;
        $this -> dirName = dirname(__file__);
        $this -> sessTable = 'sessions';
    }

    function open( $save_path, $session_name ) {
return TRUE;
    }

    function close() {
//close the session.
        if ( !empty( $this -> fieldarray ) ) {
            // perform garbage collection
            $result = $this->gc( ini_get ( 'session.gc_maxlifetime' ) );
            return $result;
        }
        return TRUE;
    }

    function read( $session_id ) {
$sql = "
SELECT *
FROM sessions
WHERE session_id=( '$session_id' )
LIMIT 1
";
$result = $this -> database -> query( $sql );
if( $result -> num_rows > 0  ) {
$data = $result -> fetch_array( MYSQLI_ASSOC );
$this -> fieldArray = $data;
$result -> close();
return $data;
}
return "";
    }

    function write( $session_id, $session_data ) {
//write session data to the database.
        if ( !empty( $this -> fieldArray ) ) {
            if ( $this -> fieldArray['session_id'] != $session_id ) {
                // user is starting a new session with previous data
                $this -> fieldArray = array();
            }
        }

$this -> fieldArray['session_id'] = $session_id;
$this -> fieldArray['session_data'] = $session_data;
$this -> fieldArray['session_updated'] = time();
$this -> fieldArray['session_created'] = time();

$session_id = $this -> database -> escape_string( $session_id );
$session_data = $this -> database -> escape_string( $session_data );
$session_updated = time();
$session_created = time();

$sql = "
INSERT INTO sessions ( session_id, session_data, session_updated, session_created )
VALUES ( '$session_id', '$session_data', '$session_updated', '$session_created' )
";
if( $this -> database -> query( $sql ) !== TRUE ) {
return FALSE;
}
return TRUE;
    }

    function destroy( $session_id ) {
$sql = "
DELETE FROM sessions
WHERE session_id=('$session_id')
";
if( $this -> database -> query( $sql ) !== TRUE ) {
return FALSE;
}
return TRUE;
    }

    function gc( $max_lifetime ) {
return TRUE;
    }

    function __destruct() {
//ensure session data is written out before classes are destroyed
//(see http://bugs.php.net/bug.php?id=33772 for details)
@session_write_close();
    }
}


The call

$session_class = new sessionHandler;
session_set_save_handler(
array( &$session_class, 'open' ),
array( &$session_class, 'close' ),
array( &$session_class, 'read' ),
array( &$session_class, 'write' ),
array( &$session_class, 'destroy' ),
array( &$session_class, 'gc' )
);
if( !session_start() ) {
exit();
}


Any help at all would be appreciated.

Kind Regards
Mike

Hello all,   I haven't worked with PHP and MySQL very much, but have been working with HTML and JavaScript for years. This time, I want to build a simple website that allows users to query a database of coins. I just want to make sure that I approach this in the right direction. I'd like to describe what I'm trying to do and hopefully someone can prevent me from becoming a failure.   For the database, each coin has an ID and row, the first column of which is the date, and the following columns attributes of that particular coin. Several entries can exist with the same date.   Anyway, there will basically be three types of pages:   1. A query page from which users will click a date or enter a term in a search box.   2. A query result page displaying a list of search results, like '1909' or 'Lincoln'. Each result will be linked to an individual page for that coin.   3. An individual page. This template page will have an html table whose cells are each defined by the values for that coin in the database.      So for instance, the user searches or clicks on '1909' on the query page and sees 10 records listed in the database on the result page. The user can then click one of those 10 records and view a new page that displays more information on that particular coin.    

There is a "PHP ajax cascading dropdown using MySql" at codestips.com/php-ajax-cascading-dropdown-using-mysql/

I want to use this technique but with a XML or array file instead of mysql database, but my knowledge about mysql is very low. How I can modify this code to catch the categories and products from an array, instead of mysql database?
Code: [Select]
$connect=mysql_connect($server, $db_user, $db_pass)
      or die ("Mysql connecting error");
echo '<table align="center"><tr><td><center><form method="post" action="">Category:<select name="category" onChange="CategoryGrab('."'".'ajaxcalling.php?idCat='."'".'+this.value);">';
$result = mysql_db_query($database, "SELECT * FROM Categories");
$nr=0;
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
 $nr++;
 echo "<option value=".'"'.$row['ID'].'" >'.$row['Name']."</option>";
}
echo '</select>'."\n";
echo '<div id="details">Details:<select name="details" width="100" >';
$result = mysql_db_query($database, "SELECT * FROM CategoriesDetails WHERE CategoryID=1");
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<option value=".$row['ID'].">".$row['Name']."</option>";
}
echo '</select></div>';
echo '</form></td></tr></table>';
mysql_close($connect);
ajaxcalling.php is
Code: [Select]
include("config.php");
$ID=$_REQUEST['idCat'];
$connect=mysql_connect($server, $db_user, $db_pass);
echo 'Details:<select name="details" width="100">';
$result = mysql_db_query($database, "SELECT * FROM CategoriesDetails WHERE CategoryID=".$ID);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<option value=".$row['ID'].">".$row['Name']."</option>";
}
echo '</select>';
mysql_close($connect);

Hi All,

Whenever I try to update any piece of PHP code to update a MySQL database, nothing happens. I have tried copying in some of the working codes of a website and tried the same, but no success.

I recently installed XAMPP. I am connecting using the correct user id and pass to the database. The scripts are not giving me any error, but just not connecting, that's all.

While making such a usage as noted below

<FORM name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" >


I get the following error

Firefox can't find the file at /C:/xampp/htdocs/="<?php..  so on

Why does this happen?

I am pretty new to this, so please do help.

Thanks,
Satheesh P R