Mam pytanie:
<table>
<tr>
<td>Photo1:</td><td><input type="file" name="Photo1" id="Photo1" size="20"></td>
</tr><tr>
<td>Photo2:</td><td><input type="file" name="Photo2" id="Photo2" size="20"></td>
</tr><tr>
<td>Photo3:</td><td><input type="file" name="Photo3" id="Photo3" size="20"></td>
</tr>
Jak pozostawie puste te pola w formie, to co sie wysle na nastepna strone? NULL czy zmienne "" (puste)?
Przerobilem troche kodzik. Teraz w ogole sie nie uruchamia i szukam buga. Pomozecie?
<?
session_start();
?>
<html lang="en">
<title>EditProductSave</title>
<meta http-equiv="refresh" content="2; url = http://Prada.blog/panel.php">
<?
// ODBIERAMY Z SESJE
$ProductID = $_SESSION["ProductID"];
$AgentID = $_SESSION["AgentID"];
// BAZA DANYCH
include("DatabaseConnect.php");
// ODBIERAMY ZMIENNE
$Category = $_POST["Category"];
$Name = $_POST["Name"];
$Description = $_POST["Description"];
$Price = $_POST["Price"];
// OBRAZEK 1
if($_FILES['Photo1']['error'] == 0)
{
$zapis = move_uploaded_file($_FILES['Photo1']['tmp_name'], $_SERVER[DOCUMENT_ROOT].'/img/'.basename($_FILES['Photo1']['name']));
}
$Photo1 = basename($_FILES['Photo1']['name']);
// OBRAZEK 2
if($_FILES['Photo2']['error'] == 0)
{
$zapis = move_uploaded_file($_FILES['Photo2']['tmp_name'], $_SERVER[DOCUMENT_ROOT].'/img/'.basename($_FILES['Photo2']['name']));
}
$Photo2 = basename($_FILES['Photo2']['name']);
// OBRAZEK 3
if($_FILES['Photo3']['error'] == 0)
{
$zapis = move_uploaded_file($_FILES['Photo3']['tmp_name'], $_SERVER[DOCUMENT_ROOT].'/img/'.basename($_FILES['Photo3']['name']));
}
$Photo3 = basename($_FILES['Photo3']['name']);
// OBRAZEK 4
if($_FILES['Photo4']['error'] == 0)
{
$zapis =
move_uploaded_file($_FILES['Photo4']['tmp_name'], $_SERVER[DOCUMENT_ROOT].'/shop/img/'.basename($_FILES['Photo4']['name']));
}
$Photo4 = basename($_FILES['Photo4']['name']);
// OBRAZEK 5
if($_FILES['Photo5']['error'] == 0)
{
$zapis = move_uploaded_file($_FILES['Photo5']['tmp_name'], $_SERVER[DOCUMENT_ROOT].'/img/'.basename($_FILES['Photo5']['name']));
}
$Photo5 = basename($_FILES['Photo5']['name']);
// TEST
// echo " AgentID: $AgentID<br> ProductID: $ProductID<br> Category: $Category<br> Name: $Name<br> Description: $Description<br> Price: $Price<br> $Photo1<br> $Photo2<br> $Photo3<br> $Photo4<br> $Photo5";
// DODAJEMY DO BAZY
$data = [
'productid' => $ProductID,
'category' => $Category,
'name' => $Name,
'description' => $Description,
'whodid' => $AgentID,
'price' => $Price,
'photo1FileName' => $Photo1,
'photo2FileName' => $Photo2,
'photo3FileName' => $Photo3,
'photo4FileName' => $Photo4,
'photo5FileName' => $Photo5,
];
$sql = "UPDATE Products SET Category = :category, Name = :name, Description = :description, Price = :price, Photo1FileName = :photo1FileName, Photo2FileName = :photo2FileName, Photo3FileName = :photo3FileName, Photo4FileName = :photo4FileName, Photo5FileName = :photo5FileName WHERE
ProductID = :productid AND WhoDid = :whodid";
$stmt = $pdo->prepare($sql);
$stmt->execute($data);
echo "Product updated...";
// JAKIS TAM NIBY ERROR HANDLING
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($pdo->errorInfo());
}
?>