This laravel tutorial help to add CRUD operation with datatable, I will just share laravel code to create new record, edit record and delete record. I have already shared How To Use jQuery Datatable With Laravel.We have integrated jQuery datatable with laravel. We will cover following functionality in this laravel tutorial : Create record Template […]
I have had some requests to write some blogs on the basics of
using PHP and MySQL together. This will not be a series for
the experienced as it will start at a level where I will go into
a lot of details but expect very few prerequisites from the
reader. If this is not you, please move on. If it is you
and you read something you do not understand, please contact me
to show me where I assumed too much.
PHP and MySQL are both in their mid twenties and both vital in the worlds of developers. With the big improvements in PHP 7 and MySQL 8, I have found a lot of developers flocking to both but stymied by the examples they see as their are many details not explained. So let's get to the explaining!
1. Use the latest software
If you are not using PHP 7.2 or 7.3 (or maybe 7.1) then you are missing out in features and performance. The PHP 5.x series is deprecated, no longer support, and …
IS NOT NULL, truthiness among
other assertions on MySQL and PostgreSQL
can one thing be equal to the other, i.e.
undefined evaluates to
true unless you use
the triple equals
===. Other dynamic typed languages
have its peculiarities, such as Ruby where
0 == true evaluates to
true, the reason
for Ruby is that considers
0 as a value and any
value evaluates to
How about SQL? The answer is… it depends.
Which database are you using?
Some may be more forgiving, like MySQL doing casts for you all over the place, or more strict like PostgreSQL where you can only compare the truthiness of something of the same type.
I stopped freelancing on upwork in 2011. I used to be a part-time freelancer on upwork (previously known as oDesk) from 2008 to 2011 besides my full-time job. Since 2011, I have been developing my own Indie mobile apps which is a great success for me and in my career.
I am still earning very good passive income from my own portfolio apps, today I will discuss why I have started freelancing again.
1. Indie Developing
There is a saying:
If you walk alone you can go faster
If you walk in group you can go further
This tutorial help to upload files using Laravel 5.7.We will create html form view that upload file into server and save path information into MySQL table. We will use MySQL and php 7 to create file upload functionality. File Upload Using Laravel 5.7 and Mysql Lets create new laravel application using laravel CLI. The Artisan […]
The Symfony Frame work is very popular with PHP
developers and it has a very nice Demo
Application to help novices learn the intricacies
involved. But the demo does not use MySQL. So this blog
entry is about re configuring the demo so it works with MySQL 8.
And I am using Ubuntu 18.04 LTS to you may have to adjust the
following commands to work with your operating system.
This is not difficult but there are some steps that are not exactly self evident that this blog will show you how to get the demo working.
The first thing to do is to make sure you have PHP 7.2 or better installed including the php7.2-intl (sudo apt-get install php7.2-intl) package as well as the PDO connector. I will admit I have been using PHP since it appeared and this …
Many people want to be web developer. But not many people know how and where to start. In this 10 steps guideline, I discuss how to be a web developer from Zero experience with my recommended books.
I created this guidelines based on my web development experience and recent trends. Personally I read most of the books I recommended here.
1. HTML & CSS
First step of becoming a web developer is to learning the fundamental of HTML and CSS. These are the building blocks of website or web application development. Normally a web developer doesn’t have to be a master of CSS as Web designer do this job. But sometimes for simple modification its way better to fix by oneself than asking the designer.
Recommended Books for HTML and CSS
I am currently working my way through the many PHP Frameworks to
see how they get on with MySQL 8. The Frameworks that can
take advantage of the MySQL Improved Extension or mysqli
can take advantage of the SHA256 Caching Authentication method.
But those that are PDO based need to use the older MySQL Native
I wanted to check the PDO based frameworks and today I just happened to be wearing the very nice Symfony shirt I received as part of my presentation at Symfony USA. So I started with a fresh install of Symfony. All was going well until it came time to get it to work with MySQL 8 through Doctrine.
Symfony uses Doctrine as an ORM (Object Relational Mapper) and DBAL (Database Abstraction Layer) as an intermediary to the database. While I myself am not a big fan of ORMs …