HomeSunday, February 19, 2017, 21:13:03
2

MySQL Inner Join

Tuesday, February 10, 15, 09:58:34, 2 Yaers Ago Via wain, Hits: 1862
MySQL Inner Join - Creating Dynamic Webpages Using PHP and MySQL, Requirement(s): PHP Server, MySQL
Download source code:
http://phpform.net/download.php?f=inner_join.zip

config.php

Code:
<?php
//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());
endif;
$db=mysql_select_db($dbname, $conn);
if(!$db) :
die ('Cant connect to database : ' . mysql_error());
endif;
?>


install.php

Code:
<?php
//make a MySQL connection
include('config.php');
//create a MySQL table in the selected database
mysql_query("CREATE TABLE `text` (
`textid` int(11) NOT NULL auto_increment,
`textvalue` text collate utf8_unicode_ci,
PRIMARY KEY (`textid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
mysql_query("CREATE TABLE `numbers` (
`numberid` int(11) NOT NULL auto_increment,
`numbervalue` text collate utf8_unicode_ci,
PRIMARY KEY (`numberid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=1")
or die(mysql_error());
?>


index.php

Code:
<title>Index Page</title>
<center><h2>INDEX</h2></center><BR>
<?php
//make a MySQL connection
include('config.php');
echo "&nbsp;<a href=\"insert.php\">Insert PHP</a><br>";
//Get data from 2 tables
//*=select everything from table
$result = mysql_query("SELECT * FROM text
INNER JOIN numbers
ON numbers.numberid = text.textid")
or die(mysql_error());
while($link=mysql_fetch_array($result)){
//echo (display) a link using $link
echo $link['numbervalue'];
echo "-";
echo $link['textvalue'];
echo "<br>";
}
?>


insert.php

Code:
<title>Insert Page</title>
<center><h2>Insert Page</h2></center><BR>
<?php
//make a MySQL connection
include('config.php');
//to check if a submit button was clicked, use this...
if(isset($_POST['submit']))
{
$textvalue = $_POST['textvalue'];
$numbervalue = $_POST['numbervalue'];
//The INSERT INTO statement is used to add new records
//to a database table.
mysql_query("INSERT INTO text (textvalue)
VALUES ('$textvalue')")
or die(mysql_error());
mysql_query("INSERT INTO numbers (numbervalue)
VALUES ('$numbervalue')")
or die(mysql_error());
}else{
?>
<table><tr><td>
<form method="post" action="insert.php">
Textvalue:
</td><td>
<input name="textvalue" size="60" maxlength="255">
</td></tr>
<tr><td>
Numbervalue:
</td><td>
<input name="numbervalue" size="60" maxlength="255">
</td></tr>
<tr><td>
<input type="submit" name="submit" value="submit">
</form>
</td></tr></table>
<?php
}
?>

Sign In

Web Hosting


Related

Syntax highlighting in Smarty

Syntax highlighting for Smarty - Google Code Prettify

Getimagesize

Getimagesize function will determine the size of any given image file and return the dimensions along with the file type and a height/width text string to be used inside a normal HTML IMG tag and the correspondant HTTP content type.

Contact Us 2.0. with HTML Page and Pop Up Frame

This is the same Contact Us 2.0. that is in this forum, But I have added more options to this script and a html page with a very nice pop Up frame that DONT get block by any pop Up software. Many websites use this type of script to bypass the blocking…

View content in a zip file with PHP

List all files in a zip archive with PHP

Show / Hide Div with CSS

CSS Display and Visibility:The visibility property specifies whether or not an element is visible.

PHP $_SESSION

Session_start creates a session or resumes the current one based on a session identifier passed via a GET or POST request, or passed via a cookie.

How to set up password for phpMyAdmin in Wamp Server

Password for phpMyAdmin in Wamp

Contact Us 2.0. :: PHP Form

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

Upload Image With PHP

[Example3] Tutorial - How to upload image in php.

FeedBack Form with Captcha

It allows your visitors to send you an email directly from your website.
About Author

wain

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