android mysql baglantısı ve veritabanına resim ekleme
<?php
$con=mysqli_connect("localhost","root","","kullanicilar");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
if($_SERVER['REQUEST_METHOD']=='POST'){
$image = $_POST['image'];
$name = $_POST['name'];
$sql ="SELECT id FROM photos ORDER BY id ASC";
$res = mysqli_query($con,$sql);
$id = 0;
while($row = mysqli_fetch_array($res)){
$id = $row['id'];
}
$path = "uploads/$id.png";
$actualpath = "http://169.254.39.2/uploads/$path";
$sql = "INSERT INTO photos (image,name) VALUES ('$actualpath','$name')";
if(mysqli_query($con,$sql)){
file_put_contents($path,base64_decode($image));
echo "Successfully Uploaded";
}
}
else{ mysqli_close($con);
echo "Error";
}
?>
$con=mysqli_connect("localhost","root","","kullanicilar");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
if($_SERVER['REQUEST_METHOD']=='POST'){
$image = $_POST['image'];
$name = $_POST['name'];
$sql ="SELECT id FROM photos ORDER BY id ASC";
$res = mysqli_query($con,$sql);
$id = 0;
while($row = mysqli_fetch_array($res)){
$id = $row['id'];
}
$path = "uploads/$id.png";
$actualpath = "http://169.254.39.2/uploads/$path";
$sql = "INSERT INTO photos (image,name) VALUES ('$actualpath','$name')";
if(mysqli_query($con,$sql)){
file_put_contents($path,base64_decode($image));
echo "Successfully Uploaded";
}
}
else{ mysqli_close($con);
echo "Error";
}
?>
Yorumlar
Yorum Gönder