Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- header('Content-Type: text/html; charset=utf-8');
- define('MYSQL_HOST', '127.0.0.1');
- define('MYSQL_USERNAME', 'user1');
- define('MYSQL_PASSWORD', '123456');
- define('MYSQL_DBNAME', 'form');
- define('ENDL', "\r\n");
- $DB = new mysqli(MYSQL_HOST, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DBNAME);
- if ($DB->connect_error) {
- echo 'Connect error ' . $DB->connect_errno . ': ' . $DB->connect_error;
- die();
- }
- $DB->set_charset('utf8');
- if (isset($_POST['update'])) {
- $sql = 'UPDATE `articles` SET `title` = "%s" WHERE `id` = %d';
- foreach ($_POST['title'] as $key => $value) {
- $id = filter_var($key, FILTER_VALIDATE_INT);
- $title = $DB->real_escape_string($value);
- if ($id === FALSE) {
- continue;
- }
- $DB->query(sprintf($sql, $title, $id));
- }
- }
- ?>
- <html>
- <head>
- <title>Form Application</title>
- </head>
- <body>
- <form method="post" action=".">
- <table border="1">
- <tr>
- <th>ID</th>
- <th>Title</th>
- </tr>
- <?php
- $sql = 'SELECT * FROM `articles`';
- $templete = '<tr><td>%1$d</td><td><input type="text" name="title[%1$d]" value="%2$s" /></td></tr>' . ENDL;
- if ($query = $DB->query($sql)) {
- while ($result = $query->fetch_assoc()) {
- printf($templete, $result['id'], $result['title']);
- }
- }
- ?>
- </table>
- <input type="submit" name="update" value="update" />
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement