{"id":2479,"date":"2018-06-19T15:27:31","date_gmt":"2018-06-19T08:27:31","guid":{"rendered":"http:\/\/devbanban.com\/?p=2479"},"modified":"2020-05-07T15:00:02","modified_gmt":"2020-05-07T08:00:02","slug":"%e0%b8%95%e0%b8%a2-phpmysqli-call-option-selected-from-database","status":"publish","type":"post","link":"https:\/\/devbanban.com\/?p=2479","title":{"rendered":"\u0e15\u0e22. php+mysqli : Call Option Selected from database"},"content":{"rendered":"

\u0e15\u0e22. php+mysqli : Call Option Selected from database\u00a0 loop with foreach\u00a0\u00a0\u0e01\u0e32\u0e23\u0e19\u0e33\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e43\u0e19 select\/option \u0e41\u0e1a\u0e1a\u0e07\u0e48\u0e32\u0e22\u0e46 \u0e42\u0e14\u0e22\u0e43\u0e0a\u0e49 foreach \u0e43\u0e19\u0e01\u0e32\u0e23\u0e27\u0e19\u0e25\u0e39\u0e1b<\/p>\n

\u0e04\u0e25\u0e34\u0e1b\u0e2a\u0e2d\u0e19
\n<\/strong>https:\/\/www.youtube.com\/watch?v=0qzKu1CGknE<\/a><\/p>\n

example data *\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e14\u0e49\u0e27\u0e22\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a<\/span><\/strong><\/p>\n

CREATE TABLE `tb_member` (\r\n  `member_id` int(11) NOT NULL,\r\n  `username` varchar(100) NOT NULL,\r\n  `member_name` varchar(100) NOT NULL,\r\n  `member_lname` varchar(100) NOT NULL,\r\n  `email` varchar(100) NOT NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n--\r\n-- Dumping data for table `tb_member`\r\n--\r\n\r\nINSERT INTO `tb_member` (`member_id`, `username`, `member_name`, `member_lname`, `email`) VALUES\r\n(1, 'devbanban', 'aaa  bbb', 'dotcom', 'devbanban@gmail.com'),\r\n(2, 'devbanban', 'ccc  ddd', 'dotcom', 'devbanban@gmail.com'),\r\n(3, 'devbanban', 'eee  fff', 'dotcom', 'devbanban@gmail.com'),\r\n(4, 'devbanban', 'devbanban.com', 'dotcom', 'devbanban@gmail.com');\r\n\r\n\r\nALTER TABLE `tb_member`\r\n  ADD PRIMARY KEY (`member_id`);\r\n\r\n\r\nALTER TABLE `tb_member`\r\n  MODIFY `member_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;\r\n\r\n<\/pre>\n
 <\/p>\n
connection database (condb.php)<\/strong><\/p>\n
<?php\r\n$con= mysqli_connect(\"localhost\",\"root\",\"password\",\"myweb\") or die(\"Error: \" . mysqli_error($con));\r\nmysqli_query($con, \"SET NAMES 'utf8' \");\r\n?><\/pre>\n
\u0e43\u0e19 \u0e15\u0e22. code \u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e01\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e41\u0e04\u0e48 1 column<\/span> \u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a \u0e04\u0e37\u0e2d column\u00a0\u00a0member_name<\/span><\/strong><\/p>\n
Full Code\u00a0 (uptou.php)<\/strong><\/p>\n
<meta charset=\"UTF-8\">\r\n<link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.min.css\" integrity=\"sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz\/K68vbdEjh4u\" crossorigin=\"anonymous\">\r\n<?php\r\n\/\/1. \u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e15\u0e48\u0e2d database:\r\ninclude('condb.php');  \/\/\u0e44\u0e1f\u0e25\u0e4c\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e15\u0e48\u0e2d\u0e01\u0e31\u0e1a database \u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e44\u0e14\u0e49\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e44\u0e27\u0e49\u0e01\u0e48\u0e2d\u0e19\u0e2b\u0e19\u0e49\u0e32\u0e19\u0e49\u0e35\r\n\/\/2. query \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01\u0e15\u0e32\u0e23\u0e32\u0e07 tb_member:\r\n$query = \"SELECT * FROM tb_member ORDER BY member_id asc\" or die(\"Error:\" . mysqli_error());\r\n\/\/3.\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48 query \u0e2d\u0e2d\u0e01\u0e21\u0e32\u0e44\u0e27\u0e49\u0e43\u0e19\u0e15\u0e31\u0e27\u0e41\u0e1b\u0e23 result .\r\n$result = mysqli_query($con, $query);\r\n\/\/4 . \u0e41\u0e2a\u0e14\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48 query \u0e2d\u0e2d\u0e01\u0e21\u0e32 \u0e42\u0e14\u0e22\u0e43\u0e0a\u0e49\u0e15\u0e32\u0e23\u0e32\u0e07\u0e43\u0e19\u0e01\u0e32\u0e23\u0e08\u0e31\u0e14\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25:\r\necho \"<div class='container'>\";\r\necho \"<div class='row'>\";\r\necho \"<div class='col-md-8'>\";\r\necho '<h4 align=\"center\"> Display Data From database with foreach Loop <\/h4>';\r\necho \"<table border='1' align='center' class='table table-hover'>\";\r\n  echo \"\r\n  <tr align='center' bgcolor='#CCCCCC'>\r\n    <td>\u0e23\u0e2b\u0e31\u0e2a<\/td>\r\n    <td>Uername<\/td>\r\n    <td>\u0e0a\u0e37\u0e48\u0e2d<\/td>\r\n    <td>\u0e19\u0e32\u0e21\u0e2a\u0e01\u0e38\u0e25<\/td>\r\n    <td>\u0e2d\u0e35\u0e40\u0e21\u0e25\u0e4c<\/td>\r\n  <\/tr>\";\r\n  foreach( $result as $value ) {\r\n  echo \"<tr>\";\r\n    echo \"<td>\" .$value[\"member_id\"] .  \"<\/td> \";\r\n    echo \"<td>\" .$value[\"username\"] .  \"<\/td> \";\r\n    echo \"<td>\" .$value[\"member_name\"] .  \"<\/td> \";\r\n    echo \"<td>\" .$value[\"member_lname\"] .  \"<\/td> \";\r\n    echo \"<td>\" .$value[\"email\"] .  \"<\/td> \";\r\n  echo \"<\/tr>\";\r\n  }\r\necho \"<\/table>\";\r\n\/\/5. close connection\r\necho '<hr>';\r\n\r\n?>\r\n  <h2>\r\n  Example Call Option Selected from database\r\n<\/h2>\r\n<form action=\"http:\/\/devbanban.com\/\" method=\"post\" class=\"form-horizontal\">\r\n  <div class=\"form-group\">\r\n    <div class=\"col-sm-3  control-label\">\r\n      Column member_name :  \r\n    <\/div>\r\n    <div class=\"col-sm-3\">\r\n  <select name=\"test\" class=\"form-control\" required>\r\n    <option value=\"\">-Choose-<\/option>\r\n    <?php foreach($result as $results){?>\r\n    <option value=\"<?php echo $results[\"member_name\"];?>\">\r\n      <?php echo $results[\"member_name\"]; ?>\r\n      <\/option>\r\n    <?php } ?>\r\n  <\/select>\r\n<\/div>\r\n<div class=\"col-sm-1\">\r\n  <button type=\"submit\" class=\"btn btn-primary\"> Action <\/button>\r\n<\/div>\r\n<\/form>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n<?php \r\nmysqli_close($con);\r\n?><\/pre>\n
\u0e04\u0e25\u0e34\u0e1b\u0e2a\u0e2d\u0e19<\/strong><\/p>\n