lecz niestestety nie potrafię zrobić możliwości edycji profilu
<?php require('includes/config.php'); $title = 'Profile Page'; require('layout/header.php'); ?> <?php $sql = "select * from members where memberID='".$_SESSION['memberID']."';"; try{ $rs = $db->query($sql); if($rs != null){ $result = $rs->fetch(PDO::FETCH_ASSOC); } } catch (Exception $ex) { } } ?> <?php require('layout/footer.php'); ?>
CREATE TABLE `members` ( `memberID` int(11) NOT NULL, `username` varchar(255) COLLATE utf8mb4_bin NOT NULL, `password` varchar(255) COLLATE utf8mb4_bin NOT NULL, `email` varchar(255) COLLATE utf8mb4_bin NOT NULL, `active` varchar(255) COLLATE utf8mb4_bin NOT NULL, `resetToken` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `resetComplete` varchar(3) COLLATE utf8mb4_bin DEFAULT 'No', `pimie` varchar(255) COLLATE utf8mb4_bin NOT NULL, `dimie` varchar(255) COLLATE utf8mb4_bin NOT NULL, `omnie` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `urodziny` varchar(255) COLLATE utf8mb4_bin NOT NULL, `kraj` varchar(255) COLLATE utf8mb4_bin NOT NULL, `miasto` varchar(255) COLLATE utf8mb4_bin NOT NULL PRIMARY KEY (`memberID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
POZDRAWIAM
