How To Use DB Queries In Laravel

How To Use DB Queries In Laravel - Laravel is PHP Framework for Web Application. It is a Free -> Open Source PHP Framework. It's follow the Standard Coding way MVC (Models, Views, Controllers) Concept.
Model -> It mainly interact with the Database. Database Queries like Insert,Update,Select,Delete etc.
Controller -> It's responsible for Users Action and Buisness Logic of the application.
View -> It's most interacting part of the web application for Users.
Now DB Queries - How to use in Laravel code
1.Check the columns in the database table for particular table query is -- 
$columns = DB::select( DB::raw('SHOW COLUMNS FROM TABLE_NAME'));
2. If you want to modify your database table 
DB::statement('ALTER TABLE TABLE_NAME MODIFY COLUMN_NAME DATATYPE NOT NULL');
DB::statement('ALTER TABLE User MODIFY user_id INT(20) NOT NULL');
3. Get data for particular table form database 
DB::select('SELECT * FROM TABLE_NAME');
with where condition
DB::select('SELECT * FROM TABLE_NAME WHERE COLUMN_NAME = "Value" ');
Note: Use DB Class on the top of your class in Laravel

Comments

Post a Comment

If you have any error, bug related to your Prestashop website, Let me know

Popular posts from this blog

Prestashop Create Admin Controller inside Admin Folder

Image
AdminController inside Root Admin Folder In Prestashop, We need to store our manually create Admin Controller in Prestashop Database . We must add our Admin Controller class in tab table also. On the root there is admin folder inside the controllers folder. Inside admin folder create your controller file for eg. like AdminNameController.php and save it. After that Register your Controller in Database -> Tab table. You need to define id for tab in (id_tab) field manually according to increment order.(eg: means if id_tab value is 3 you must set id_tab value 4). Parent id (id_parent) is used for make your controller as child for any parent like under SELL Parent (for SELL id_parent set to 2). Next is Position where do you define the Position of your Controller in ADmin Menu Bar.(like if you set position where you want to show the controller in menu bar count from 0 to end menu in the Sell Tab of menu bar and set according to you in between them or last or on first position. ...
Read more

Prestashop Pass Controller Variables To TPL

Pass Controller Variables To TPL in Prestashop In your Controller you can find the initContent() function, where you pass the Value to required tpl. public function initContent() { //assign value like this $username = 'FreemanDev'; parent::initContent(); //and pass here like this ( 'username' => $username) $smarty = $this->context->smarty; $smarty->assign(array( 'username' => $username, )); $content = $smarty->fetch(_PS_THEME_DIR_.'templates/folder/yourtpl.tpl'); $this->context->smarty->assign(array('content' => $this->content . $content)); } and in your tpl (yourtpl.tpl), you can access the above defined variable using curly braces with html tags or simply write. {$username} where ever you need it... Thanks...
Read more