I'm starting with AngularJS and I want to use it in my WordPress site.
I'm trying to print a table with the data of a table in my WordPress database but I can't access to the WordPress functions and variables.
This following is some of my code.
page-demo.php
<?php
/*
* Template Name: Demo
*/
get_header();
?>
<!DOCTYPE html>
<html>
<head>
<script
src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.15/angular.min.js"></script>
<script language="JavaScript"
src="<?php echo get_option('siteurl')?>/wp-content/themes/theme1200/js/app.js"></script>
<script language="JavaScript"
src="<?php echo get_option('siteurl')?>/wp-content/themes/theme1200/js/smart-table.min.js"></script>
<meta name="description"
content="Basic AngularJS example of data binding" />
<meta charset="utf-8">
<title>JS Bin</title>
</head>
<body >
<div ng-app="myApp" ng-controller="mainCtrl">
<h3>Basic Smart-Table Starter</h3>
<table st-table="rowCollection" class="table table-striped">
<thead>
<tr>
<th>first name</th>
<th>last name</th>
<th>birth date</th>
<th>balance</th>
<th>email</th>
</tr>
</thead>
<tbody>
<tr ng-repeat="row in rowCollection">
<td>{{row.NOMBRE}}</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
<?php
get_footer();
?>
app.js
angular.module('myApp', [ 'smart-table' ]).controller('mainCtrl',
function($scope, $http) {
$http.get('../wp-content/themes/theme1200/model/model.php').
success(function(data) {
$scope.rowCollection = data;
})
});
model.php
<?php
global $wpdb;
//$query = "SELECT * FROM JUGADOR";
//$resultado = $wpdb->get_results($query);
$sql = "SELECT APELLIDOS, NOMBRE, HANDICAP FROM JUGADOR ORDER BY APELLIDOS";
$res = $wpdb->get_results($wpdb->prepare($sql));
$result = $res->fetchAll( PDO::FETCH_ASSOC );
# JSON-encode the response
$json = json_encode( $result );
echo $json;
?>
But I'm having an error when it execute the following line.
$res = $wpdb->get_results($wpdb->prepare($sql));
I think that this file can't access to wordpress functions and variables.
Can anybody help me?
