The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return…
Some time we need concat multiple fields with pluck function in laravel Here we describe how use multiple columns in pluck function use of concat public function get_course() { $course_type = $_GET['course_type']; $courseArray = DB::table('courses')->where(['status' => 0, 'course_type' => $course_type]) ->orderBy('name', 'asc') ->pluck(DB::raw('CONCAT(name," -->",duration_in_month, " Months") AS name'),'id'); return json_encode($courseArray); }
What is SSL? SSL certificates are what enable websites to move from HTTP to HTTPS, which is more secure. An SSL certificate is a data file hosted in a website's origin server. SSL certificates make SSL/TLS encryption possible, and they contain the website's public key and the website's identity, along with related information. Devices attempting to communicate with the origin…
By default, Laravel Eloquent models assume your table has timestamp fields – created_at and updated_at. But there’s plenty of things you can do to customize them or perform some interesting operations. Deepcool Fan Hub Control 4PWM Fan Speed Supports Fan with 3Pin/4Pin Cooling FH-04 If your database table doesn’t have those fields, and you will try to do something like…
Excel Formulas and Functions (Commands): Here we explain Advanced Excel Formulas and Basic Excel Functions? This Blogpost will give you the Excel formulas list of the Key Functions of Excel. The Excel Functions covered here are: VLOOKUP, INDEX, MATCH, RANK, AVERAGE, SMALL, LARGE, LOOKUP, ROUND, COUNTIFS, SUMIFS, FIND, DATE, and many more Excel Formulas can help you save time: Count…
Sometimes we need insert multiple booking date in the database behalf of the same add_id I have a form to book ads for multiple dates, which are selected by using a calendar in the form and then posted in JSON format. An example would be: but I am having a problem storing this json string for each ad. How would…
What Are HTTP And HTTPS? HTTP is the cornerstone web technology that helps to transmit and share information across the WWW. HTTPS is the second version of HTTP. It will make the Internet a safe haven for day-to-day transactions like eCommerce, Internet banking, instant messaging, video chat, file transfer, cloud storage, etc. SSL Makes All The Difference The key point…
I have a main activity that has simple buttons and listeners associated with them. Each button opens a new activity . However while opening activity, it takes some time to load which causes a UI freeze. I want to avoid this by simply adding a loading circle in between. That is a Progress Bar. You may create this programmatically or…
This Free database does not guarantee for the complete list of world countries, states and cities. Seeking Country/State/City Database? Here You got a list of Countries, States and Cities. Country List is SQL/Msql CREATE TABLE IF NOT EXISTS `countries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sortname` varchar(3) NOT NULL, `name` varchar(150) NOT NULL, `phonecode` int(11) NOT NULL, PRIMARY KEY (`id`)…
I try again and again to test sending an email from local system (localhost) but I still cannot. Solution All you have to do is just edit in you.env file, that's it. MAIL_DRIVER=smtp MAIL_HOST=smtp.gmail.com MAIL_PORT=465 MAIL_USERNAME=<your_email_address> MAIL_PASSWORD=<your_gmail_app_password_> MAIL_ENCRYPTION=ssl
