{"id":910,"date":"2023-03-15T22:59:53","date_gmt":"2023-03-15T21:59:53","guid":{"rendered":"http:\/\/lesvadrouilles.com\/?post_type=penci-block&#038;p=910"},"modified":"2023-03-15T23:06:17","modified_gmt":"2023-03-15T22:06:17","slug":"live-scoring","status":"publish","type":"penci-block","link":"https:\/\/golf-cup.fr\/index.php\/penci-block\/live-scoring\/","title":{"rendered":"Live Scoring"},"content":{"rendered":"\n<?php\n  $host = 'lesvady401.mysql.db';\n  $dbname = 'lesvady401';\n  $username = 'lesvady401';\n  $password = 'Tuv686159357';\n    \n  $dsn = \"mysql:host=$host;dbname=$dbname\"; \n  \/\/ r\u00e9cup\u00e9rer tous les utilisateurs\n  $sql = \"SELECT * FROM live_scoring\";\n   \n  try{\n   $pdo = new PDO($dsn, $username, $password);\n   $stmt = $pdo->query($sql);\n   \n   if($stmt === false){\n    die(\u00ab\u00a0Erreur\u00a0\u00bb);\n   }\n   \n  }catch (PDOException $e){\n    echo $e->getMessage();\n  }\n?>\n\n\n <h1>Liste des utilisateurs<\/h1>\n <div class=\"pcrstb-wrap\"><table>\n   <thead>\n     <tr>\n       <th>ID<\/th>\n       <th>Name<\/th>\n\t <th>Jour<\/th>\n\t <th>Score net<\/th>\n\t <th>Score brut<\/th>\n     <\/tr>\n   <\/thead>\n   <tbody>\n     <?php while($row = $stmt->fetch(PDO::FETCH_ASSOC)) : ?>\n     <tr>\n       <td><?php echo htmlspecialchars($row['id_jou']); ?><\/td>\n       <td><?php echo htmlspecialchars($row['nom_jou']); ?><\/td>\n       <td><?php echo htmlspecialchars($row['jour']); ?><\/td>\n       <td><?php echo htmlspecialchars($row['score_net']); ?><\/td>\n       <td><?php echo htmlspecialchars($row['score_brut']); ?><\/td>\n     <\/tr>\n     <?php endwhile; ?>\n   <\/tbody>\n <\/table><\/div>\n\n","protected":false},"template":"","meta":{"content-type":"","_lmt_disableupdate":"","_lmt_disable":""},"class_list":["post-910","penci-block","type-penci-block","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/golf-cup.fr\/index.php\/wp-json\/wp\/v2\/penci-block\/910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/golf-cup.fr\/index.php\/wp-json\/wp\/v2\/penci-block"}],"about":[{"href":"https:\/\/golf-cup.fr\/index.php\/wp-json\/wp\/v2\/types\/penci-block"}],"version-history":[{"count":3,"href":"https:\/\/golf-cup.fr\/index.php\/wp-json\/wp\/v2\/penci-block\/910\/revisions"}],"predecessor-version":[{"id":921,"href":"https:\/\/golf-cup.fr\/index.php\/wp-json\/wp\/v2\/penci-block\/910\/revisions\/921"}],"wp:attachment":[{"href":"https:\/\/golf-cup.fr\/index.php\/wp-json\/wp\/v2\/media?parent=910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}