Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
### Mod by Dante161
## dante161@yandex.ru
# Яндекс Деньги: 410011185573054
if (isset($_POST['submit'])) {
$fio = txt($_POST['fio']);
$phone_number = txt($_POST['phone_number']);
$email = txt($_POST['email']);
$address = txt($_POST['address']);
$target_dir = HOME . '/img/profile/';
if (isset($_FILES["file"]["name"])) {
$original_filename = $_FILES['file']['name'];
$target = $target_dir . basename($original_filename);
$tmp = $_FILES['file']['tmp_name'];
$file_result = move_uploaded_file($tmp, $target);
if ($file_result == true) {
$error_404 = $error_404 . 'Изображение успешно загруженно!<br/>';
} else {
$error_404 = $error_404 . 'Ошибка загрузки изображения!<br/>';
}
} else {
$error_404 = $error_404 . 'Вы не выбрали изображение!<br/>';
}
try {
$update_columns = array();
$update_columnsValue = array();
if(trim($fio) !== "") { $update_columns[] = "fio = ?"; $update_columnsValue[] = $fio;}
if(trim($phone_number) !== "") { $update_columns[] = "phone_number = ?"; $update_columnsValue[] = $phone_number;}
if(trim($email) !== "") { $update_columns[] = "email = ?"; $update_columnsValue[] = $email;}
if(trim($address) !== ""){ $update_columns[] = "address = ?"; $update_columnsValue[] = $address;}
if(trim($original_filename) !== "") { $update_columns[] = "img = ?"; $update_columnsValue[] = $original_filename;}
$req_up = DB::$the->prepare("UPDATE users SET " . implode(", ", $update_columns) . " WHERE id = ?")->execute(array(implode(", ", $update_columnsValue), $_SESSION['id']));
$error_404 = $error_404 . 'Изменения сохранены успешно!<br/>';
} catch(PDOException $e) {
echo implode(", ", $update_columns) .'<br/>';
echo implode(", ", $update_columnsValue);
$error_404 = $error_404 . 'Ошибка при сохранении записи!<br/>'. $e->getMessage();;
}
}
$data = DB::$the->prepare("SELECT * FROM `users` WHERE `id` = ? LIMIT 1")->execute(array($_SESSION['id']));
$data = $data -> fetch(PDO::FETCH_ASSOC);
echo '<div class="page-top-info">
<div class="container">
<div class="site-pagination">
<a href="' . URL . '">' . output($system_title) . '</a> /
<a href="' . URL . '/?index=profile">Профиль</a>
</div>
</div>
</div>';
echo '<section class="checkout-section spad">
<div class="container">
<div class="row justify-content-center">';
echo '<div class="col-lg-8 order-2 order-lg-1">
<form class="checkout-form" action="' . URL . '/?index=edit_profile" method="post" enctype="multipart/form-data">
<div class="cf-title">Личные данные</div>
' . $error_404 . '<div class="row address-inputs">';
echo '<div class="col-md-6">
Фото (максимальный размер 1920х720px):
<input class="form-control input-file" name="file" type="file">
</div>';
echo '<div class="col-md-6">Ф.И.О:
<input name="fio" type="text" value = "' . output($data["fio"]) . '" class="form-control"/>
</div>';
echo '<div class="col-md-6">Номер телефона:
<input name="phone_number" type="tel" placeholder="79001234567" pattern="7[0-9]{10}" value = "' . output($data["phone_number"]) . '" class="form-control"/>
</div>';
echo '<div class="col-md-6">E-Mail:
<input name="email" type="text" value = "' . output($data["email"]) . '" class="form-control"/>
</div>';
echo '<div class="col-md-6">Адрес:<input id="region" name="address" type="text" value = "' . output($data["address"]) . '" class="form-control"/>
</div>
</div>';
echo '
<div class="row align-items-center mb-3">
<div class="col-md-6">Дата регистрации: ' . date_format(date_create(output($user_date_reg)), 'd.m.Y H:i:s') . '
</div>
<div class="col-md-6">Ссылка для приглашения: <br> ' . URL . '/?ref=' . $data_user['id'] . '
</div>
</div>
';
echo '<button class="site-btn submit-order-btn" name="submit">Сохранить</button>
</form>';
echo '</div>
</div>
</div>
</section>';