Students' Register
connect('127.0.0.1', 6379); $sql = 'select ID, Nom, Prenom from personsalarie '; $cache_key = md5($sql); if ($redis->exists($cache_key)) { $data_source = "Data from Redis Server"; $data = unserialize($redis->get($cache_key)); } else { $data_source = 'Data from MySQL Database'; $db_name = 'test'; $db_user = 'orimix'; $db_password = 'orimix'; $db_host = '127.0.0.1'; $pdo = new PDO('mysql:host=' . $db_host . '; dbname=' . $db_name, $db_user, $db_password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $pdo->prepare($sql); $stmt->execute(); $data = []; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $data[] = $row; } $redis->set($cache_key, serialize($data)); $redis->expire($cache_key, 10); } echo "
$data_source
"; echo "
Student Id
First Name
Last Name
"; foreach ($data as $record) { echo '
'; echo '
' . $record['student_id'] . '
'; echo '
' . $record['first_name'] . '
'; echo '
' . $record['last_name'] . '
'; echo '
'; } } catch (PDOException $e) { echo 'Database error. ' . $e->getMessage(); } ?>