HomeMonday, June 18, 2018, 15:06:35
2

MySQL Inner Join

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

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.

Email to Friend - PHP Script

This form allows your visitors to suggest your site to a friend. It features an HTML email format and an admin notification email.

Addslashes - Stripslashes

addslashes — quote string with slashes, stripslashes — un-quotes a quoted string

PHP highlight_string - PHP Tutorial

Outputs or returns a syntax highlighted version of the given PHP code using the colors defined in the built-in syntax highlighter for PHP. Requirement(s): PHP Server.

Random MySQL Query

Random MySQL query, requirement(s): PHP Server, MySQL

Link Base 1.1. - Free PHP Link Index Script

Manage your links using a MySQL database. Features easy install, user submission, and an admin panel to add, edit and remove categories and links.

Filter Words in PHP - PHP Tutorial

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

PHP Redirect

Header (location) redirect must be processed before any output to the browser.

Stack Overflow Clone Script - Ja2BU

Open source question and answer script written in PHP, MySQL and jQuery. Main features are: SEO friendly url's, private message system, rating system, comments system.

How to check checkbox checked

Checking if checkbox is checked with jQuery
About Author

cilipe

Date Registered: Mon, Feb 16, 15
Last Time Online: Wed, Feb 18, 15
So far has created 2 entries.
cilipe
This author has not yet filled in any details.