Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
mysqli
- Page 1
Re: Multiple MySQL connections + transactions
Programming
Databases
1 Month Ago
by Dani
… slightly related question: Is it okay to use PHP's `
mysqli
::select_db()` function to switch databases in the middle of a…
Re: Multiple MySQL connections + transactions
Programming
Databases
1 Month Ago
by Salem
https://www.php.net/manual/en/
mysqli
.select-db.php I think the key word in all …
Re: MySQLi Help
Programming
Web Development
13 Years Ago
by decade
mysqli
is much more easier to play than mysql. in your …
Re: Mysqli versus PDO
Programming
Web Development
10 Years Ago
by diafol
mysqli
and PDO are different and I wouldn't say one … too (IMO). I would suggest PDO for its compatibility. Some
mysqli
functions depend upon the mysqlnd driver, which is often absent… found out when updating from mysql ->
mysqli
. :( I posted a workaround for the
mysqli
mysqlnd-dependent `fetch_all()` here: http://www.daniweb…
Re: mysqli help..
Programming
Web Development
11 Years Ago
by minitauros
Have you tried any
MySQLi
tutorials? Like: http://www.xphp.info/
mysqli
-tutorial/ or http://codular.com/php-
mysqli
?
MySQLi Help
Programming
Web Development
13 Years Ago
by cuonic
Hi, Just started to mess with
MySQLi
, created a simple login script, Connection to MySQL server establishes … were returned. 1) Am I doing it right, is the
mysqli
layout I'm using correct ? 2) Database structure is uid…
mysqli help..
Programming
Web Development
11 Years Ago
by GlenRogers
I've been trying to use
mysqli
instead of mysql. I have a file from another site … clue what i need to do to convert it to
mysqli
. This is the file <?php include 'connect.php'; //populate…
Re: MySQLi Help
Programming
Web Development
13 Years Ago
by cuonic
Just set up a test page with just the
mysqli
stuff, and the script returns the correct password but $query->num_rows; returns 0. Why is this ?
Re: MySQLi Help
Programming
Web Development
13 Years Ago
by pritaeas
See the [URL="http://php.net/manual/en/
mysqli
-stmt.num-rows.php"]manual[/URL] page. The num_rows function can only be used after store_results. See the example in the manual for the fix.
MySQLI
Programming
Databases
16 Years Ago
by rouse
A simple question I hope. In using the OOPs
mysqli
protocol how do I get the number of rows returned in a select query such as: [code] $queryStr = ("SELECT * FROM entry where username='$userin' AND password='$passwordin'"); [/code] Thanks! WBR
Re: MySQLI
Programming
Databases
16 Years Ago
by dickersonka
this doesn't have error handling, but here is how you do it following your line [code] $result = $
mysqli
->query($queryStr); $row_count = $result->num_rows; $result->close(); [/code]
mysqli + mysql functions (PHP5/MySQL 4.0)
Programming
Web Development
19 Years Ago
by fsn812
… `mysqli_objects_free_storage': /usr/src/php-5.0.4/ext/
mysqli
/
mysqli
.c:139: error: syntax error before ')' token /… `mysqli_read_property': /usr/src/php-5.0.4/ext/
mysqli
/
mysqli
.c:204: error: `MYSQL_STMT' undeclared (first use … `zm_startup_mysqli': /usr/src/php-5.0.4/ext/
mysqli
/
mysqli
.c:457: error: `STMT_ATTR_UPDATE_MAX_LENGTH' undeclared (first use …
Re: mysqli + mysql functions (PHP5/MySQL 4.0)
Programming
Web Development
19 Years Ago
by fsn812
No, attempting to compile PHP5 with both mysql and
mysqli
functions.
Mysqli and Mysql
Programming
Web Development
15 Years Ago
by whiteyoh
…: %s\n", mysqli_connect_error()); exit(); } } function emailChecker($email) { global $
mysqli
, $check_res; //check that email is not already in list $check_sql…_POST["email"]."')"; $add_res = mysqli_query($
mysqli
, $add_sql) or die(mysqli_error($
mysqli
)); $display_block = "<p>Thanks for …
Re: MySQLi INSERT to multiple tables with prepared statements
Programming
Databases
11 Years Ago
by Fernando_4
…function saveBooking($fullBook) { $
mysqli
= new
mysqli
(HOST, USER, PASSWORD, DB_PRICE); if ($
mysqli
->errno) { echo…VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; $svStmt = $
mysqli
->stmt_init(); $xtQry = " INSERT INTO Bextras (servID, name, amount…
mysqli login script error
Programming
Web Development
12 Years Ago
by angelclawdust
… i load my main page is get the following: Warning:
mysqli
::
mysqli
() [
mysqli
.
mysqli
]: (28000/1045): Access denied for user 'root'@'localhost' (using password…/users/class.Logare.php on line 64 Warning:
mysqli
::query() [
mysqli
.query]: Couldn't fetch
mysqli
in /home/daztestc/public_html/design/users/class…
mysqli->multi_query problem
Programming
Web Development
14 Years Ago
by qazplm114477
…start_connection(); } //instantiate the
mysqli
class $
mysqli
= self::$instance; $result = null; if ($
mysqli
->multi_query($sql)) { …and see for yourself } } while ($
mysqli
->next_result()); }else{ return false; …
MySQLi keeps returning "Incorrect arguments to mysql_stmt_execute" D:
Programming
Web Development
13 Years Ago
by GigsD4X
… code please? D: [code] <?php $
mysqli
=new
mysqli
(host, username, password, db); $query="INSERT… INTO `Variables` VALUES (?, ?)"; $stmt=$
mysqli
->prepare($query); $stmt->bind_param("ss", …, it works :o [code] <?php $
mysqli
=new
mysqli
(host, username, password, db); $query="INSERT…
Re: MySQLi INSERT to multiple tables with prepared statements
Programming
Databases
11 Years Ago
by Fernando_4
…Current block: function saveBooking($fullBook) { $
mysqli
= new
mysqli
(HOST, USER, PASSWORD, DB_PRICE); if …bindStr = $paramTypes.', '.$params; if ($stmt = $
mysqli
->multi_query($query)) { $stmt->bind_param($bindStr);… %d, error: %s', $
mysqli
->errno, $
mysqli
->error);`. If I comment this…
Re: MySQLi INSERT to multiple tables with prepared statements
Programming
Databases
11 Years Ago
by Fernando_4
… be something like this: $
mysqli
= new
mysqli
(HOST, USER, PASSWORD, DB_PRICE); $stmt1 = $
mysqli
->prepare($query1); $stmt2 = $
mysqli
->prepare($query2); foreach($something…$stmt2->execute(); } } So I will keep using just one `$
mysqli
` object, but creating several statements and parameter binds, although I…
MySQLi INSERT to multiple tables with prepared statements
Programming
Databases
11 Years Ago
by Fernando_4
… not tested yet. function saveBooking($fullBook) { $
mysqli
= new
mysqli
(HOST, USER, PASSWORD, DB_PRICE); if (mysqli_connect_errno())….$fullServiceParamType; $params = $reservationParams.$fullServiceParams; if ($stmt = $
mysqli
->prepare($query)) { $stmt->bind_param($paramTypes, $params);…
Re: MySQLi INSERT to multiple tables with prepared statements
Programming
Databases
11 Years Ago
by Fernando_4
… this sample: /* execute multi query */ if ($
mysqli
->multi_query($query)) { do { /* store first… result set */ if ($result = $
mysqli
->store_result()) { while ($row = $result->fetch_row())…would allow the use of the `
mysqli
` object and see if that "…
Mysqli Queries
Programming
Web Development
16 Years Ago
by udaydesai
… a database connectivity like this. [code=php] function db_conn() { $
mysqli
= new
mysqli
("localhost", "root", "", "test…($dquery); //printf("Affected rows (DELETE): %d\n", mysqli_affected_rows($
mysqli
)); exit; $affecrows = mysqli_affected_rows($dquery); }//end of if //onClick="alert…
mysqli assistance
Programming
Web Development
14 Years Ago
by phpcode
…it working with the following code: [CODE=php] $
mysqli
= new
mysqli
('localhost','root','','test'); $sql = "SELECT * …FROM food"; if($result = $
mysqli
->query($sql)){ echo "Please Select a food: &…echo "</select>"; } echo $
mysqli
->error; $
mysqli
->close(); ?> [/CODE] Maybe it's…
Re: mysqli login script error
Programming
Web Development
12 Years Ago
by angelclawdust
… setConn() { // if the connection is successfully established if($conn = new
mysqli
($this->conn_datas['localhost'], $this->conn_datas['daztestc_testdaz'], $this->…
Re: mysqli assistance
Programming
Web Development
14 Years Ago
by somedude3488
… to store the data in another array. Ex. [code=php] $
mysqli
= new
mysqli
('localhost','root','','test'); $sql = "SELECT * FROM food"…;; $results = array(); if ( $result = $
mysqli
->query($sql) ) { while( $row = $result->fetch_object() ) { $results[] = $row…
Mysqli insert parsed array containing original original tags
Programming
Web Development
12 Years Ago
by denikov
… Here's the entire code: <?php $
mysqli
= new
mysqli
("localhost", "root", "…;", "test"); $
mysqli
->query("SET NAMES 'utf8'"); include_once …last id $reverse = array_reverse($items); $stmt = $
mysqli
->prepare ("INSERT IGNORE INTO test_news (article, …
Re: MySQLi INSERT to multiple tables with prepared statements
Programming
Databases
11 Years Ago
by pritaeas
> So basically you're saying change if ($stmt = $
mysqli
->prepare($query)) to if ($stmt = $
mysqli
->multi_query($query)). No. I suggested to replace `execute`
Re: Mysqli Queries
Programming
Web Development
16 Years Ago
by pritaeas
[url]http://nl3.php.net/manual/en/
mysqli
.query.php[/url] You're using the procedural style of
mysqli
, so the connection needs to be given as a parameter.
Re: MySQLi INSERT to multiple tables with prepared statements
Programming
Databases
11 Years Ago
by pritaeas
In addition. You can keep using `execute` if instead of the method above you execute each query seperately, and start with [begin-transaction](http://www.php.net/manual/en/
mysqli
.begin-transaction.php)
1
2
3
17
Next
Last
Search
Search
Forums
Forum Index
Hardware/Software
Recommended Topics
Programming
Recommended Topics
Digital Media
Recommended Topics
Community Center
Recommended Topics
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Top Members
Meet People
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2025 DaniWeb® LLC