Tag: mysql

52 votes
13 answers
2.1K views
How to insert multiple rows from array using CodeIgniter framework?

I'm passing a large dataset into a MySQL table via PHP using insert commands and I'm wondering if it

avatar
Jefferey
0 1 0 9
asked 07 September, 2021
60 votes
10 answers
2.6K views
how to get last insert id after insert query in codeigniter active record

I have an insert query (active record style) used to insert the form fields into a MySQL table. I want to get

avatar
Percy
0 1 0 9
asked 07 September, 2021
54 votes
10 answers
1.7K views
How can I do 'insert if not exists' in MySQL?

I started by googling and found the article How to write INSERT if NOT EXISTS queries in standard SQL which ta

avatar
Bryan
0 1 0 9
asked 07 September, 2021
52 votes
30 answers
1.5K views
mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc... expects parameter 1 to be resource

I am trying to select data from a MySQL table, but I get one of the following error messages: mysql_fetch_

avatar
Boyd
0 1 0 9
asked 07 September, 2021
61 votes
16 answers
2.9K views
UTF-8 all the way through

I'm setting up a new server and want to support UTF-8 fully in my web application. I have tried this in

avatar
Keith
0 1 0 9
asked 07 September, 2021
58 votes
12 answers
1.6K views
53 votes
28 answers
1K views