官术网_书友最值得收藏!

Creating views

Now that we have our model complete, a template render function, we just need to create the view with which we can look at each profile.

Our view will be put inside a foreach block, and we'll use the template we wrote to render the right values:

//listprofiles.php 
 
<html> 
<!doctype html> 
<head> 
<link rel="stylesheet" > 
</head> 
<body> 
 
<?php 
foreach($results as $item) { 
  echo profile_template($item->name, $item->age, $item->country; 
} 
?> 
</body> 
</html> 

Let's put the code above into index.php .

While we may install the Apache server, configure it to run PHP, install new virtual hosts and the other necessary features, and put our PHP code into an Apache folder, this will take time. So, for the purposes of testing this out, we can just run PHP's server for development.

To run the built-in PHP server (read more at http://php.net/manual/en/features.commandline.webserver.php ) we will use the folder we are running, inside a terminal:

php -S localhost:8000

If we open up our browser, we should see nothing yet, No results found. This means we need to populate our database.

If you have an error with your database connection, be sure to replace the correct database credentials we supplied into each of the mysql_connect calls that we made.

  1. To supply data to our database, we can create a simple SQL script like this:
    INSERT INTO user_profiles ('Chin Wu', 30, 'Mongolia'); 
    INSERT INTO user_profiles ('Erik Schmidt', 22, 'Germany'); 
    INSERT INTO user_profiles ('Rashma Naru', 33, 'India'); 
    
  2. Let's save it in a file such as insert_profiles.sql. In the same directory as the SQL file, log on to the MySQL client by using the following command:
     mysql -u root -p
    
  3. Then type use <name of database>:
     mysql> use <database>;
    
  4. Import the script by running the source command:
     mysql> source insert_profiles.sql
    

Now our user profiles page should show the following:

主站蜘蛛池模板: 龙泉市| 南江县| 彝良县| 岱山县| 安义县| 尚义县| 微博| 太白县| 云安县| 渝中区| 昌邑市| 芜湖县| 香格里拉县| 望谟县| 河南省| 南汇区| 凯里市| 和田县| 开化县| 云龙县| 高陵县| 井陉县| 三门峡市| 巨野县| 自贡市| 福安市| 宜川县| 东莞市| 台湾省| 新邵县| 台湾省| 浮山县| 益阳市| 尖扎县| 布尔津县| 黄冈市| 明光市| 绍兴县| 松溪县| 尉犁县| 香格里拉县|