×
الرئيسية إنشاء سيرة ذاتية دورات تدريبية الأختبارات
قناة منصة معارف علي التليجرام الاقوي عربيا .. اشترك الآن

شرح [ Learn PHP 5 In Arabic ] #98 - Filter - Validate vs Sanitize | [معتمد]

دورة برمجة المواقع بإستخدام PHP

إخفاء جميع الإعلانات
شارك الآن استفساراتك مع اعضاء دورة برمجة المواقع بإستخدام PHP اضغط هنا
إخفاء جميع الإعلانات
سجل الان للحصول على دورات تدريبية معتمدة مع إمكانية إستخراج شهادة إتمام الدورة مجانا
سجل الآن
قائمة الدروس | 103 درس
مشاهدة المزيد من الدروس

التعليقات

أفضل قنوات التليجرام لمختلف المجالات
قنوات تساعدك بكل سهولة على الوصول للمصادر التعليمية و الوظائف و النصائح المهنية و المنح الدراسية

اشترك الآن مجانا

نحن نهتم بتقيمك لهذه الدورة

كن اول شخص يقوم بتقيم هذه الدورة

ممتاز
0 تقيمات
جيد
0 تقيمات
متوسط
0 تقيمات
مقبول
0 تقيمات
سئ
0 تقيمات
0.0
0 تقيمات

Section 1: Let’s Start With PHP Introduction - what and why PHP? Installing Tools Start PHP Syntax echo tag and comments PHP Variables and Constants Variable Data Types – Variable Variables String Data Type Manipulation Mathematical Operators Comparison Operators If else statements Switch case Loops – while, do Loops – for, continue, break User Defined Functions Local and Global Variables Static Variable Arrays More About Arrays Looping Through Array Elements Super GLOBALS part1 Super GLOBALS part2 Include and require Form Handling – Create HTML Form Form Handling – Start Validate inputs Form Handling – ctype functions Form Handling – PHP Filters Form Handling – image Upload Form Handling – Finish your Form – Part 1 Form Handling – Finish your Form – Part 2 Calling header function SESSIONS Section 2: Let’s Start with MYSQL Database What is MYSQL? How to create a database and database table MYSQL and PHP connection Inserting data into database Get last inserted id – Update auto increment start value Retrieving data from database Where clause LIKE, BETWEEN, NOT, IN – ORDER BY Some MYSQL function Update Database Data Delete Data from Database
×

يجب ان يكون لديك حساب داخل المنصة
حتى تستطيع المشاركة و التفاعل مع التعليقات

سجل الآن مجانا
Request history8.1.2PHP Version239msRequest Duration4MBMemory UsageGET lesson/{lesson_id}Route
    • Booting (176ms)time
    • Application (62.91ms)time
    • 1 x Booting (73.66%)
      176ms
      1 x Application (26.34%)
      62.91ms
      31 templates were rendered
      • courses.lessonlesson.blade.php#?blade
      • ads.lesson_top_fixed_boxlesson_top_fixed_box.blade.php#?blade
      • ads.lesson_after_buttonlesson_after_button.blade.php#?blade
      • inc.share_boxshare_box.blade.php#?blade
      • pages.telegram_boxtelegram_box.blade.php#?blade
      • inc.review_formreview_form.blade.php#?blade
      • ajax.review_userreview_user.blade.php#?blade
      • ads.lesson_bottomlesson_bottom.blade.php#?blade
      • beta.partials.home.sections.courses.coursecourse.blade.php#?blade
      • beta.partials.home.sections.courses.coursecourse.blade.php#?blade
      • beta.partials.home.sections.courses.coursecourse.blade.php#?blade
      • beta.partials.home.sections.courses.coursecourse.blade.php#?blade
      • beta.partials.home.sections.courses.coursecourse.blade.php#?blade
      • beta.partials.home.sections.courses.coursecourse.blade.php#?blade
      • beta.partials.home.sections.courses.coursecourse.blade.php#?blade
      • beta.partials.home.sections.courses.coursecourse.blade.php#?blade
      • beta.layouts.mainmain.blade.php#?blade
      • beta.layouts.partials.notifications_modalnotifications_modal.blade.php#?blade
      • beta.layouts.partials.navbarnavbar.blade.php#?blade
      • beta.layouts.partials.menumenu.blade.php#?blade
      • beta.layouts.partials.student-menustudent-menu.blade.php#?blade
      • beta.layouts.partials.search-input-desktopsearch-input-desktop.blade.php#?blade
      • student.login_Adminlogin_Admin.blade.php#?blade
      • beta.layouts.partials.search-modalsearch-modal.blade.php#?blade
      • beta.layouts.partials.search-input-mobilesearch-input-mobile.blade.php#?blade
      • beta.layouts.partials.mobile-navbarmobile-navbar.blade.php#?blade
      • beta.layouts.partials.mobile-sidebarmobile-sidebar.blade.php#?blade
      • beta.layouts.partials.bottom_navigation_barbottom_navigation_bar.blade.php#?blade
      • student.partials.list_modallist_modal.blade.php#?blade
      • inc.messagesmessages.blade.php#?blade
      • beta.layouts.partials.footerfooter.blade.php#?blade
      uri
      GET lesson/{lesson_id}
      middleware
      web, search_keywords
      controller
      App\Http\Controllers\courseCerController@lessonPage
      namespace
      App\Http\Controllers
      prefix
      where
      file
      app/Http/Controllers/courseCerController.php:227-322
      11 statements were executed5.2ms
      • select * from `links_maps` where `from_url` = 'https://new.m3aarf.com/lesson/568' limit 1
        190μsstagingLinkMap.php#20
        Bindings
        • 0: https://new.m3aarf.com/lesson/568
        Backtrace
        • 16. middleware::link_map:20
        • 17. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
        • 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 20. app/Http/Middleware/LoginUsersFromApp.php:30
      • select `id`, `title`, `course_id`, `link`, `youtube_descr`, `image`, `is_work` from `lessons` where `id` = '568' and `lessons`.`deleted_at` is null limit 1
        170μsstagingcourseCerController.php#230
        Bindings
        • 0: 568
        Backtrace
        • 16. app/Http/Controllers/courseCerController.php:230
        • 17. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • 18. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • 20. app/Http/Controllers/courseCerController.php:231
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select count(*) as aggregate from `lessons` where `course_id` = 31 and `lessons`.`deleted_at` is null
        440μsstagingcourseCerController.php#241
        Bindings
        • 0: 31
        Backtrace
        • 16. app/Http/Controllers/courseCerController.php:241
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `title`, `id`, `link`, `image` from `lessons` where `course_id` = 31 and `lessons`.`deleted_at` is null limit 60 offset 0
        310μsstagingcourseCerController.php#241
        Bindings
        • 0: 31
        Backtrace
        • 16. app/Http/Controllers/courseCerController.php:241
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `course` where `id` = 31 and `course`.`deleted_at` is null limit 1
        240μsstagingcourseCerController.php#243
        Bindings
        • 0: 31
        Backtrace
        • 17. app/Http/Controllers/courseCerController.php:243
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `course`.*, (select count(*) from `lessons` where `course`.`id` = `lessons`.`course_id` and `lessons`.`deleted_at` is null) as `lessons_count` from `course` where `cat_id` = 11 and `is_certified` = 1 and `course`.`deleted_at` is null limit 8
        2.66msstagingcourseCerController.php#245
        Bindings
        • 0: 11
        • 1: 1
        Backtrace
        • 15. app/Http/Controllers/courseCerController.php:245
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `id`, `title`, `slug`, `cer_title` from `courses` where `id` = 11 and `courses`.`deleted_at` is null limit 1
        180μsstagingcourseCerController.php#247
        Bindings
        • 0: 11
        Backtrace
        • 16. app/Http/Controllers/courseCerController.php:247
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `community` where `course_id` = 31 and `community`.`deleted_at` is null limit 1
        210μsstagingcourseCerController.php#248
        Bindings
        • 0: 31
        Backtrace
        • 16. app/Http/Controllers/courseCerController.php:248
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select max(`id`) as aggregate from `lessons` where `id` < '568' and `course_id` = 31 and `lessons`.`deleted_at` is null
        370μsstagingcourseCerController.php#299
        Bindings
        • 0: 568
        • 1: 31
        Backtrace
        • 16. app/Http/Controllers/courseCerController.php:299
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select min(`id`) as aggregate from `lessons` where `id` > '568' and `course_id` = 31 and `lessons`.`deleted_at` is null
        240μsstagingcourseCerController.php#300
        Bindings
        • 0: 568
        • 1: 31
        Backtrace
        • 16. app/Http/Controllers/courseCerController.php:300
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `course_reviews` where `course_id` = 31 limit 1
        190μsstaginghelper.php#420
        Bindings
        • 0: 31
        Backtrace
        • 16. app/helpers/helper.php:420
        • 18. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • 20. app/helpers/helper.php:421
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      App\lessons
      61lessons.php#?
      App\course
      9course.php#?
      App\courses
      1courses.php#?
      App\Community
      1Community.php#?
          _token
          UHeNByxbtLSkeFNxaVJjEXTWT5Gt64Hy6dVvI2ce
          PHPDEBUGBAR_STACK_DATA
          []
          _flash
          array:2 [ "new" => [] "old" => [] ]
          path_info
          /lesson/568
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "host" => array:1 [ 0 => "new.m3aarf.com" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 09 May 2025 06:34:02 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InRsYjBJUWthQ3duZ0pMYXVaVDhObWc9PSIsInZhbHVlIjoiY0w1SFJGKzArZEJzWUVtZk9Rc295M0pzYzFTRnlaVHFhaVdxYnZrRFRGaUx2L1pxV041WmZtZTBhTkt1cWtOVnQxV2pMdGs5Mjc5MUtSRHc5V1NSVXJlRzMxYVkvdkxBcXJ5bFFuSDVwTFBETTRVUWpSeHo3SWtoeHA1bUlPaEIiLCJtYWMiOiIzZGRlZjVmNTVlY2Y2ODJlZjExMjFmMTQwMzFmODE2Mjc0MmVlYmVhZGM0MGIwMWEzZjRiM2QzNjU3MmJiNDQzIiwidGFnIjoiIn0%3D; expires=Fri, 09 May 2025 08:34:02 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InRsYjBJUWthQ3duZ0pMYXVaVDhObWc9PSIsInZhbHVlIjoiY0w1SFJGKzArZEJzWUVtZk9Rc295M0pzYzFTRnlaVHFhaVdxYnZrRFRGaUx2L1pxV041WmZtZTBhTkt1cWtOVnQxV2pMd" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InRsYjBJUWthQ3duZ0pMYXVaVDhObWc9PSIsInZhbHVlIjoiY0w1SFJGKzArZEJzWUVtZk9Rc295M0pzYzFTRnlaVHFhaVdxYnZrRFRGaUx2L1pxV041WmZtZTBhTkt1cWtOVnQxV2pMdGs5Mjc5MUtSRHc5V1NSVXJlRzMxYVkvdkxBcXJ5bFFuSDVwTFBETTRVUWpSeHo3SWtoeHA1bUlPaEIiLCJtYWMiOiIzZGRlZjVmNTVlY2Y2ODJlZjExMjFmMTQwMzFmODE2Mjc0MmVlYmVhZGM0MGIwMWEzZjRiM2QzNjU3MmJiNDQzIiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 08:34:02 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InRsYjBJUWthQ3duZ0pMYXVaVDhObWc9PSIsInZhbHVlIjoiY0w1SFJGKzArZEJzWUVtZk9Rc295M0pzYzFTRnlaVHFhaVdxYnZrRFRGaUx2L1pxV041WmZtZTBhTkt1cWtOVnQxV2pMd" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "UHeNByxbtLSkeFNxaVJjEXTWT5Gt64Hy6dVvI2ce" "PHPDEBUGBAR_STACK_DATA" => [] "_flash" => array:2 [ "new" => [] "old" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-09 09:34:02GET/lesson/568311172