Ad block is installed and active. Please support us by disabling it.
HomeSunday, December 17, 2017, 04:11:50
2

MySQL Inner Join

Tuesday, February 10, 15, 09:58:34, 3 Yaers Ago Via wain, Hits: 3553
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

Sponsor

Related

PHP DateTimeZone

PHP representation of time zone

PHP/MySQL Bookmarklet - PHP Tutorial

PHP/MySQL bookmarklet, bookmark current page, PHP/MySQL tutorial.

Link Base Pro :: Free Link Index Script

This script allows you to manage your links using a MySQL database. It features easy install, user submission, and an admin panel to add, edit and remove categories and links.

MySQL to RSS

Publishing MySQL data in RSS

How to set up password for phpMyAdmin in Wamp Server

Password for phpMyAdmin in Wamp

Adsense crawler errors and robots.txt

How to fix Google AdSense crawler errors in robots.txt

MySQL Tutorials

MySQL tutorials, MySQL training, learn MySQL, MySQL Tutorial with practical examples.

PHP Cookies and Sessions Tutorial

PHP Cookies and Sessions Tutorials

Filter Words in PHP - PHP Tutorial

Filter bad words in PHP, requirement(s): PHP server

PHP Form Validation

PHP form validation :: PHP tutorial, requirement(s): PHP Server
About Author

wain

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