• Lesson.No : 152
  • 00:07:16

  • #152 view news data by year using YEAR function in sql with mysql

  • Play

Course Lessons

  1. 1- #1 introduction about php8 and what is coming in this course
  2. 2- #2 setup and prepare XAMPP in linux OS
  3. 3- #3 setup and prepare XAMPP on Windows OS
  4. 4- #4 Setup and prepare xampp in Mac OSX
  5. 5- #5 dataType Concept In PHP Part1
  6. 6- #6 dataType Concept Array In PHP part2
  7. 7- #7 dataType Concept Resource in php
  8. 8- #8 dataType concept part3 end lesson
  9. 9- #9 custom functions in php part1
  10. 10- #10 what is the parameterized in custom function part2
  11. 11- #11 LGS Local , Global , Static Scope In Function part3
  12. 12- #12 let's try some internal built in functions and what is the constant
  13. 13- #13 Ternary operator if and else condition and statement part 1
  14. 14- #14 Ternary operator if and elseif with new syntax style
  15. 15- #15 short hand Ternary and null coalescing operator
  16. 16- #16 ternary and null coalescing and spaceship operator
  17. 17- #17 set your multiple condations
  18. 18- #18 switch Statement
  19. 19- #19 for , foreach loop in php
  20. 20- #20 break VS continue in loops
  21. 21- #21 while vs do while loops in php
  22. 22- #22 include VS include once
  23. 23- #23 require VS require once and comparing include VS require
  24. 24- #24 PHP Global Variables Superglobals part 1
  25. 25- #25 PHP Superglobals $_FILES
  26. 26- #26 PHP Superglobals $_SESSION
  27. 27- #27 PHP Superglobals $_COOKIE VS $_SESSION
  28. 28- #28 Magic Constants
  29. 29- #29 echo VS print
  30. 30- #30 comments single or multiline
  31. 31- #31 let's to try some internal built in mathematical Functions
  32. 32- #32 Regular Expression preg_replace part1
  33. 33- #33 Regular Expression preg match part2
  34. 34- #34 Regular Expression preg_match with Metacharacters part3
  35. 35- #35 Regular Expressions preg match practice phone number part4
  36. 36- #36 Regular Expression preg_split & preg_grep part5
  37. 37- #37 Regular Expression search and get data from HTML tags part6
  38. 38- #38 Escaping in php
  39. 39- #39 Directories in PHP with internal built in functions
  40. 40- #40 FileSystem create file or directory and read , write data in file Part1
  41. 41- #41 Filesystem copy and delete files and directory part 2
  42. 42- #42 FileSystem touch function part3
  43. 43- #43 FileSystem symbolic link symlink function part4
  44. 44- #44 FileSystem filesize and filetype part5
  45. 45- #45 FileSystem get and put file contents
  46. 46- #46 Date and DateTime and Timezone
  47. 47- #47 string to time and add extra date or time using strtotime function
  48. 48- #48 parse and diff and check date
  49. 49- #49 get timezone identifiers list and other format in date function
  50. 50- #50 introduce about PHP MySQL Database
  51. 51- #51 How To Connect to mysql database using mysqli connect Procedural function
  52. 52- #52 Create a MySQL Database Using MySQLi and Create First Table using PHPMyadmin GUI
  53. 53- #53 Insert Data Into MySQL Using MySQLi Procedural function
  54. 54- #54 Get ID of The Last Inserted Record using Procedural function mysqli insert id
  55. 55- #55 MySQL Insert Multiple Records using mysqli multi query Procedural function
  56. 56- #56 MySQLi Select Data using Procedural function
  57. 57- #57 MySQL Query Where using Procedural function
  58. 58- #58 Order Data From a MySQL Database using Procedural function
  59. 59- #59 MySQL Update Data Using Procedural function
  60. 60- #60 MySQL Limit Data Selections
  61. 61- #61 MySQL Delete Data Using Procedural function
  62. 62- #62 practicing #1 Let’s start a practical application with owned helper functions
  63. 63- #63 practicing #2 prepare update helper function
  64. 64- #64 practicing #3 prepare delete helper function
  65. 65- #65 practicing #4 create find helper function to retrieve a single row from table in db
  66. 66- #66 practicing #5 create first helper function to retrieve a single row from table in db
  67. 67- #67 practicing #6 create get helper function to fetch multiple rows from table in db
  68. 68- #68 practicing #7 create pagination helper function to make pagination retrieve multiple rows
  69. 69- #69 practicing #8 create session helpers with config
  70. 70- #70 practicing #9 Enhance in helpers file structure and create base_path helper function
  71. 71- #71 practicing #10 prepare and create send mail function to use in registration form
  72. 72- #72 practicing #11Let's To prepare our routing and handling the Hyper Text Access htaccess mode
  73. 73- #73 practicing #12 create routing functions part2
  74. 74- #74 practicing #13 create view and initial routing functions to make our first home pages and header
  75. 75- #75 practicing 14 handling Post Routings
  76. 76- #76 practicing 15 create redirect , session has , session flash functions
  77. 77- #77 practicing 16 create localization functions to translate your labels
  78. 78- #78 practicing #17 create request function and make a first template using bootstrap 5
  79. 79- #79 practicing #18 set bootstrap version and make a dynamic variable in view function
  80. 80- #80 practicing #19 set session path in your project
  81. 81- #81 practicing #20 what is the AES+DES Mode and IV Attack or called Initialization Vectors
  82. 82- #82 practicing #21 make your encrypt and decrypt functions using AES 128 CBC Mode with IV
  83. 83- #83 practicing #22 A small example of Clean Code in native
  84. 84- #84 practicing #23 A small example of writing code comments with PHP doc Tag and how to use ChatGPT
  85. 85- #85 practicing #24 Enhance the index file
  86. 86- #86 practicing #25 move index and htaccess to public folder
  87. 87- #87 practicing #26 create a storage functions to upload files with store file function
  88. 88- #88 practicing #27 create a storage function to readfile or download it
  89. 89- #89 practicing #28 Redirect Trailing Slashes If Not A Folder to Access files in public folder
  90. 90- #90 practicing #29 let's to make our validation functions to secure our attributes with first rule
  91. 91- #91 practicing #30 add required rule on validations
  92. 92- #92 practicing #31 add integer rule validation and bind rules & translate attributes in one array
  93. 93- #93 practicing #32 make string validation and unset old offset on validation when print
  94. 94- #94 practicing #33 handling errors style
  95. 95- #95 practicing #34 fix the view error unset before show last error
  96. 96- #96 practicing #35 handling redirect in to self in validation function and call back errors as api
  97. 97- #97 practicing #36 old function to return old value in inputs
  98. 98- #98 practicing #37 make your first template engine generator
  99. 99- #99 practicing #38 enhance in caching template file to replace if statement and foreach as example
  100. 100- #100 practicing #39 Preparing tools to build a dashboard using bootstrap5
  101. 101- #101 practicing #40 initial and setup template in dashboard
  102. 102- #102 practicing #41 add custom header and set locale rtl and ltr
  103. 103- #103 practicing #42 add login page with form and validations part1
  104. 104- #104 practicing #43 add login page with validations and create back,bcrypt,hash check functions
  105. 105- #105 practicing #44 create auth,logout function and make session authenticate admin to sign in
  106. 106- #106 practicing #45 check if user is admin or not part4
  107. 107- #107 practicing #46 categories CRUD Operation C-Create part1
  108. 108- #108 practicing #47add image rule C-Create part2
  109. 109- #109 practicing #48 insert data in to categories and enhance redirect function C-Create part3
  110. 110- #110 practicing #49 make some change in redirect and view engine functions
  111. 111- #111 practicing #50 CRUD Operation R-Read
  112. 112- #112 practicing #51 CRUD Operation U Update and create redirect if function
  113. 113- #113 practicing #52 CRUD Operation D Delete and create image and delete record functions
  114. 114- #114 practicing #53 add bootstrap pagination on render with full functionality next , Previous page
  115. 115- #115 practicing #54 Add news CRUD Operation table and create relationship with user and category
  116. 116- #116 practicing #55 Add news CRUD Operation create template , controller and localizations part2
  117. 117- #117 practicing #56 Add news CRUD Operation C-Create part3
  118. 118- #118 practicing #57 Add news CRUD Operation U Update and setup CKeditor with Textarea part4
  119. 119- #119 practicing #58 Add news CRUD Operation R-Read part5
  120. 120- #120 practicing #59 Add news CRUD Operation D-Delete part6
  121. 121- #121 practicing #60 get user and category using Join
  122. 122- #122 practicing #61 translate Your localization files using AI ChatGPT
  123. 123- #123 practicing #62 Create New CRUD Operations to Manage Users part1
  124. 124- #124 practicing #63 Create New CRUD Operations to manage Users part2
  125. 125- #125 practicing #64 add unique Validation rule to check if value like email or mobile already used
  126. 126- #126 practicing #65 add rule called in to check if value in array or not
  127. 127- #127 practicing #66 let's to organize the error validation messages in new place like header
  128. 128- #128 practicing #67 add toastr.js to show success message when create , update and deleted record
  129. 129- #129 PHP Streams I/O how to Run Code In Terminal as CLI part1
  130. 130- #130 PHP Streams I/O Retrieve input from Terminal using readline and STDIN part2
  131. 131- #131 PHP Streams I/O print Output in Terminal using STDOUT part3
  132. 132- #132 PHP Streams I/O Make your first Command using $argv or $_SERVER['argv'] part4
  133. 133- #133 setup front end design using blog bootstrap example part1
  134. 134- #134 setup direction rtl & ltr and split design to header and footer part2
  135. 135- #135 fetch the navbar categories in frontend
  136. 136- #136 fetch news when show category
  137. 137- #137 show article by id with relationship author and category
  138. 138- #138 create comments on news part1
  139. 139- #139 create comments on news part2
  140. 140- #140 create comments on news part3
  141. 141- #141 create comments on news sending data by ajax part4
  142. 142- #142 create comments on news handle the validation error message part5
  143. 143- #143 HTTP response status codes part6
  144. 144- #144 handle error messages in front part7
  145. 145- #145 add exists new validation rule and add comment in database part8
  146. 146- #146 fetch comments as paginate and appends request part9
  147. 147- #147 make some enhance in comments with blackbox ai part10
  148. 148- #148 add new response helper function and create Comments CRUD part11
  149. 149- #149 add relation one to one Join News with comments part12
  150. 150- #150 show latest news in home page
  151. 151- #151 how to group by Data and how to change the strict sql mode in db to specific database
  152. 152- #152 view news data by year using YEAR function in sql with mysql
  153. 153- #153 add latest news and this is a end of story in php native and what comes in OOP
  154. 154- #154 what is OOP Object Oriented Programming in PHP
  155. 155- #155 what is class and what is the difference between class and object
  156. 156- #156 what is inheritance in OOP ?
  157. 157- #157 public props vs protected props in OOP
  158. 158- #158 what is the private props in OOP
  159. 159- #159 what is the type of methods in OOP
  160. 160- #160 what is the constant and types public , protected and private scope
  161. 161- #161 overwrite on public props and dynamic props are deprecated in v8.3 from php
  162. 162- #162 run Object with Instance or without instance
  163. 163- #163 __construct and __destruct with assign props
  164. 164- #164 methods in OOP with arguments and data types
  165. 165- #165 Programming vs Business
  166. 166- #166 Encapsulation in OOP
  167. 167- #167 Nullable Type hint in OOP
  168. 168- #168 readonly props in OOP
  169. 169- #169 what is the static methods in OOP part1
  170. 170- #170 static methods and static props vs non static methods and non static props in OOP part2
  171. 171- #171 run class in to self
  172. 172- #172 how to make a singleton class in OOP
  173. 173- #173 the magic methods __sleep and __wakeup
  174. 174- #174 the magic methods __call and __callStatic
  175. 175- #175 the magic methods __get and __set - getter and setter
  176. 176- #176 the magic methods __isset and __unset
  177. 177- #177 the magic methods __toString and __invoke
  178. 178- #178 the magic methods __clone and clone
  179. 179- #179 the magic methods __set_state
  180. 180- #180 what is the interface in OOP
  181. 181- #181 abstract vs interface in OOP
  182. 182- #182 what is the traits in OOP
  183. 183- #183 what is the namespace in OOP in php
  184. 184- #184 rename everything in namespace OOP
  185. 185- #185 Chaining Methods in OOP
  186. 186- #186 Recursion in php native and OOP
  187. 187- #187 Named Parameters in OOP
  188. 188- #188 Preventing inheritance class or methods through final
  189. 189- #189 Enumeration (enum) in OOP
  190. 190- #190 Polymorphism in OOP
  191. 191- #191 Exception Handling try and catch and finally in OOP
  192. 192- #192 End of OOP Lessons and what's comes in PSR
  193. 193- #193 PSRs VS PERs php fig org
  194. 194- #194 PSR 1: Basic Coding Standard
  195. 195- #195 PSR 2: Coding Style Guide
  196. 196- #196 PSR 3 and PSR 4 autoloading files and install composer with Windows or Linux or mac OSx
  197. 197- #197 how to generate composer json with PSR4 autoloading - composer init
  198. 198- #198 Let's discover the composer and dumping command to regenerate files again
  199. 199- #199 composer environment and json structure with install or remove packages and more
  200. 200- #200 Autoload mapping for a PHP autoloader - PSR 4 and 0
  201. 201- #201 composer keywords , prefer-stable , repositories
  202. 202- #202 Single Responsibility Principle - SRP
  203. 203- #203 Open/Closed Principle - OCP
  204. 204- #204 Liskov Substitution Principle - LSP
  205. 205- #205 Interface Segregation Principle - ISP
  206. 206- #206 Dependency Inversion Principle - DIP
  207. 207- #207 MVC architecture - what's coming
  208. 208- #208 mvc installations
  209. 209- #209 make router class part1
  210. 210- #210 make router class part2
  211. 211- #211 add route class and make a first helper file auto loader in the framework
  212. 212- #212 how to make a dynamic routes
  213. 213- #213 add anonymous function to route with retrieve dynamic arguments
  214. 214- #214 create Hash and Session class to start session on your MVC
  215. 215- #215 move session settings and define ROOT_PATH constant
  216. 216- #216 let's start to build a Middleware structure in Route
  217. 217- #217 use middleware in anonymous function Route
  218. 218- #218 add role to Middleware
  219. 219- #219 Get middleware from Core Web or Api
  220. 220- #220 let's to make api routes
  221. 221- #221 let's build a Segment class
  222. 222- #222 let's to make prefix group and middleware for this group to add role for all group routes
  223. 223- #223 finalize prefix in dispatch method
  224. 224- #224 let's to create Log Exception
  225. 225- #225 let's to create View class
  226. 226- #226 Create a view cache to preserve server resources
  227. 227- #227 create mvc config app to set and get timezone
  228. 228- #228 setLocale and getLocale on mvc with web and api routes
  229. 229- #229 parse url to fix issue and setLocale using Middleware on api routes
  230. 230- #230 create SessionHandler with SessionHandlerInterface
  231. 231- #231 enhance SessionHandler to save all sessions
  232. 232- #232 make Lang translation has and path methods
  233. 233- #233 get values and make trans helper function
  234. 234- #234 get value from fallback lang
  235. 235- #235 let's start change Lang class to Clean Code with a little steps
  236. 236- #236 make attributes to change flags on string
  237. 237- #237 make controller and validation class with a first method Required
  238. 238- #238 make a first error list using required method
  239. 239- #239 call any validation method by dynamic name
  240. 240- #240 enhance Log and Lang Class to solve some issue and add string , integer validation
  241. 241- #241 let's start to create numeric validation
  242. 242- #242 let's start to create json validation
  243. 243- #243 let's start to create array validation
  244. 244- #244 check value in specific value on array validation
  245. 245- #245 enhance validation class to make a clean code
  246. 246- #246 get validated values from validation
  247. 247- #247 create in validation method
  248. 248- #248 create email validation method
  249. 249- #249 create unique validation method
  250. 250- #250 create exists validation method
  251. 251- #251 make a validated and failed methods with using validation in baseController
  252. 252- #252 let's start to create Request Class to handle all requests values
  253. 253- #253 make file and store methods
  254. 254- #254 finalize store method with rename file before store
  255. 255- #255 create symbolic link with storage in public folder to get uploaded files
  256. 256- #256 what is the CSRF and how can make it ? part #1
  257. 257- #257 what is the CSRF and how can make it ? create csrf token and csrf field functions part #2
  258. 258- #258 what is the CSRF and how can make it ? use CSRF in Core last part
  259. 259- #259 let's start to clean some codes ;(
  260. 260- #260 what's ORM Object-Relational Mapping
  261. 261- #261 let's start to make our Database Connections Type-MySQL #part1
  262. 262- #262 let's start to make our Database Connections Type-SQLite #part2
  263. 263- #263 create BaseModel to select type of database #par3
  264. 264- #264 create database in mysql to make a first connection #part4
  265. 265- #265 test connections to mysql or sqlite #part5
  266. 266- #266 Let's do some improvements and create a first properties for the table property auto convention
  267. 267- #267 Dynamic Field Setup in Our Model for Database Interaction
  268. 268- #268 Understanding the Single Responsibility and Retrieving Object Names Using ReflectionClass
  269. 269- #269 build DBCondations Trait to using with BaseModel
  270. 270- #270 prepare condition values to bind in PDO Param
  271. 271- #271 build find method
  272. 272- #272 set database connection and solve some problems
  273. 273- #273 Completion of find method and utilizing the data after storing
  274. 274- #274 convert object to array after execute data
  275. 275- #275 build a first method and enhance some methods to get more benefits in ORM strategy
  276. 276- #276 let's to fetchAll data and create get and all methods in ORM
  277. 277- #277 let's to create Collection class to convert data to Array in get or all methods
  278. 278- #278 add limit , offset , take methods in ORM
  279. 279- #279 add count method in ORM
  280. 280- #280 create Paginator & pagination method class part1
  281. 281- #281 finalize the paginate method
  282. 282- #282 let's to test the paginate method with Some enhancements
  283. 283- #283 use the IteratorAggregate and ArrayIterator to make Paginator class as a loop
  284. 284- #284 let's to create pagination number of pages using bootstrap 5