Learn With OJ | Tech Blog | ebooks

SQL tutorial and full course

If you call this function with 1, it should select the note where id = 1, the first note. This will also work if we pass in 2 because there is a note with the id 2. But if we try and call this with 3, then we end up with an empty array because no note exits. Selecting always returns an array because there could be multiple rows, but in this case, we know there will only be at most one returned here

SQL (Structured Query Language) is a programming language which is used to manage data stored in relational databases like MySQL, MS Access, SQL Server, Oracle, Sybase, Informix, Postgres etc

It makes configuration easier. In development, i'm connecting to a database on localhost, but in production, i'm going to be connecting to a database on a different machine. And if I have a staging environment, i'm going to be connecting to a database on a different machine. So I want to make it really easy to change the database connection information without having to actually update the code. Especially handy if the person deploying the application is not the same person who wrote the backend code.

DOWNLOAD

Programming Posts

MySQL and Node Tutorials

This is where we tell the library how to connect to our database. By creating a pool, we can reuse connections to the database instead of all ways opening and closing connections. This will improve performance once your app is hosted and you have a lot of users

MySQL with PHP (Hypertext Preprocessor)

The data in a MySQL database are stored in tables. A table is a collection of relateddata, and it consists of columns and rows. Databases are useful for storing information categorically. A company may have a database with the following tables:

PHP Form Handling

Get request is the default form request. The data passed through get request is visible on the URL browser so it is not secured. It is an associative array of variables passed to the current script via the URL parameters (aka. query string). Note that the array is not only populated for GET requests,...

How to Find the Wi-Fi Password Using CMD in Windows

Forgotten your Wi-Fi password? Don't worry you're not alone! Whether you're trying to connect a new phone, set up a smart TV, or help a friend get online, remembering complex Wi-Fi passwords...

SQL (Structured Query Language)

It is a domain-specific language used to manage and manipulate data, particularly within relational database management systems (RDBMS). SQL provides a standardized way to interact with databases, enabling users to perform various operations such as...