Wednesday, May 7, 2014

Organizing Joomla Articles and Main Menu (For PHP developer)

-----
Organizing Joomla Articles and Main Menu (For PHP developer)

STEPS

1) Create Article Category.

1.1) In Admin Page, go to menu Content/Category Manager/Add New Category.
1.2) Create “CatGetMethod” category.
1.3) Repeat Step 1.1 and 1.2 to create “CatPostMethod” category.

2) Create Article.

2.1) Go to menu Content/Article Manager/Add New Article.
2.2) Type PHP codes…
ArtGetSumVariables
<?php
//assume user input 1,2
$var1=$_GET["input1"];
$var2=$_GET["input2"];
echo $var1+$var2;
?>
2.3) Repeat for ArtPostSumVariables
ArtPostSumVariables
<form method="POST" action="" >
        input1: <input type="text" name="input1"><br/>
        input2: <input type="text" name="input2"><br/>
        <input type="submit" name="submit">
</form>
<?php
//get value from POST input
$var1=$_POST["input1"];
$var2=$_POST["input2"];
echo $var1+$var2;
?>

3) Create Menu Item.

3.1) Go to menu Menus/Main Menu/Add New Menu Item.
3.2) Add Menu Item Type as “Category List”.
Choose “CatGetMethod”.
3.3) Repeat Step 3.2 to create “CatPostMethod”.

4) Browse http://localhost/joomla31

4.1) Click the CatGetMethod menu link.
4.2) Click the Article “ArtGetSumVariable”.
You may get notice message.
Append “?input1=1&input2=2” to the URL texts.
4.3) Try open the ArtPostMethod.
You may get Notice message.
4.4) Type the values 1 and 2 and click Submit.
-----
Posted by at No comments:
Labels:

How To Write PHP Code In Joomla Article

-----
How To Write PHP Code In Joomla Article

INTRODUCTION

This tutorial uses the following packages:
1) uWamp as the Window-Apache-MySQL-PHP package. (For further info, follow this link, http://setup-steps.blogspot.com/2014/03/uwamp-221.html)
2) Joomla 3.1 (Download from here, https://drive.google.com/file/d/0B86b-ALn-1MGYks5dmFwU3BzZUk/edit?usp=sharing )
3) Joomla DirectPHP Plug-in (Download from here, https://drive.google.com/file/d/0B86b-ALn-1MGZXpzZXpGSlY3UWs/edit?usp=sharing )

STEPS

0) Setup the uWamp.

1) Extract the Joomla Package content.

Extract to ..\uwamp\www\joomla31\...

2) Create database “joomla31”.

Run phpmyadmin.
Create a database “joomla31”.

3) Browse http://localhost/joomla31 

3.1) You will be redirected to http://localhost/joomla31/
There are 3 steps that you need to follow to setup Joomla 31 successfully.
Step1: Configuration
Enter details and click Next.
Step 2: Database.
Enter the database configuration details and click Next.
Step 3: Finalisation
Click Install.
Installation Done.
Click “Remove installation folder” button.

4) Browse http://localhost/joomla31 again.

You should get Joomla Front Page.

5) Browse http://localhost/joomla31/administrator.

You should get Joomla Back-end Login page.
Enter your admin login credential (refer step 3.1).
You should see Joomla Control Panel page.

6) Install DirectPHP Plug-in

6.1) You need DirectPHP plug-in (download from here, https://drive.google.com/file/d/0B86b-ALn-1MGZXpzZXpGSlY3UWs/edit?usp=sharing )
6.2) Go to menu Extensions/Extension Manager.
6.3) Choose the DirectPHP plug-in and click Upload & Install.
6.4) You should get a success message.
6.5) Go to menu Extensions/Plug-in Manager.
6.6)  Type “DirectPHP” in the search box. Click the button in the Status column to enable it.
6.7) You should get a success message.
6.8) Next, disable Tiny MCE Editor plug-in.
7) Create PHP Content.
7.1) Go to menu Content/Article Manager/Add New Article.
7.2) Create a new article.
Title= PHP Test
Content=
<?php
echo “Hello Joomla!”;
?>
Click Save & Close button.
7.3) When Joomla shows you the article lists, click the star button for the above article.
It should be like this now:
7.4) Browse http://localhost/joomla31/
The article that you have just created should appear on the Front Page and it displays “Hello Joomla!”
-----
Posted by at No comments:
Labels:

PHP Eclipse 108: Working with MySQL Database

-----
PHP Eclipse 108: Working with MySQL Database
Contents
INTRODUCTION
STEPS
1) Prepare Database
2) Create database.
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>
<form action="insert.php" method="post">
Firstname: <input type="text" name="firstname">
Lastname: <input type="text" name="lastname">
Age: <input type="text" name="age">
<input type="submit">
</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);
?>
-----
Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)

Labels

apt-get (2) bash (4) Chrome (1) CMS (1) code-igniter (1) codenvy (1) composer (6) eclipse che (1) error (4) file-permission (1) firebase (2) Free PHP Hosting (11) FuelPHP (3) git (4) jwt (1) laravel (10) mysql (1) OpenShift (1) php (11) PHP Eclipse (9) PHP Joomla (2) PHP Laravel (4) PHP Yii (9) PHP-JBOSS (2) php-jwt (2) PHP-Wordpress (8) plain php (1) Postman (1) REST (2) sqlite (1) sudo (1) visual-studio (4) xampp (4)