Create a connection string to connect to database, PHP Web Programming

Assignment Help:

Question:

(a) What will be the output of the following extract codes? Describe fully how the program operates.

< ?php
$states_of_the_USA = array (1 => "Alabama", "Alaska", "Arizona");
$x = array_count_values($states_of_the_USA);
for ($counter=1; $counter<$x; $counter++) {
echo"
$states_of_the_USA[$counter]";
}
?>

(b) From a Web Browser and a Web Server viewpoint, explain the main processes that occur when a user request a page using PHP script to retrieve MySQL database data for inclusion in a Web Page?

(c) Consider a server with the following settings:

hostname: myserver.com
database name: monthsDB
username: root
password: my$ql

Create a connection string to connect to this database and explain each line of code.

(d) Referring to Question (c), list the PHP statements necessary to:

(i) insert a record into a database table called monthsTable having attributes month_name and number_of_days

(ii) update the existing number of days for the month of February from 28 to 29.


Related Discussions:- Create a connection string to connect to database

Change quantity button cannot be functioned, error_reporting(0); session_...

error_reporting(0); session_start(); header(''Content-type: text/html; charset=utf-8''); include_once(''../../xajax_core/xajax.inc.php''); // ?? xajax $xajax = new xajax()

What is php, What is PHP? PHP: Hypertext Pre-processor is open source s...

What is PHP? PHP: Hypertext Pre-processor is open source server-side scripting language which is widely used for web development. PHP scripts are executed on server. PHP allows

Simple e-commerce reservation system needed, Simple e-commerce reservation ...

Simple e-commerce reservation system We have a modest system, urgent want for a developer to build a system that allows users to reserve one of six products for a $50 fee. Th

We are in need of front end web developer and designer, We are in need of F...

We are in need of Front End Web Developer and Designer In search of someone who can convert my PSD files to HTML, HTML5, PHP. Who understands as well as works on websites, la

We need help in website developer and programmer, We need help in Website D...

We need help in Website Developer/Programmer for Fashion Tech Company London based applications only We are in search of a Website developer/programmer to make the site for u

Colgroup, describes a group of columns in the table and let you to set the ...

describes a group of columns in the table and let you to set the properties of those columns. goes after the tag immediately and bef

Web site project, Throughout the term you will be designing and creating a ...

Throughout the term you will be designing and creating a web site that you will submit during the final week of the course. The weekly assignments will help you develop the skills

Need help to convert wix website to shopify, Need help to Convert wix websi...

Need help to Convert wix website to shopify We want to convert our wix web store to shopify platform. No requirement to change the design. Desired Skills are Shopify

Want a facebook app designed for a social media, Facebook App Developer ...

Facebook App Developer I want a Facebook app designed for a social media contest where users can upload a picture and comment share it with friends and other users can like it a

Executing deferred scripts, Deferred scripts do not immediately do anything...

Deferred scripts do not immediately do anything. To use deferred commands, you have to call them from outside the deferred script. There are three methods to call deferred scripts

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd