Search DaniWeb - mysqli

Re: Multiple MySQL connections + transactions 2 Months 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 2 Months Ago by Salem https://www.php.net/manual/en/mysqli.select-db.php I think the key word in all … Re: MySQLi Help 13 Years Ago by decade mysqli is much more easier to play than mysql. in your … Re: Mysqli versus PDO 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.. 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 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.. 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 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 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 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 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) 20 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) 20 Years Ago by fsn812 No, attempting to compile PHP5 with both mysql and mysqli functions. Mysqli and Mysql 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 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 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 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: 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 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 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 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 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 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 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 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 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 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 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 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 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)