| Server IP : / Your IP : 10.244.4.16 [ Web Server : nginx/1.25.3 System : Linux escuela-portal-app-54f56585bc-kst6g 5.15.0-1084-azure #93-Ubuntu SMP Sat Mar 15 14:12:29 UTC 2025 x86_64 User : root ( 0) PHP Version : 8.2.13 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals, Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : OFF | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/app/app/Http/Controllers/Managment/ |
Upload File : |
<?php
namespace App\Http\Controllers\Managment;
use App\Http\Controllers\Controller;
use App\Models\Video;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class VideoController extends Controller
{
public function index()
{
return DB::table('videos AS v')
->join('pages AS p', 'v.page_id', 'p.id')
->select('v.id', 'p.name', 'v.name AS title', 'v.url')
->get();
}
public function edit($id)
{
return Video::find($id);
}
public function store(Request $request)
{
$response = false;
try {
DB::transaction(function () use ($request) {
$video = Video::where('page_id', $request->page_id)->first();
if(!isset($video)){
$video = Video::create($request->all());
}
$video->update($request->all());
});
$response = true;
} catch (\Throwable $th) {
$response = $th;
}
return $response;
}
public function update(Request $request, $id)
{
$response = false;
try {
DB::transaction(function () use ($request, $id) {
Video::find($id)->update($request->all());
});
$response = true;
} catch (\Throwable $th) {
$response = $th;
}
return $response;
}
public function destroy($id)
{
try {
DB::transaction(function () use ($id) {
Video::find($id)->delete();
});
$response = true;
} catch (\Throwable $th) {
$response = $th;
}
return $response;
}
}