thanks
I REALLY THANK YOU, GOD BLESS YOU !!!!!!
CREATE TABLE `members` ( `memid` INT(11) NOT NULL AUTO_INCREMENT, `firstname` VARCHAR(30) NOT NULL, `lastname` VARCHAR(30) NOT NULL, PRIMARY KEY(`memid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `members` (`memid`, `firstname`, `lastname`) VALUES (1, 'neovic', 'devierte'), (2, 'gemalyn', 'cepe');
<!DOCTYPE html> <html> <head> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" /> </head> <body> <div class="container"> <div id="members"> <div class="col-md-8 col-md-offset-2"> <div class="row"> <div class="col-md-12"> <h2>Member List </h2> </div> </div> <table class="table table-bordered table-striped"> <thead> </thead> <tbody> <tr v-for="member in members"> <td> </td> </tr> </tbody> </table> </div> </div> </div> </body> </html>
<?php $conn = new mysqli("localhost", "root", "", "crud"); if ($conn->connect_error) { } $crud = 'read'; $crud = $_GET['crud']; } if($crud = 'read'){ $sql = "select * from members"; $query = $conn->query($sql); while($row = $query->fetch_array()){ } $out['members'] = $members; } $conn->close(); ?>
var app = new Vue({ el: '#members', data:{ members: [] }, mounted: function(){ this.getAllMembers(); }, methods:{ getAllMembers: function(){ axios.get("api.php") .then(function(response){ //console.log(response); app.members = response.data.members; }); } } });