Databases
StackOverflow2013
Postsdbo
POHow do I write php code to send JSON data from MySQL database to my AngularJS application
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I write php code to send JSON data from MySQL database to my AngularJS application
    primarykey
    data
    text
    <p>I'm trying to wire up my angularjs application to get JSON data from a database (mySQL), using PHP as the server-side language (a language I taught myself this summer, and am most comfortable with). </p> <p>Having looked at these links: (<a href="https://stackoverflow.com/questions/17376890/angular-js-full-example-of-get-post-delete-put-client-for-a-rest-crud-backend">Angular JS: Full example of GET/POST/DELETE/PUT client for a REST/CRUD backend?</a>) (<a href="https://stackoverflow.com/questions/16394089/how-to-access-the-services-from-restful-api-in-my-angularjs-page">How to access the services from RESTful API in my angularjs page?</a>), I feel very confident in how the AngularJS code should look, but I don't know what the URL is doing in these $resource examples.</p> <p>I've never implemented a RESTful API in any language, and I'm having a lot of trouble understanding what the code should be inside the tags. Explanations on the web are often too technical for my skill level. I've tried asking my professors, but I haven't found one who has implemented REST before.</p> <p>I appreciate any time and any help, Andrew</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USAndrew Allbright
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POHow do I write php code to send JSON data from MySQL database to my AngularJS application
      1. USPeterG
      1. VTFavorite
    1. COThat's a very broad question. It's like asking how to create a website. Do you have experience with PHP? Are you already using a PHP framework?
      singulars
      1. POHow do I write php code to send JSON data from MySQL database to my AngularJS application
      1. USjvandemo
    2. COHello thanks for your response. I read through and created some php projects based on the O'Riley text 'Building Dynamic Websites using Php, MySQL, CSS and Javascript', which is a procedural based programming style. I have considered using cakephp or Laravel, but I don't think I'm ready for that layer of abstraction yet. At any rate I found an example that helped me, and I will post it later for anyone else who might be at the same level as me. I'm on my phone at the moment, but will share my resource when I'm on my computer.
      singulars
      1. POHow do I write php code to send JSON data from MySQL database to my AngularJS application
      1. USAndrew Allbright
    3. COHere is the promised link: http://pastebin.com/7RDYfY7W
      singulars
      1. POHow do I write php code to send JSON data from MySQL database to my AngularJS application
      1. USAndrew Allbright
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload