-
Notifications
You must be signed in to change notification settings - Fork 0
/
export.php
31 lines (28 loc) · 927 Bytes
/
export.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<?php
include_once('functions.php');
?>
<?php include_once('inc.php');
$result=$conn->query('select * from songs');
while ($row = $result->fetch_assoc()) {
$lista[] = sanitize($row['sid']);
$listb[] = sanitize($row['stitle']);
$listc[] = sanitize($row['atitle']);
}
//$stmt = $conn->prepare("update songs set stitle = '?' , atitle= '?' where sid= '?' ");
// update songs set stitle = 'Sooiyan From Guddu Rangeela' , atitle= 'Arijit Singh My Favourites' where sid= '13198655'
//var_export($list);
foreach($lista as $index=>$link){
//$stmt->bind_param("sss", $stitle,$atitle,$sid);
$stitle=$listb[$index];
$atitle=$listc[$index];
$sid=$link;
//echo $link[0].'<br>';
//
//$stmt->execute();
if($sid="2880353"){
$conn->query("update songs set stitle = '$stitle' , atitle= '$atitle' where sid= $sid");
echo $conn->affected_rows.'<br>';
echo $conn->error;}
}
$conn->close;
?>