如何使用laravel检索数据

i am new in php especially laravel framework. could be someone help me to resolve it? i don't know how to retrieve data from database using php: laravel framework.

我是php的新手，尤其是laravel框架。可能有人帮我解决了吗？我不知道如何使用php：laravel框架从数据库中检索数据。

profile.blade.php file

profile.blade.php文件

<!doctype html>
<html>


<head>
    <title>Student Profile</title>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <style>

        div{
            background-color:lightcyan;
            margin-left: 180px;
            margin-right: 180px;
            margin-bottom: 10px;
            background-repeat: no-repeat;
            position:inherit;
            padding:2px;
            font-size: 14px;
        }

        body{
            margin-top: 5px;
            margin-bottom: 5px;
            background-image:url("image/bg.jpg");
            background-repeat: no-repeat;
            background-attachment: fixed;
        }


        h1 {
            font-family: "Georgia", Times, serif;
            font-size: 42px;
            color: firebrick;
            text-indent: 12%;
        }

        table, th, td {
            border: 1px solid lightcoral;
            text-transform: uppercase;
            text-align: left;
        }

        .header {
            background-color: lightcoral;
            width: 15%;
        }
        footer{
            background-color: black;
            color: white;
            font-weight: bold;
            padding: 10px;
            text-align: center;
        }
        #navbar {
            width:100%;
            margin-left:-2px;
            height:40px;
            background-color:rosybrown;
        }

        #navbar ul {
            width:100%;
            margin:0 auto 0 auto;
        }

        #navbar ul li {
            float:left;
            color:black;
            padding:0 20px 0 20px;
            font-size: 14px;
            font-weight: bold;
            height:40px;
            display:block;
            line-height:40px;
            text-align:center;
            cursor:pointer;
        }

        #navbar ul li:hover {
            background-color:#CCC;
        }
        li{
            text-transform: capitalize;
        }
    </style>
</head>


<body>
<div>

<h1>GUARDIAN PORTAL</h1><br>
<div id="navbar">

    <ul>
        <li>Home</li>
        <li>Student profile</li>
        <li>Exam result</li>
        <li>academic supervisor/Advisor</li>
        <li>change password</li>
        <li>contact us</li>
        <li>logout</li>
    </ul>

</div>

    <fieldset>
        <legend align="center"><b><font color="red">Student Profile</font></b></legend>
        <table width="100%">

            <tr>
                <td class="header">student id</td>
                <td></td>
            </tr>
            <tr>
                <td class="header"> name</td>
                <td></td>
            </tr>
            <tr>
                <td class="header">ic no</td>
                <td ></td>
            </tr>
            <tr>
                <td class="header">programme</td>
                <td></td>
            </tr>
            <tr>
                <td class="header">semester</td>
                <td></td>
            </tr>

            <tr>
                <td class="header">faculty</td>
                <td></td>
            </tr>

        </table>
        <table width="100%">
            <tr>
                <td class="header" width="15%">tel no</td>
                <td width="35%"></td>
                <td class="header" width="15%">email</td>
                <td width="35%"></td>
            </tr>
            <tr>
                <td class="header">race</td>
                <td></td>
                <td class="header">religion</td>
                <td></td>
            </tr>
            <tr>
                <td class="header">gender</td>
                <td></td>
                <td class="header">marital status</td>
                <td></td>
            </tr>
            <tr>
                <td class="header" width="15%">college name</td>
                <td width="35%"></td>
                <td class="header" width="15%">college no</td>
                <td width="35%"></td>
            </tr>
        </table>
        <table width="100%">
            <tr>
                <td class="header"><b>status</b></td>
                <td width="85%"></td>
            </tr>
        </table>
        <table width="100%">
            <td colspan="2" align="center"><b>permanent address</b></td>
            <td colspan="2" align="center"><b>current address</b></td>
            </tr>
            <tr>
                <td class="header" width="5%">address</td>
                <td width="35%"></td>
                <td class="header" width="5%">address</td>
                <td width="35%"></td>
            </tr>
            <tr>
                <td class="header">city</td>
                <td></td>
                <td class="header">city</td>
                <td></td>
            </tr>
            <tr>
                <td class="header">state</td>
                <td></td>
                <td class="header">state</td>
                <td></td>
            </tr>
            <tr>
                <td class="header">postcode</td>
                <td></td>
                <td class="header">postcode</td>
                <td></td>
            </tr>
            <tr>
                <td class="header">country</td>
                <td></td>
                <td class="header">country</td>
                <td></td>
            </tr>
        </table>
    </fieldset>
    </div>
</body>
</html>

studentcontroller.php

public function index()
    {
        $table = DB::table('student')->get();

        return view('profile', ['student_id' => $table]);
    }

route.php

Route::get('student', array('as'=>'student', 'uses'=>'studentcontroller'));

database: student.php

数据库：student.php

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations
\Migration;

class Student extends Migration {

    public function up()
    {
        Schema::create('student',
            function(Blueprint $table)
            {
                $table->string('student_id');
                $table->string('student_name');
                $table->string('student_ic');
                $table->string('program');
                $table->string('semester');
                $table->string('faculty');
                $table->string('student_tel_no');
                $table->string('student_email');
                $table->string('student_marital_status');
                $table->string('student_religion');
                $table->string('student_race');
                $table->string('student_gender');
                $table->string('college_name');
                $table->string('college_no');
                $table->string('status');
                $table->string('p_address');
                $table->string('p_city');
                $table->string('p_state');
                $table->string('p_postcode');
                $table->string('p_country');
                $table->string('c_address');
                $table->string('c_city');
                $table->string('c_state');
                $table->string('c_postcode');
                $table->string('c_country');
                });
        DB::table('student')->insert(array(

        'student_id'=>'uk27721',

        'student_name'=>'sumaliza ismail',

        'student_ic'=>'123456789012',

        'program'=>'program',
        'semester'=>'1',

        'faculty'=>'faculty',

        'student_tel_no'=>'1',

        'student_email'=>'email',

        'student_marital_status'=>'status',

        'student_religion'=>'student_religion',

        'student_race'=>'student_race',

        'student_gender'=>'student_gender',

        'college_name'=>'college_name',

        'college_no'=>'college_no',

        'status'=>'status',

        'p_address'=>'p_address',

        'p_city'=>'p_city',

        'p_state'=>'p_state',

        'p_postcode'=>'p_postcode',

        'p_country'=>'p_country',

        'c_address'=>'c_address',

        'c_city'=>'c_city',

        'c_state'=>'c_state',

        'c_postcode'=>'c_postcode',

        'c_country'=>'c_country'
    ));
        DB::table('student')->insert(array(

        'student_id'=>'uk27771',

        'student_name'=>'sumaliza ismail',

        'student_ic'=>456543456456,

        'program'=>'program',
        'semester'=>'1',

        'faculty'=>'faculty',

        'student_tel_no'=>'1',

        'student_email'=>'email',

        'student_marital_status'=>'status',

        'student_religion'=>'student_religion',

        'student_race'=>'student_race',

        'student_gender'=>'student_gender',

        'college_name'=>'college_name',

        'college_no'=>'college_no',

        'status'=>'status',

        'p_address'=>'p_address',

        'p_city'=>'p_city',

        'p_state'=>'p_state',

        'p_postcode'=>'p_postcode',

        'p_country'=>'p_country',

        'c_address'=>'c_address',

        'c_city'=>'c_city',

        'c_state'=>'c_state',

        'c_postcode'=>'c_postcode',

        'c_country'=>'c_country'
    ));


    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('student');
    }

}

2 个解决方案

#1

In your view you will hav to do the following

在您看来，您将执行以下操作

@foreach($student_id as $student)
<p> {{ $student->name }} </p>
@endforeach

the name property is your table in database This is if you are using the blade engine else use normal php tags

name属性是你在数据库中的表这是你使用的是刀片引擎，否则使用普通的php标签

And then in your route you have to tell what method in you controller you want to use eventhough your function is called index it is good pratice to specify the function on your route. To have a good code strutuce remember that Classes always starts with capital letters

然后在你的路线中，你必须告诉你想要使用的控制器中的哪种方法，尽管你的函数被称为索引，但是在你的路线上指定函数是很好的实践。要有一个好的代码strutuce记住，类总是以大写字母开头

I would strongly suggest you to use eloquent instead of the query builder

我强烈建议您使用eloquent而不是查询构建器

#2

First of all, I would recommend you look through Laravel 5 Fundamentals in order to learn a bit about the framework. Now, a few things.

首先，我建议您浏览Laravel 5 Fundamentals以了解该框架。现在，有几件事。

In Laravel, when writing migrations, don't name them things like Student.php. Use the command php artisan make:migration create_students_table. The standard naming convention is to describe the action of the migration.
在Laravel中，在编写迁移时，不要将它们命名为Student.php。使用命令php artisan make：migration create_students_table。标准命名约定是描述迁移的操作。
If you want to insert certain data, don't do it in your migration. Instead, look at setting up a seeder.
如果要插入某些数据，请不要在迁移中执行此操作。相反，看看设置播种机。
For your Student I would very much recommend that you create a model. Laravel is an MVC framework, and if you're not used to the MVC structure, this might be a bit different to what you're used to. A model is simply a representation of some collection of data that is logically bundled together. In your database, this data is what ends up being in one row. You could then do Student::all() to retrieve all data from your students table.
对于你的学生，我非常建议你创建一个模型。 Laravel是一个MVC框架，如果你不熟悉MVC结构，这可能与你习惯的有点不同。模型只是逻辑上捆绑在一起的一些数据集合的表示。在您的数据库中，这些数据最终会排在一行。然后，您可以执行Student :: all（）以从学生表中检索所有数据。
The naming convention in Laravel dictates the use of camelCase. Hence, all your files should be named, just as your classes, with camel case. This is to say StudentController.php and class StudentController
Laravel中的命名约定决定了camelCase的使用。因此，所有文件都应该像驼峰一样命名，就像你的类一样。这就是StudentController.php和类StudentController
In your routes.php, specify which method to call as well: Route::get('student', ['as' => 'student', 'uses' => 'StudentController@index']);
在routes.php中，指定要调用的方法：Route :: get（'student'，['as'=>'student'，'uses'=>'StudentController @ index']）;

Again, please have a look at the Laravel 5 fundamentals series linked in the beginning. You will learn to handle Laravel properly there.

再次，请看一下开始时链接的Laravel 5基础系列。你将学会在那里妥善处理Laravel。

#1