In order to complete this session, you will need to have completed the work from week two. A solution for last week's challenge can be found in this week's folder: edit.php.
Challenge - create a D3 infographic on our page that gets its data from its own database table.
No, step-by-step instructions this week. However as with last week's challenge here are some hints:
-
You can "include" other PHP scripts in index.php that will grab the code in another file. This is useful for organising your codebase as you can separate different functionality into different files. Use
<?php include 'graph.php' ?>and work in a new file. -
json_encode()will return a string containing a JSON representation of data. So you can use a script to access data in a database and simply return JSON. So far we've used PHP alongside HTML but pure PHP scripts are very common. Useecho json_encode($data);as the result of your script. -
A library of examples are available via the D3 Github repository
-
Trying modifying one of the Javascript examples to pick up your data. Eg:
d3.json('./data.php', function (error, data) { data.forEach(function(d) { // set variables here })
-
If you're stuck have a look at the examples in the src folder. I've adapted this example of a D3 chart.
- Slim Micro-framework - PHP micro framework that helps you quickly write simple yet powerful web applications and APIs. Gives you an understanding what larger libraries are doing without the bloat.
- Laravel - Framework for "Web Artisans"
- Code Igniter - Framework with a very small footprint