PHP and MySQL - Revision history

Zach: /* Connecting to a MySQL Database in PHP */

2023-09-26T00:08:58Z

Connecting to a MySQL Database in PHP

2017-08-24T17:21:26Z

Removed Ubuntu support

2013-10-03T09:22:13Z

Connecting to a MySQL Database in PHP

2013-03-27T06:49:21Z

xkcd

2012-10-01T18:03:57Z

Troubleshooting

2012-10-01T18:03:38Z

get_result() and fetch_assoc()

2012-10-01T04:30:59Z

Performing Queries that Require Parameters

2012-10-01T04:30:49Z

Combined Queries

2012-09-04T19:05:28Z

Fixing GeSHi Languages

2012-08-23T20:05:03Z

Combined Queries

@@ Line 25: / Line 25: @@
 // Content of database.php
-$mysqli = new mysqli('localhost', 'username', 'password', 'databasename');
+$mysqli = new mysqli('localhost', '<username>', '<password>', '<databasename>');
 if($mysqli->connect_errno) {

@@ Line 182: / Line 182: @@
 If you are getting an error <code>call to undefined method mysqli_stmt::get_result()</code>, you probably installed the '''php(5)-mysql''' instead of the '''php(5)-mysqlnd''' package.  To fix this, first uninstall the old package and then install the new one.
 <source lang="bash">
 $ sudo yum remove php-mysql

@@ Line 23: / Line 23: @@
 <source lang="php">
 <?php
 $mysqli = new mysqli('localhost', 'username', 'password', 'databasename');

← Older revision		Revision as of 06:49, 27 March 2013
Line 7:		Line 7:
	* [[MySQL Schema and State]]		* [[MySQL Schema and State]]

		+
		+	{{XKCD
		+	\|id=970
		+	\|name=the_important_field
		+	}}

	== PHP Libraries for Database Manipulation ==		== PHP Libraries for Database Manipulation ==

@@ Line 177: / Line 177: @@
 In Debian:
 <source lang="bash">
-$ sudo apt-get uninstall php5-mysql
+$ sudo apt-get remove php5-mysql
 $ sudo apt-get install php5-mysqlnd
 </source>

← Older revision		Revision as of 18:03, 1 October 2012
Line 170:		Line 170:

	Instead of binding the columns of the result set to variables, they are returned in an associative array. '''$result->fetch_assoc()''' returns a new array for each row in the result set, and when there are no more rows, it returns null, thereby exiting the loop.		Instead of binding the columns of the result set to variables, they are returned in an associative array. '''$result->fetch_assoc()''' returns a new array for each row in the result set, and when there are no more rows, it returns null, thereby exiting the loop.
		+
		+	==== Troubleshooting ====
		+
		+	If you are getting an error <code>call to undefined method mysqli_stmt::get_result()</code>, you probably installed the '''php(5)-mysql''' instead of the '''php(5)-mysqlnd''' package. To fix this, first uninstall the old package and then install the new one.
		+
		+	In Debian:
		+	<source lang="bash">
		+	$ sudo apt-get uninstall php5-mysql
		+	$ sudo apt-get install php5-mysqlnd
		+	</source>
		+
		+	In RHEL:
		+	<source lang="bash">
		+	$ sudo yum remove php-mysql
		+	$ sudo yum install php-mysqlnd
		+	</source>

	== Combined Queries ==		== Combined Queries ==

@@ Line 53: / Line 53: @@
 $dept = $_POST['dept'];
-$stmt = $myqli->prepare("insert into employees (first_name, last_name, department) values (?, ?, ?)");
+$stmt = $mysqli->prepare("insert into employees (first_name, last_name, department) values (?, ?, ?)");
 if(!$stmt){
 	printf("Query Prep Failed: %s\n", $mysqli->error);

@@ Line 181: / Line 181: @@
 $dept = $_GET['dept'];
-$stmt = $myqli->prepare("select first_name, last_name from employees where department=?");
+$stmt = $mysqli->prepare("select first_name, last_name from employees where department=?");
 if(!$stmt){
 	printf("Query Prep Failed: %s\n", $mysqli->error);

@@ Line 99: / Line 99: @@
 Consider the following example:
-<source lang="php"><nowiki>
+<source lang="php">
 <?php
 require 'database.php';
@@ Line 124: / Line 124: @@
 $stmt->close();
 ?>
-</nowiki></source>
+</source>
 Here, we use '''$stmt->bind_result()''' instead of '''$stmt->bind_param()''' because we are interested in the output from, not the input to, the query.
@@ Line 142: / Line 142: @@
 Consider this code:
-<source lang="php"><nowiki>
+<source lang="php">
 <?php
 require 'database.php';
@@ Line 167: / Line 167: @@
 $stmt->close();
 ?>
-</nowiki></source>
+</source>
 Instead of binding the columns of the result set to variables, they are returned in an associative array.  '''$result->fetch_assoc()''' returns a new array for each row in the result set, and when there are no more rows, it returns null, thereby exiting the loop.
@@ Line 175: / Line 175: @@
 You can also perform queries that both take input and produce output; you simply call both '''$stmt->bind_param()''' and '''$stmt->bind_result()'''.  For example, the following selects all employees in the department specified in the GET variable '''dept''':
-<source lang="php"><nowiki>
+<source lang="php">
 <?php
 require 'database.php';
@@ Line 205: / Line 205: @@
 ?>
-</nowiki></source>
+</source>
 [[Category:Module 3]]