w3apex

  Laravel is a powerful PHP web application framework that is widely used for building web applications. One of the strengths of Laravel is its ability to work with various databases. In this tutorial, we will walk through the steps involved in setting up an Oracle database in a Laravel framework. Prerequisites Before we begin, ensure that the following requirements are met: A Laravel project is set up on your machine The Oracle database software is installed and running The Oracle Instant Client is installed on your machine Basic knowledge of Laravel and Oracle database Step 1: Install the Oracle Driver The first step is to install the Oracle driver for PHP. The driver can be installed using the following command: composer require yajra/laravel-oci8 This command will install the Oracle driver and its dependencies in your Laravel project. Step 2: Configure the Oracle Driver Next, we need to configure the Oracle driver. To do this, open the “config/database.php” file in your Laravel...

  How to Install XAMPP on Windows In order to build Laravel applications, we need to install PHP and MySQL on our machine.  The easiest way to install PHP on Windows is through  XAMPP . It is available on all three desktop operating systems—Windows, Linux, and Mac. However, on Mac it's best to use  MAMP , which is compatible with the new M1 and M2 chips. Now let's take a look at how to install XAMMP on Windows.  Go to  https://www.apachefriends.org/download.html  and download the installer for your operating system. Select the latest version of PHP, i.e. the one at the bottom of the list. 1. Install Wizard Double-click the installer, and then follow the prompts.  2. Installer Settings You won’t need to change any of the installation settings—the defaults are all good as is. 3. Installation Folder Of particular note, you should leave the installation drive as the  C:\   drive on Windows in order for things to function correctly. You may a...

  I have very old application. Then I saw some store procedure using (+) or (-) notation on the query. What i want to ask are : 1. what is the difference between (+) and (-) notation ? 2. what is the difference between (the position of the notation I put on left or right) ? SELECT * FROM A, B WHERE A.column = B.column(+) and SELECT * FROM A, B WHERE A.column(+) = B.column 3. I read from forum that notation is only present for backwards compatibility because Oracle debuted it before the ANSI standard for joins. So is there any problem if I'm not change the notation to 'join' statement (ANSI standard) on my old existing query ? 4. Is it recommended or not using notation (+) (-) ? 5. How about the performance. It's good using (+) (-) notation or join notation ? and Chris said... The plus sign is Oracle syntax for an outer join. There isn't a minus operator for joins. An outer join means return all rows from one table. Also return the rows from the outer joined where th...

MVC Architecture  Model–View–Controller (MVC) was the architecture used to develop the system. MVC is a software architectural pattern for implementing user interfaces. It divides a given software application into three interconnected parts, so as to separate internal representations of information from the ways that information is presented to or accepted from the user. MVC is a most applying design pattern because of its flexibility & other central usages.  It is reusable & expressive that allows more readable & mobile [11] .  Following figure shows a diagram of MVC Architecture.  Model Model represents an object or java POJO carrying data. It can also have logic to update controller if its data changes. This layer is independent from other system layers such as, View and Controller. It also governs the rules to access the data objects and perform any kind of operation on them. It knows all details about data which needed to be displayed.  View  View ...

  According to the Harvard Business Review ,  Data Scientist is “The Sexiest Job of the 21st Century”. Is this not enough to know more about data science!   In the world of data space, the era of Big Data emerged when organizations are dealing with petabytes and exabytes of data. It became very tough for industries for the storage of data until 2010. Now when popular frameworks like   Hadoop   and others solved the problem of storage, the focus is on processing the data. And here   Data Science   plays a big role . Nowadays the growth of data science has been increased in various ways and so one should be ready for the future by learning what data science is and how can we add value to it.  What is Data Science? So now the very first question arises is, “ What is Data Science ? ” Data science means different things for different people, but at its gist,  data science is using data to answer questions.  This definition is a moderatel...