Archive:PHP and MySQL Programming/Database Connectivity - Revision history

wikademia>Wikademia: moved PHP and MySQL Programming/Database Connectivity to Archive:PHP and MySQL Programming/Database Connectivity over redirect

2009-06-12T07:37:50Z

← Older revision	Revision as of 07:37, 12 June 2009
(No difference)

2009-05-18T21:04:20Z

← Older revision	Revision as of 21:04, 18 May 2009
(No difference)

2009-05-18T20:23:30Z

← Older revision	Revision as of 20:23, 18 May 2009
(No difference)

2009-04-18T19:26:15Z

18 revisions

← Older revision	Revision as of 19:26, 18 April 2009
(No difference)

2008-01-15T20:16:35Z

Creating a Query

← Older revision		Revision as of 20:16, 15 January 2008
Line 17:		Line 17:
	== Creating a Query ==		== Creating a Query ==

	Once a connection to a database has been made, you will ~~inevetably~~ want to perform a database query. To create a query on the selected database, we use the mysql_query() function. If you use a SELECT query, then the data returned from that query will be passed to the mysql_query() function, which will in turn return it to a variable which you can specify. In the following example, two queries are made, the first does not return any data, and the second does.		Once a connection to a database has been made, you will inevitably want to perform a database query. To create a query on the selected database, we use the mysql_query() function. If you use a SELECT query, then the data returned from that query will be passed to the mysql_query() function, which will in turn return it to a variable which you can specify. In the following example, two queries are made, the first does not return any data, and the second does.

	<?		<?

2007-04-06T09:58:31Z

Retrieving data from a SELECT Query

2007-04-06T09:55:20Z

Retrieving data from a SELECT Query

← Older revision		Revision as of 09:55, 6 April 2007
Line 47:		Line 47:
	while ($row = mysql_fetch_row($result)){		while ($row = mysql_fetch_row($result)){
	foreach ($row as $field) {		foreach ($row as $field) {
	print "$~~filed~~ . ";		print "$field . ";
	}		}
	print "<BR>";		print "<BR>";

2007-04-02T14:20:31Z

recat sort

← Older revision		Revision as of 14:20, 2 April 2007
Line 89:		Line 89:
	[[../File Handling/\|Previous: File Handling]] \| [[../\|TOC]] \| [[../Session Handling/\|Next: Session Handling]]		[[../File Handling/\|Previous: File Handling]] \| [[../\|TOC]] \| [[../Session Handling/\|Next: Session Handling]]

	[[Category:PHP]]		[[Category:PHP and MySQL Programming\|{{SUBPAGENAME}}]]
	~~[[Category:~~MySQL]]

2007-04-02T13:57:54Z

← Older revision	Revision as of 13:57, 2 April 2007
(No difference)

2007-04-02T13:24:33Z

restore current version

← Older revision		Revision as of 13:24, 2 April 2007
Line 1:		Line 1:
	~~{{delete\|see: Talk:Programming:PHP and MySQL}}~~

	~~[[Programming:PHP and MySQL\|TOC]]~~


	== Introduction ==		== Introduction ==

Line 92:		Line 87:
	?>		?>

	[[~~Programming:PHP and MySQL:~~File Handling\|~~<< 3.~~ File Handling]] \| [[~~Programming:PHP and MySQL~~\|TOC]] \| [[~~Programming:PHP and MySQL:~~Session Handling\|~~>> 6.~~ Session Handling]]		[[../File Handling/\|Previous: File Handling]] \| [[../\|TOC]] \| [[../Session Handling/\|Next: Session Handling]]

	[[Category:PHP]]		[[Category:PHP]]
	[[Category:MySQL]]		[[Category:MySQL]]