Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
- Article Categories
- Book Categories
- Collections
- Custom Solutions
- Log In
- Main Menu
Article Categories
- Main Menu
Book Categories
Home
PHP, MySQL, & JavaScript All-in-One For Dummies
Author:
Published:
April 10, 2018
Overview
Explore the engine that drives the internet It takes a powerful suite of technologies to drive the most-visited websites in the world. PHP, mySQL, JavaScript, and other web-building languages serve as the foundation for application development and programming projects at all levels of the web. Dig into this all-in-one book to get a grasp on these in-demand skills, and figure out how to apply them to become a professional web builder. You’ll get valuable information from seven handy books covering the pieces of web programming, HTML5 & CSS3, JavaScript, PHP, MySQL, creating object-oriented programs, and using PHP frameworks.
- Helps you grasp the technologies that power web applications
- Covers PHP version 7.2
- Includes coverage of the latest updates in web development
- Perfect for developers to use to solve problems
This book is ideal for the inexperienced programmer interested in adding these skills to their toolbox. New coders who've made it through an online course or boot camp will also find great value in how this book builds on what you already know.
Working with PHP, MySQL, and JavaScript to create dynamic web applications can be difficult, but if you know a few programming tricks, you can make that job a lot easier. This Cheat Sheet shows you how to extract data from different databases in your PHP programs, filter out unwanted or potentially dangerous data from web forms, quickly find data stored in your MySQL database, and trigger timed events in your JavaScript programs.
About The Author
Richard Blum has more than 30 years of experience as a systems administrator and programmer. He teaches online courses in PHP, JavaScript, HTML5, and CSS3 programming, and authored the latest edition of Linux For Dummies.
Articles From The Book
3 results
General Programming & Web Design
Articles
Not only can you use jQuery to modify content and styles of the existing elements in your web page, you can also use it to add or remove entire elements! There are a handful of different jQuery functions available for manipulating the element nodes contained in the DOM tree.
Adding a node
You can use jQuery to add a new node to the DOM tree to display additional content as needed.
General Programming & Web Design
Articles
Validating input data is crucial to any PHP application. You don't want an attacker trying to attack your system by submitting improper form data. Fortunately, the PHP developers have provided some help with that process.PHP provides several filter functions that allow you to easily check for valid data or sanitize the data if any unwanted data is present.
General Programming & Web Design
Articles
Array variables allow you to group related PHP data values together in a list using a single variable name. You can then either reference the values as a whole by referencing the variable name or handle each data value individually within the array by referencing its place in the list.PHP supports two types of arrays: numeric and associative.
General Programming & Web Design
Articles
While you're coding in PHP, you’ll often find yourself using the built-in functions available (such as the rand() function you used earlier in the example programs). Functions are nothing more than PHP code someone else wrote to accomplish a useful feature that you can use in any program. Instead of having to copy all the code into your application, you just use the function name.
General Programming & Web Design
Articles
It’s not necessarily recommended for a live production website, but for PHP development work you can build your own web server environment. You don’t even need to have a large server for a personal web development environment — you can build it using your existing Windows or Apple workstation or laptop.
Web servers in Linux
Linux desktops and servers are becoming more popular these days, especially for web development.
General Programming & Web Design
Articles
The Apache server is a must anyone learning PHP programming. By default, the Apache web server uses the httpd.conf configuration file to store its settings. For Linux and Mac systems, the file is usually stored in the /etc folder structure, often under either /etc/httpd or /etc/apache2.
The XAMPP package installs the Apache configuration file in the c:\xampp\apache\conf folder in Windows or /Applications/XAMPP/apache/conf in macOS.
General Programming & Web Design
Articles
Knowing how to customize the MySQL server will come in handy as you learn your way through programming. The MySQL server uses two different filenames for its configuration settings:
my.cnf for Linux and Mac systems
my.ini for Windows systems
One of the more confusing features about the MySQL server is that there are three ways to specify configuration settings:
They can be compiled into the executable server program when built from source code.
General Programming & Web Design
Articles
The PHP server configuration file is named php.ini, but it can be located in several different areas. The locations that the PHP server checks are (in order):
The path set in the PHPIniDir directive in the Apache web server configuration file
The path set in a system environment variable named PHPRC
For Windows systems, the path set in the registry key named IniFilePath under the HKEY_LOCAL_MACHINE/Software/PHP registry hive
The folder where the PHP server executable file is stored
The default web server's folder
The OS system folder, which for Windows is the c:\winnt folder, and for Linux and Mac the /usr/local/lib folder
The XAMPP install process places the php.
General Programming & Web Design
Articles
PHP uses the setcookie() function to set new cookies and update existing cookies. Here’s the basic format of the setcookie() function:
>setcookie(<em>name</em> [, <em>value</em>> [, <em>expire</em>> [, <em>path</em>> [, <em>domain</em>> [, <em>secure</em>> [, <em>httponly</em>>)
The only required parameter is the name of the cookie, although you'll almost always want to include a cookie value, too.
General Programming & Web Design
Articles
HTML5 has data validation capabilities that can be useful for web application development. Accepting data from unknown website visitors is a dangerous thing. However, dynamic web applications must have user interaction to work. The conundrum is how to do both.One method is to use data validation, which is the process of verifying that the data your site visitors enter into the form fields is correct.
General Programming & Web Design
Articles
Over the years, MySQL database experts have devised rules for how databases should handle transactions. The benchmark for all professional database systems is the ACID test. No, we’re not throwing the server into an acid bath; the ACID test is actually an acronym for a set of database features defining how the database server should support transactions:
Atomicity
Consistency
Isolation
Durability
Atomicity
The atomicity feature states that for a transaction to be considered successful, all steps within the transaction must complete successfully.
General Programming & Web Design
Articles
The MySQL database server was created by David Axmark, Allan Larsson, and Michael Widenius as an upgrade to the mSQL database server and was first released for general use in 1996. It’s now owned and supported by Oracle but released as open-source software.MySQL was originally created to incorporate indexing data to speed up data queries in the mSQL database server, by using the indexed sequential access method (ISAM).
General Programming & Web Design
Articles
There are a few different shortcuts you can use when implementing arithmetic operators in your PHP code. A common function in programming code is to perform a mathematical operation on a value stored in a variable and then store the result back in the same variable, like this:
$counter = $counter + 1;
This code adds 1 to the value currently stored in the $counter variable and then saves the result back in the $counter variable.
General Programming & Web Design
Articles
Working with PHP, MySQL, and JavaScript to create dynamic web applications can be difficult, but if you know a few programming tricks, you can make that job a lot easier. This Cheat Sheet shows you how to extract data from different databases in your PHP programs, filter out unwanted or potentially dangerous data from web forms, quickly find data stored in your MySQL database, and trigger timed events in your JavaScript programs.
General Programming & Web Design
Articles
Cross-site scripting (known as XSS) is quite possibly the most dangerous type of attack made on dynamic web applications. The main idea of an XSS attack is to embed malicious JavaScript code in data that the attacker submits to the web application as part of the normal data input process. When the web application tries to display the data in a client browser, the JavaScript is pushed to the client browser that’s viewing the website and runs.
General Programming & Web Design
Articles
PHP can be a helpful addition to your web pages. One question you may be asking is, “Why do I need a server-side programming language, too?” This information examines what your web applications will gain by adding PHP to the mix and what you can do when you incorporate PHP code in your applications.
A centralized programming language
One of the downsides to using a client-side programming language is that your code is dependent on how each individual browser runs it.
General Programming & Web Design
Articles
The laser-guided miter tool for program development is the integrated development environment (IDE). IDE packages provide everything you could possibly need to develop any size of web application.Here are some of the advanced features IDE packages provide:
Code completion: Start typing a code statement, and the package will provide a pop-up list of statements that match what you’re typing.
General Programming & Web Design
Articles
Searching for data in a MySQL SELECT statement means incorporating a WHERE clause. It's easy to search for a single item:SELECT prodid, product WHERE prodid = 100;What gets tricky is if you need to search for an item based on search pattern. MySQL uses the LIKE clause to help out with that:SELECT prodid, product WHERE product LIKE 'apple%';The percent sign works as a wildcard character, matching zero or more characters in the string.
General Programming & Web Design
Articles
The XMLHttpRequest object contains several class properties that you’ll need to know about to handle the HTTP response from the web server.
The XMLHttpRequest Class Properties
Property
Description
onreadystatechange
Defines a callback function that the browser triggers when the HTTP connection changes state
readyState
Contains the connection status of the HTTP connection
responseText
Contains the response sent by the web server in text format
responseXML
Contains the response sent by the web server in XML format
status
Contains the numeric HTTP response code from the web server
statusText
Contains the text HTTP response string from the web server
After you use the send() method to send a connection request to a web server, the HTTP connection process works through five connection states, as tracked by the readyState property:
State 0: The connection has not been initialized.
General Programming & Web Design
Articles
By far, the easiest method of setting up a PHP programming environment is to rent space on an existing server that has all the necessary components already installed. Plenty of companies offer PHP web development packages. Some of the more popular ones are
GoDaddy
HostGator
1&1
000webhost
These large web-hosting companies offer multiple levels of support for their services.
General Programming & Web Design
Articles
When you know your application will run in a MySQL environment, it makes sense to use the php_mysqli library functions to interact with the database. However, there may come a time when you want to write an application that can work using other databases as well. PHP supports quite a few database libraries, each of which interacts with a specific database server.
General Programming & Web Design
Articles
Accessor magic methods are PHP methods you use to access the private property values you define in the class. Creating special methods to retrieve the current property values helps create a standard for how other programs use your class objects. These methods are often called getters because they retrieve (get) the value of the property.
General Programming & Web Design
Articles
Mutator magic methods are PHP methods that change the value of a property that you set with the private visibility. These are also commonly called setters.The preferred way to handle class properties is to make them private so external programs can’t change them directly. Instead, to manipulate the data, external programs are forced to use mutator magic class methods that interface with the properties.
General Programming & Web Design
Articles
JavaScript is great for web programming. HTML5 and CSS3 work together to create web pages. The HTML5 code produces the content that appears on the web page, and the CSS3 code helps style it to change the format and location of the web page elements. So, what exactly does JavaScript do to help augment those languages?
General Programming & Web Design
Articles
When you use HTML5 forms in your web pages, you usually incorporate quite a few different elements — text boxes, text areas, check boxes, and radio buttons. Your JavaScript code can use the DOM tree objects to manipulate all these elements. The following information shows you how to use the DOM tree to work with different types of form elements.
General Programming & Web Design
Articles
Often you'll run into a situation where you need to trigger an event dynamically in a web page, without the website visitor doing anything. JavaScript provides two simple functions that allow you to schedule an event to trigger at a preselected time.The setTimeout() function allows you to schedule a specified function to trigger at a specific time from the current time:setTimeout(<em>function</em>, <em>time</em>);The function parameter specifies the name of the function to trigger, while the time parameter specifies the amount of time (in milliseconds) for the browser to wait until triggering the function.