Getting Started With Eclipse Che, OpenShift, FuelPHP

Eclipse Che is a developer workspace server and cloud IDE. You install, run, and manage Eclipse Che with with different container orchestration engine such as Docker or OpenShift.

Eclipse Che is available in two different modes:

Single-user: perfectly suited for personal desktop environment.
Multi-user: best for organization and developer teams.

If you want to learn more about the differences between single-user and multi-user, please read this page

OpenShift

Che supports different flavors of OpenShift:

OpenShift Container Platform (OCP): OpenShift on-premise, that you can install in your Data Center.
OpenShift Online (OSO): On-Demand OpenShift hosted on public cloud and managed by Red Hat.
OpenShift Dedicated (OSD): Enterprise public cloud with your own OpenShift cluster managed by Red Hat.
MiniShift: OpenShift running on your local environment.

If you want to try Che on OpenShift, we recommend you to do it with MiniShift and use the MiniShift add-on for Che.

1) Goto Che Website

https://che.openshift.io

If you haven’t got any acount, click the “Create a free account” button.

2) Go to Che Dashboard

If you have already got an OpenShift account, you will be redirected to https://che.openshift.io/dashboard

3) Create A New Workspace

Enter workspace details.

E.g.

Name = my-php-workspace

Stack = PHP

Project = (none)

Plugins = (none)

Click Create button.

4) Create New Project

Since we did not specify any project in the previous step, we are required to do so now.

4.1) Select PHP Composer option.

4.2) Specify FuelPHP package

Package name= fuel/fuel

4.3) Wait until the process is completed.

It will take some time for the system to generate FuelPHP project based on composer package name.

5) Run Project

5.1) Run Apache

Find the run button.

Click and select Start Apache.

5.2) Browse the view URL

Find the view url in the console under the start apache tab.

6) Debug

The page may be having a problem when it is viewed in the browser e.g. mixed content request.

In the above example, the css content was requested via insecure connection.

We can enforce the FuelPHP to use a base url .

Edit ./fuel/app/config/config.php

'base_url' => 'https://route3v3uiast-razicommy-che.9a6d.starter-us-east-1a.openshiftapps.com/phpcom/public/',

Mixed content error is solved now.

-----

PHP Eclipse 108: Working with MySQL Database

Contents

3) Connecting To MySQL Database.

4) Create Database using PHP Script.

5) Create Table using PHP Script.

6) Insert Records using PHP Script.

7) Create HTML Form and PHP Script to insert date into the database.

8) Extract records from database using PHP Script.

8a) Basic display

8b) Tabular Format Display.

9) Extract selected record from table.

10) Sort record in display.

11) Update Records in table.

12) Delete Record in table.

INTRODUCTION

This tutorial is adapted from: http://www.w3schools.com/php/php_mysql_intro.asp

STEPS

0) Create subfolder 108.

1) Prepare Database

1.1) Run phpmyadmin

1.2) Take note that by default superuser name is “root” and the password is “root”.

1.3) phpmyadmin page appears in your web browser.

2) Create database.

2.1. Click Database tab.

2.2. Type “mydb”.

2.3. Click Create.

2.4. mydb created. you can see the database name in the database side panel.

2.5. Click mydb, type “mytable”, type “2”, click Go.

2.6. mytable name will appear under mydb in the side pane;.

2.7. click mytable name, click Insert tab. Type the name john and jenny and clik Go.

2.8) Click Browse tab. Check that the new records are shown.

3) Connecting To MySQL Database.

testconnection.php

<?php

// Create connection

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

3.1) testing with wrong database name.

3.2) you will get a warning message “unknown database”.

4) Create Database using PHP Script.

createdatabase.php

<?php

$con=mysqli_connect("localhost","root","root");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

// Create database

$sql="CREATE DATABASE my_db";

if (mysqli_query($con,$sql)) {

echo "Database my_db created successfully";

} else {

echo "Error creating database: " . mysqli_error($con);

}

5) Create Table using PHP Script.

createtable.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

// Create table

$sql="CREATE TABLE Persons(FirstName CHAR(30),LastName CHAR(30),Age INT)";

// Execute query

if (mysqli_query($con,$sql)) {

echo "Table persons created successfully";

} else {

echo "Error creating table: " . mysqli_error($con);

}

5.1) Check in phpmyadmin that your operations above have really taken effect.

5.2) You can drop the table and recreate the table using SQL commands via phpmyadmin as well.

CREATE TABLE Persons

(

PID INT NOT NULL AUTO_INCREMENT,

PRIMARY KEY(PID),

FirstName CHAR(15),

LastName CHAR(15),

Age INT

);

5.2) Click my_db path, click SQL tab, type the following SQL commands and click Go.

6) Insert Records using PHP Script.

insertrecords.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

mysqli_query($con,"INSERT INTO Persons (FirstName, LastName, Age)

VALUES ('Peter', 'Griffin',35)");

mysqli_query($con,"INSERT INTO Persons (FirstName, LastName, Age)

VALUES ('Glenn', 'Quagmire',33)");

mysqli_close($con);

7) Create HTML Form and PHP Script to insert date into the database.

7.1) Entry form.

insert.html

<html>

<body>

Firstname: <input type="text" name="firstname">

Lastname: <input type="text" name="lastname">

Age: <input type="text" name="age">

</form>

</body>

</html>

7.2) Entry processing.

insert.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

// escape variables for security

$firstname = mysqli_real_escape_string($con, $_POST['firstname']);

$lastname = mysqli_real_escape_string($con, $_POST['lastname']);

$age = mysqli_real_escape_string($con, $_POST['age']);

$sql="INSERT INTO Persons (FirstName, LastName, Age)

VALUES ('$firstname', '$lastname', '$age')";

if (!mysqli_query($con,$sql)) {

die('Error: ' . mysqli_error($con));

}

echo "1 record added";

mysqli_close($con);

7.3. Browse insert.html.

7.4) Enter data. Click Submit Query.

7.5) You should get success message.

8) Extract records from database using PHP Script.

8a) Basic display

displayrecords.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$result = mysqli_query($con,"SELECT * FROM Persons");

while($row = mysqli_fetch_array($result)) {

echo $row['FirstName'] . " " . $row['LastName'];

echo "<br>";

}

mysqli_close($con);

8b) Tabular Format Display.

displaytabulardata.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$result = mysqli_query($con,"SELECT * FROM Persons");

echo "<table border='1'>

<tr>

<th>Firstname</th>

<th>Lastname</th>

</tr>";

while($row = mysqli_fetch_array($result)) {

echo "<tr>";

echo "<td>" . $row['FirstName'] . "</td>";

echo "<td>" . $row['LastName'] . "</td>";

echo "</tr>";

}

echo "</table>";

mysqli_close($con);

9) Extract selected record from table.

selectrecord.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$result = mysqli_query($con,"SELECT * FROM Persons

WHERE FirstName='Peter'");

while($row = mysqli_fetch_array($result)) {

echo $row['FirstName'] . " " . $row['LastName'];

echo "<br>";

}

10) Sort record in display.

sortrecords.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$result = mysqli_query($con,"SELECT * FROM Persons ORDER BY age");

while($row = mysqli_fetch_array($result)) {

echo $row['FirstName'];

echo " " . $row['LastName'];

echo " " . $row['Age'];

echo "<br>";

}

mysqli_close($con);

11) Update Records in table.

updaterecords.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

mysqli_query($con,"UPDATE Persons SET Age=36

WHERE FirstName='Peter' AND LastName='Griffin'");

mysqli_close($con);

12) Delete Record in table.

deleterecord.php

<?php

$con=mysqli_connect("localhost","root","root","my_db");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

mysqli_query($con,"DELETE FROM Persons WHERE LastName='Griffin'");

mysqli_close($con);

-----

Wednesday, October 3, 2018