Skip to content

PHP Codes Blog

By Nikunj Joshi

Search for
  • PHP
    • PHP Settings
    • OOPs
    • MySQL
    • AngularJS
    • Jquery
    • Javascript
    • HTML
    • Server Apache
    • Server Nginx
  • Laravel
  • Magento
  • WordPress
  • About Nikunj
    • Contact Nikunj
  • Hire Dedicated Developer

Tag: database

MySQL

MySQL Create Table and Data Types

Posted By: Nikunj Joshi December 12, 2019December 12, 2019

Creating Tables in MySQL Tables can be created using CREATE TABLE statement and it actually has the following syntax. CREATE TABLE [IF NOT EXISTS] `TableName` (`fieldname` dataType [optional parameters]) ENGINE …

Read More “MySQL Create Table and Data Types”

MySQL

Connecting to the Mysql Database Server With SSH Commands

Posted By: Nikunj Joshi April 25, 2019April 25, 2019

How to Connect to a MySQL Server Remotely with MySQL How to Install MySQL on Ubuntu If you don’t have MySQL installed on your droplet, you can quickly download it. …

Read More “Connecting to the Mysql Database Server With SSH Commands”

Creating Foreign Keys via Laravel Migration

Posted By: Nikunj Joshi July 4, 2018May 5, 2019

Adding foreign keys with Migrations Laravel really excels at facilitating deft management and navigation of table relations, but you’ll need to understand how to properly configure these relationships before taking …

Read More “Creating Foreign Keys via Laravel Migration”

Create migration file with make:model command

Posted By: Nikunj Joshi July 4, 2018May 5, 2019

How to create migration file with Make:model command Recently I’ve found out a nice little way to speed up generating of database stuff. I used to use make:migration and make:model …

Read More “Create migration file with make:model command”

Create database table when plugin is activated.

Posted By: Nikunj Joshi June 28, 2018October 4, 2019

Creating Custom Database Tables for Your WordPress Plugins Using custom database tables for your WordPress plugins is one of the way that you can greatly improve the kind of plugins …

Read More “Create database table when plugin is activated.”

MySQL

Split a string and loop through values in MySql Trigger

Posted By: Nikunj Joshi June 2, 2018May 5, 2019

Split a string and loop through values in MySql Trigger Below example will explain you to get comma separated string and insert rows in second table through MySQL Trigger. First …

Read More “Split a string and loop through values in MySql Trigger”

Run custom query in Laravel

Posted By: Nikunj Joshi March 29, 2018May 5, 2019

How to run custom query in laravel $users = \DB::select(“SELECT users.*,products.* FROM `users` LEFT JOIN `products` ON users.`id` = products.`user_id` WHERE 1 ORDER BY users.`id` ASC”); For more information please …

Read More “Run custom query in Laravel”

Hire PHP Freelancer

Please like this video and subscribe to my YouTube channel.

Contact

Recent Posts

  • Force User to Verify Email after Registration in Laravel
  • Mutators and Accessors in Laravel
  • Laravel Two-Step Registration
  • Display Featured Products on Homepage in Magento
  • Function array_column() in PHP
  • Disable Timestamps in Laravel
  • Difference between implode and explode function in php
  • Build Single Page Application Using AngularJS
  • Use of the PHP substr_count() function
  • MySQL Create Table and Data Types

Categories

  • AngularJS (1)
  • HTML (1)
  • Javascript (5)
  • Jquery (8)
  • Laravel (34)
  • Magento (8)
  • MySQL (6)
  • OOPs (7)
  • PHP (27)
  • PHP Settings (3)
  • Server Apache (3)
  • Server Nginx (1)
  • Wordpress (5)

Tags

abstract (2) ajax (4) apache (4) array (7) arrays (4) artisan (18) authentication (3) cache (3) class (8) command (7) composer (11) config (2) console (3) controller (7) database (7) errors (4) features (2) function (28) functions (5) html (8) ini (2) javascript (8) jquery (9) Laravel (35) localhost (2) magento (8) method (4) methods (4) migration (5) model (7) mvc (3) mysql (10) notice (2) oops (6) php (66) programming (6) query (2) reviews (2) schedule (4) service (3) ssh (3) trigger (2) view (8) wordpress (4) xampp (3)

Comments

  • JSN Web Solutions on Difference between array_merge and array_combine in php
  • JSN Web Solutions on Laravel Two-Step Registration
  • JSN Web Solutions on Mutators and Accessors in Laravel
  • james on Start / Stop / Restart Apache Web Server Via SSH
  • web design company in coimbatore on Run custom query in Laravel

PHP Codes Blog by Nikunj Joshi

  • Register
  • Log in
PHP Codes Blog By Nikunj Joshi © 2018