Ad block is installed and active. Please support us by disabling it.
HomeSaturday, January 20, 2018, 16:41:27

Create dynamic Web Pages with PHP & MySQL

Tuesday, February 10, 15, 11:26:22, 3 Yaers Ago Via wain, Hits: 4125
Create dynamic Web Pages with PHP & MySQL, Requirement(s): PHP Server, MySQL
Download source code (tutorial):

//MySQL Configuration
//DB Host (Normally 'localhost')
$dbhost = 'localhost';
//DB Database Username
$dbusername = 'root';
//DB Database User Password
$dbpassword = 'mypassword';
//DB Database Name
$dbname = 'mydbname';
//mysql_connect function
$conn=mysql_connect($dbhost, $dbusername, $dbpassword);
if(!$conn) :
die('Could not connect: ' . mysql_error());
$db=mysql_select_db($dbname, $conn);
if(!$db) :
die ('Cant connect to database : ' . mysql_error());

//make a MySQL connection
//create a MySQL table in the selected database
mysql_query("CREATE TABLE `page` (
`linkid` int(11) NOT NULL auto_increment,
`text` text collate utf8_unicode_ci,
`linkurl` text collate utf8_unicode_ci,
PRIMARY KEY (`linkid`)
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());

<title>Index Page</title>
//make a MySQL connection
echo "&nbsp;<a href=\"insert.php\">INSERT PHP</a><br>";
//get all the data from the page table
//*=select everything from the table page
$result = mysql_query("SELECT * FROM page")
or die(mysql_error());
//echo (display) a link using $link[linkid]
echo "&nbsp;<a href=\"webpage.php?id=$link[linkid]\">Web Page 1</a><br>";

<title>Insert Page</title>
<center><h2>INSERT PAGE</h2></center><BR>
//make a MySQL connection
//to check if a submit button was clicked, use this...
$text = $_POST['text'];
$linkurl = $_POST['linkurl'];
//the INSERT INTO statement is used
//to add new records to a database table
mysql_query("INSERT INTO page (text,linkurl) VALUES
or die(mysql_error());
<form method="post" action="insert.php">
<input name="text" size="60" maxlength="255">
<input name="linkurl" size="60" maxlength="255">
<input type="submit" name="submit" value="submit">

////make a MySQL connection
//get ID from URL
$id = $_GET['id'];
//get linkid, text, linkurl from the page table
//..or..*=select everything from the table page
$result = mysql_query("SELECT linkid, text, linkurl FROM page
WHERE linkid='$id' ")
or die(mysql_error());
while($myrow = mysql_fetch_assoc($result))
//the meta title tag is used to declare
//the title of the page
echo "<title>Web Page $myrow[text]</title>";
echo "<center><h2>Web Page $myrow[text]</center><BR>";
echo "<a href=\"$myrow[linkurl]\">$myrow[text]</a>";

shashi kanth reddy Wednesday, November 24, 2010, 14:28:09

excellent tutorial, please keep contributing in this way so that beginners will be benefited from sources like these , will keep posting

Daniel Wednesday, May 26, 2010, 10:44:43

Thanks for this tut, really helped me learn the basics.

Jas Wednesday, July 28, 2010, 10:57:59

Very useful for me

Paul Saturday, August 7, 2010, 02:21:31

this is very useful. I am about as new as they come to PHP and I found these scripts very educational, I learned more by playing with these scripts then all the tutorials I have read on the met put together. thank you so much for the time and effort.

Timothy Saturday, October 2, 2010, 07:16:26

Thanks for the tut, really helped a lot. though I have a question, how can I make the Web Page 1 change name? because it's awkward if you have thousands of links with Web Page 1 as their names.

sam Friday, October 22, 2010, 15:18:25

big ups,the tuts is very very helpful..

Vanja Tuesday, December 14, 2010, 07:38:35

Static Pages
Web Page

RewriteEngine on
RewriteRule (.*)\\.html$ webpage.php?id=$1

Mihail Saturday, January 22, 2011, 05:42:52

Very useful tut, thank you.

dani Monday, February 14, 2011, 09:38:29

thanks man

sandra Sunday, May 22, 2011, 16:45:15

Useful, clean, detailed tutorial. Thank you very much.

diweng Saturday, June 4, 2011, 07:30:56

Nice work! Thanks for tut.

Nehemiah c Monday, April 16, 2012, 06:07:19

This is very Use full to me. Thank U

Sign In



Smarty Paginate Example - Smarty Pagination with PHP

Smarty Paginate Example, Smarty Pagination with PHP. SmartyPaginate: a class/plugin for data set pagination within the Smarty template environment

PHP Jquery Form

PHP Jquery Form allow your visitors to contact you directly from your website.

Jquery - Formatting International Phone Numbers

How to format international telephone numbers with jquery

Preg_Match - PHP Email Validation

Validate email with preg_match in php

Adsense crawler errors and robots.txt

How to fix Google AdSense crawler errors in robots.txt

PHP explode

Explode — Split a string by string.

PHP Form Basic

PHP Form - PHP form basic, Requirement(s): PHP Server

PHPBB3 Shoutbox

Vesion: 1.1. Released: 08/08/10, Licence GNU, Price: Free

Contact Us PHP Form 1.1.

A contact us form with email and form field validation. It allows your visitors to send you an email directly from your website.
About Author


Date Registered: Sun, Feb 8, 15
Last Time Online: Thu, Jun 15, 17
So far has created 115 entries.
This author has not yet filled in any details.