JavaScript Code Editors Summary: in this tutorial, you will learn about JavaScript code editors and how to install the Visual Studio Code for coding JavaScript. Popular JavaScript Code Editors To edit JavaScript source code, you need a plain text editor such as Notepad on Windows. However, to simplify and speed up typing of JavaScript code,…
Read more
What is JavaScript JavaScript is a programming language initially designed to interact with elements of web pages. In web browsers, JavaScript consists of three main parts: ECMAScript provides the core functionality. The Document Object Model (DOM) provides interfaces for interacting with elements on web pages The Browser Object Model (BOM) provides the browser API for…
Read more
JavaScript Tutorial Welcome to the python-tutorials.in website! This JavaScript Tutorial helps you learn the JavaScript programming language from scratch quickly and effectively. If you… Are not sure where to start learning JavaScript. Are frustrated with copy-n-paste JavaScript code from others without really understanding it. Cannot add richer and more compelling features to your websites and…
Read more
PHP PDO Transaction Summary: in this tutorial, you will learn how to perform a database transaction from PHP by using PDO API. Introduction to PHP PDO transaction To start a transaction in PDO, you use the PDO::beginTransaction() method: $pdo->beginTransaction(); Code language: PHP (php) The beginTransaction() method turns off the autocommit mode. It means that the…
Read more
Call a MySQL Stored Procedure Using PHP PDO Summary: in this tutorial, you will learn how to call a MySQL stored procedure using the PHP PDO. Setting up a stored procedure in MySQL To execute a statement in the MySQL database, you can use any MySQL client tool e.g., mysql client tool or MySQL Workbench.…
Read more
PDO FETCH_CLASS Summary: in this tutorial, you’ll learn how to use the PDO::FETCH_CLASS mode to fetch data into an object of a class. Introduction to the PDO::FETCH_CLASS mode Suppose that you have the following books table in the database: CREATE TABLE IF NOT EXISTS books ( book_id INT AUTO_INCREMENT, title VARCHAR(255) NOT NULL, isbn VARCHAR(13)…
Read more
PDO FETCH_GROUP Summary: in this tutorial, you’ll learn how to use the PDO::FETCH_GROUP mode to group the selected rows by the first column. Introduction to the PDO::FETCH_GROUP mode The PDO::FETCH_GROUP allows you to group rows from the result set into a nested array, where the indexes will be the unique values from the column and…
Read more
PDO FETCH_KEY_PAIR Summary: in this tutorial, you’ll learn how to use the PDO FETCH_KEY_PAIR mode to select data from a table. Introduction to the PDO FETCH_KEY_PAIR mode Both fetch() and fetchAll() methods accept a very useful fetch mode called PDO::FETCH_KEY_PAIR. The PDO::FETCH_KEY_PAIR mode allows you to retrieve a two-column result in an array where the…
Read more
fetchObject Summary: in this tutorial, you’ll learn how to use the fetchObject() method to fetch the next row from a result set and returns it as an object. Introduction to the fetchObject() method Suppose that you have a pulishers table: CREATE TABLE IF NOT EXISTS publishers ( publisher_id INT AUTO_INCREMENT, name VARCHAR(255) NOT NULL, PRIMARY…
Read more
fetchColumn Summary: in this tutorial, you’ll learn how to use the fetchColumn() method to get a single column from the next row of a result set. Introduction to fetchColumn() method Sometimes, you want to get the value of a single column from the next row of a result set. In this case, you can use…
Read more