backup specific tables/columns using php for each user

Question

it is my first question here. if I am mistaken sorry for that.

I want, each user of my site, can backup their data from mysql. how can i do it using php?

something like that;

    <?php
$userid = 15;
$username = 'memmed';
$filename = $username.$userid.'sql';

$sql = 'SELECT * FROM users WHERE id = 15;';
$query = mysql_query($sql);
$row = mysql_fetch_row($query);
$text = 'INSERT INTO users (id, name, .. , ......) VALUES('.$row['id'].', ............)';

$handle = fopen('backups/'.$filename,'w+');

fwrite($handle,$text);
fclose($handle); ?>

Community · Accepted Answer · 2017-05-23 11:52:18Z

0

The code you have given will not do "data backup" It will just do something like save the $text.

If you want to do mysql backup, try something like

mysql dump using php script

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Nov 2, 2014 at 16:04

Anshu Prateek

3,0551 gold badge21 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jhan Karimov Over a year ago

I want just for some column backup

Nurettin Acar · Accepted Answer · 2015-01-29 15:58:15Z

-1

just create 2 string as follow

$str1='';
$str2='';
    foreach($row as $key=>$value){
                $str1.=$key.',';
                $str2.="'".$value."',";
            }
        }
        $str1=rtrim($str1,',');
        $str2=rtrim($str2,',');

   $text = 'INSERT INTO users ('.$str1.') VALUES('.$str2.')';

answered Jan 29, 2015 at 15:58

Nurettin Acar

13 bronze badges

1 Comment

Jan Doggen Over a year ago

This does not answer the question

Collectives™ on Stack Overflow

backup specific tables/columns using php for each user

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related