DO NOT USE FOR MYSQLI QUESTIONS. Use [mysqli] for general questions. PHP-MySQLiDB is a third-party wrapper for MySQLi written in PHP. Use for questions about this specific wrapper library
Questions tagged [php-mysqlidb]
26 questions
0
votes
1 answer
Can't update field with MysqliDb
I'm trying to add a users access token to my database. I'm using the php mysqlidb connection library.
If I use this function below I get this error:
Warning: mysqli_stmt::bind_param(): Number of elements in type definition string doesn't…
user2570937
- 802
- 3
- 17
- 34
0
votes
1 answer
Constructing a site with classes
Recently I started looking more seriously into classes and OOP in general in PHP. I'm trying to create a simple site while taking advantage of classes as much as possible but there have been some questions that have been stuck in my mind.
More…
Martin J
- 63
- 1
- 4
0
votes
0 answers
mysqli class joshcam error in insert function
I am using joshcam/PHP-MySQLi-Database-Class library and I am getting error in insert function while I am trying to insert data using an array
Error message:
Fatal error: Call to undefined method SimpleXMLElement::getSubQuery() in ../MysqliDb.php…
Jamil Bashir
- 307
- 3
- 10
0
votes
1 answer
Error MysqliDb::$_paramTypeList
I use this https://github.com/ajillion/PHP-MySQLi-Database-Class
this is my my class
require_once ('class/MysqliDb.php');
class Foo {
private $db;
public function __construct()
{
$this->db = MySqliDb::getInstance();
}
}
…
Barno
- 3,271
- 5
- 28
- 58
0
votes
1 answer
PHP--an Array in an Array? Not sure, using ajilion MySQLidb Class need to get value of raw Query
(PHP newb here--can read code somewhat well, working on writing)
I think I have an array in an array. using this for MySQL calls:
https://github.com/ajillion/PHP-MySQLi-Database-Class
my call:
$params = array($mta_name);
$mta_uid =…
brizz
- 271
- 1
- 6
- 17
0
votes
2 answers
Fails to Parse query, but running through PMA is a success
I have the following query:
UPDATE users_login SET LastLogin= CONCAT(CURDATE(), ' ', CURTIME()) WHERE Username=?
This fails when I'm passing this into my PHP MySQLI Query Construct. But running this through PMA Query:
UPDATE users_login SET…
Sophie Mackeral
- 897
- 4
- 12
- 21
0
votes
3 answers
How do read and loop through these MySQLi results?
I'm currently converting some code from mysql to mysqli. I have downloaded this class:
https://github.com/ajillion/PHP-MySQLi-Database-Class
I am trying something as simple as this:
$params = array('handset');
$rs =…
James Wilson
- 809
- 3
- 14
- 25
-1
votes
1 answer
How to encrypt/decrypt password using MysqliDB
Is there a way to insert/update in database using MysqliDB and AES_ENCRYPT?
$data = Array("Password" => "AES_ENCRYPT('" . $varToEncrypt . "', 'encryptKey')");
$db->where("Username", "admin")
->update('user', $data);
with this…
sincos
- 127
- 2
- 18
-1
votes
2 answers
How to use global object in Class
I am wondering how to get the following to be a global function. I want the class function to not have to keep logging into the MySQL I am using
https://github.com/joshcam/PHP-MySQLi-Database-Class#initialization
This is what I have done so far,…
RussellHarrower
- 6,470
- 21
- 102
- 204
-1
votes
1 answer
Call to a member function fetch_field() on a non-object MySQLiDB
Hi i cant use INSERT UPDATE function with this class: MySQLiDB.
Im trying write data to mysql and if exists this data then need update. So i use INSERT ... ON DUPLICATE KEY UPDATE.... My code like this:
$db->rawQuery("INSERT INTO table1…
iProgrammer
- 756
- 2
- 10
- 20
-2
votes
1 answer
MYSQL | PHP-MySQLi-Database-Class | Subquery
I want help in forming this query using class object wrapper(MysqliDb ). You can find here (MysqliDb )
This is the query i needed to convert
SELECT * FROM (SELECT * FROM users WHERE eventId=34) as t2 WHERE name like "alex" or email like "alex";
For…
vishal
- 462
- 1
- 5
- 12