User Guide > Tutorials > Using Zend Studio to Create Applications with the Zend Developer Cloud

Using Zend Studio to Create Applications with the Zend Developer Cloud

This tutorial demonstrates how Zend Studio and the Zend Developer Cloud are tightly integrated to facilitate a seamless and highly-efficient application development process. You can create a new deployed Zend Developer Cloud project, or import an existing Zend Developer Cloud project into your workspace. Zend Studio also allows you to easily connect and interact with your Zend Developer Cloud MySQL database.

Tutorial Content

In this tutorial you will learn:

To create and deploy a new Zend Developer Cloud project
To connect to your Zend Developer Cloud MySQL database and create a new table from within Zend Studio
To validate connectivity with the Zend Developer Cloud MySQL database

Provided Items

Throughout the tutorial, you will be provided with code snippets to insert in your project.

Prerequisites

Zend Studio 9.0 or above which can be downloaded from the Zend Studio Downloads page. For information on installation, see the Zend Studio Installation Guide.
A Zend Developer Cloud account and Container. For information on creating a Zend Developer Cloud account, see Building_Applications_on_the_Zend_Developer_Cloud.

Related Media

To better understand the procedures described in this tutorial, watch this video:

Step 1: Creating a New Zend Developer Cloud Project

We will first create a new Zend Developer Cloud project . This procedure will create a new application, deploy it to our Zend Developer Cloud Container and create a new project in our workspace.

Instructions on how to complete a procedure

To create a new Zend Developer Cloud project:

Go to File | New | PHP Project from Zend Developer Cloud.
-OR-
In the PHP Explorer View, right-click and select New | PHP Project from Zend Developer Cloud.
The Create Project from Zend Developer Cloud wizard is displayed.

Name your new project, and leave the Location field with the default settings.
In the Container field, your existing Container is displayed. If you wish to define a new target, click Add Target.
Below the Application field, click Create New ApplicationRelated Topics.
The new application is created, deployed and appears in the Application field.
Enter the Container password, and click Finish.
The new project is created in your workspace and displayed in the PHP ExplorerThe PHP Explorer is an internal file system browser, allowing you to view all PHP projects and files in your Workspace. . The project's 'deployment.xml' file is opened and displayed.

Open the project's 'index.php' file, and paste the following code:

<?php
$username = $_POST ["username"];
if ($username != "") {
 	/* connect */
 	$host = get_cfg_var ( 'zend_developer_cloud.db.host' );
 	$dbname = get_cfg_var ( 'zend_developer_cloud.db.name' );
 	$user = get_cfg_var ( 'zend_developer_cloud.db.username' );
 	$password = get_cfg_var ( 'zend_developer_cloud.db.password' );
 	/* Don't use this in production!!! */
 	$query = "INSERT INTO example (`username`) VALUES (\"" . $username .  "\")";
 	/* execute query */
 	$mysqli = mysqli_connect ( $host, $user, $password, $dbname );
 	$result = mysqli_query ( $mysqli, $query );
 	mysqli_free_result ( $result );
 	mysqli_close ( $mysqli );
	}
?>
<!DOCTYPE html>
<html>
	<head>
		<meta charset="ISO-8859-1">
		<title>Insert title here<MadCap:variable name="Primary.pageTitleVersion" /></title>
	</head>
	<body>
		 Welcome!
		 <form action="index.php" method="post">
		 Username: <input type="text" name="username" />
		 <input type="submit"></submit>
		 </form>
	</body>
</html>

Note:

The script in this code connects to the Container's MySQL database using the mysqli_connect PHP function, and inserts entries in the 'example' table (Step 2).

Save the file.
Open the 'deployment.xml' file and in the Testing area, click Launch a PHP Application.
The application is launched and displayed in Zend Studio's Internal Browser.

Step 2: Connecting to the MySQL Database and Creating a New Table

Each Zend Developer Cloud Container is provided with a database instance that can be used as back-end storage for your PHP applications. The database instance is fully compatible with MySQL 5.1, and you can create multiple tables within the one schema (database) provided to you.

We will now establish a connection with our Container's MySQL database and create a new table from within Zend Studio.

Instructions on how to complete a procedure

To connect to the Container database:

Go to Window | Show View | Targets.

Expand the Zend Developer Cloud target, and double-click the Database Connection.
Zend Studio establishes a connection with the database, and displays it in the Data Source Explorer.

In the Data Source Explorer, right-click the connection and select Open SQL Scrapbook.
The SQL Scrapbook is displayed.

In the Scrapbook's header, or Connection profile area, select the target from the Name drop-down menu, and the name of the container from the Database drop-down menu.
Copy and paste the following code into the SQL Scrapbook:

DROP TABLE IF EXISTS example;
CREATE TABLE example (
id INT,
username VARCHAR(100)
);

Right-click within the Scrapbook editor, and select Execute All.
The new Example table is created in the MySQL database.

The SQL Results view is displayed, showing the status of the SQL operation.