skip to Main Content

In Laravel controller file, I would like to change the date format of regDate from 'Y-m-d' to 'd/m/Y'. RegDate from table is in YYYY-mm-dd

I would like to format "regDate" to 'dd/mm/YYYY' from 'YYYY/mm/dd'. Appreciate any help. Thanks. if ($request->keyword != "") { $students = Student::where ("name","LIKE","%" . $request->keyword . "%") ->orWhere("nric","LIKE","%" . $request->keyword . "%") ->orWhere("address","LIKE","%" . $request->keyword . "%") ->orWhere("telNo","LIKE","%" . $request->keyword…

VIEW QUESTION

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table – Laravel

i have three migrations 2022_09_20_021431_create_posts_table.php Schema::create('posts', function (Blueprint $table) { $table->increments('id'); $table->string('title', 100); $table->text('body'); }); 2022_09_21_021455_create_category_posts_table.php Schema::create('category_posts', function (Blueprint $table) { $table->unsignedBigInteger('category_id')->nullable(); $table->unsignedBigInteger('post_id')->nullable(); $table->primary(['category_id', 'post_id']); $table->foreign('category_id')->references('id')->on('categories')->onUpdate('cascade')->onDelete('cascade'); $table->foreign('post_id')->references('id')->on('posts')->onUpdate('cascade')->onDelete('cascade'); }); 2022_09_28_021507_create_categories_table.php Schema::create('categories', function (Blueprint $table) { $table->increments('id'); $table->string('name', 100); }); i found…

VIEW QUESTION
Back To Top
Search