47: Inserting database results into array in PHP - PHP tutorial 

The content delivery style is excellent. No Fluff. I loved that.

OMG, thx bro. I'm about 10 days can't understand how this work. This video is helpfull!

Hello Daniel, Just a heads up when you show us a dump from a print_r then instead of just doing that, so it looks so messy, then arooung the print_r(); you can echo '' and close it after the print_r functions like echo '' and you will get a much more clean look..

Man you 're a life saver..Still helpful in 2023 👌

Great!!! thanks i understand it.

You just saved me. Thanks a lot!

very well explained! Thank you so much!

Thank you dude, im currently at my exams and you really helped me out. You dont know how much you helped people around the word with this video

Hi daniel, thans god you very help me out on my final project. This was very perfect solver for machine learning development. Love you, i'll promote ur channel as i cant give nothing. I am from indonesia btw. Thx

thank you so much!! you help me for my database project for the university (hello from Athens)

very nice approach of explanation.Thank you, sir.

Wow. You helped me out so much

this video is helpfull !!!!

This gives me a head start, because i code in another class which doesn't give the require output on my code thanks a bunch.

Thank you Sir . 'helped a lot.

really you have awesome way in explain

Great video 💯💯💯💯

love your videos

Thank You!

Thank you very much.

thank you!

Hey, I learn a lot from this channel. I'm just a beginner in php and mysqli. Yet I already have a compexe question. I am looking for a code / instruction how to make a matrix (multiple dimensional array ????? (I don't know)). What I have is a three table database table 'user' a table 'role' and a connection table 'person2role'. Now I am looking at how I can display the roles horizontally and the users vertically. where the tables intersect should be a +. for example: role1 role2 role3 user1 x user2 x x user3 x

if I could slam a super like button i had done so! thank you my fine sir :D !

Hello nice tuts. I HAVE A QUESTION. Related to array, can you explain why we put html input checkbox name= "checkbox [ ] " . How those brackets as key can turn into value in an array? I dont get it. Thanks pal you awesome.

Does anyone know what the best way to pass a multi-dimensional array to a new page is. Is it best to use SESSIONS or to serialise the variable and use POST and then unserialise on the other page? Or is there some other method that would be more appropriate?

Greetings Sir! From your example how could i use to save only these ids,texts in another table? Im using php PDOs? Waiting to hear from you!

v goooood

Nice

As I've been flollowing your tutorials, other subjects on RU-vid pop up. Several have been Learn to send SMS Text in PHP. Why would someone want to send or receive text, and how would we implement such an application?

can we use object of javascript as like array with foreach in php?

Hi, is it possible that if I only want selected columns in array (not all at once)? Fx. I have 7 columns in my table in database. I only want to insert results from column nr. 6, 1 and 2, and I want to insert these results in this order (row[6], row[1], row[2]). What should I do so??

Hi Daniel, thank you for this tutorial, it's very helpful. but where are the 36-44 episodes ??!! there're missing. please advise. thank you

1:24: "Which I know is not correct" Big LOL!!! 🤣

Would it not be better if you use references like : 1D Arrays -> | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 2D Arrays -> | 00 | 01 | 02 | 03 | | 10 | 11 | 12 | 13 | | 20 | 21 | 22 | 23 | | 30 | 31 | 32 | 33 | 3D Arrays -> as cubes instead of just saying multi-dimensional array Also you should explain how the mysqli_query() function returns the result like id text ------------------------- 0 | 1 | Hi | -> Array 1 1 | 2 | there | -> Array 2 2 | 3 | friend | -> Array 3 ResultArray = ( Array1, Array2, Array3 ) ;

For printing all the rows you can try that: for($i = 0; $i < (mysqli_num_rows($result)); $i++){ foreach($data[$i] as $item){ echo $item." "; } echo ""; }

For a better overview of your array do this:

How to retrieve data from database and show in different different checkbox?

what about if I have some empty row inside column result? how can I escape that empty row? please help....

Could this be applied to a java program instead of a website and still work correctly?

Can you please make coffeescript tutorials?

hi, i'm stuck on how i can do the reverse, that is, how to insert every data (from the result of COUNTING how many times a word appear in the column) into a table. I was able to display the result, but i need to also insert the data to a table in db. Pls. advice. thanks

Hi am having issue fetching several data from mysql table with repetition, can I get help

Is it possible to get each value inside the text column separately(not all at once)? And also, without referencing the id for each text. Can someone answer this please?

how to put these into count array?

Hi can you please make a video on how to insert array result into database in PHP?

why do you name the part which is connecting to the database and executing a piece of sql code $result ? wouldnt $execute or $sqlCode be better?

how to use insert query and display the inserted data in json format?

Hello mmtuts how do i compare database data with form input data? They are both sentences, how do i compare each of the words of those data one by one?

This tutorial playlist has been amazing so far! I'm super new to php coding and I make sure to follow your tutorials asclosely as possible and it has gone well :) I did the same with the code in this video and created the database and table like yours and keep getting this error message: Warning: mysqli_connect(): (HY000/1045): Access denied for user ''@'localhost' (using password: NO) in C:\xampp\htdocs\trialsandtribs\ARRAYS\dbh.php on line 8 connection failed: Access denied for user ''@'localhost' (using password: NO) I don't know how to fix this or where to start. Please help *weeps like child*

Cool video but quick question. How would this be helpful in the sense that I can just use fetch assoc $row[]

Could you help me with my footer? :s

after inserting array to database how about updating it using php

8002f1f9 my ps3 error how to fix it

Hii... For this below lines... foreach ($datas as $loopvar ){ echo $loopvar['text']; } I'm getting this Notice: undefined index:text in c:\..... Can u help me on this.?!

I try this but returns from the second line ... who i can fix that?

Hi sir ,

Can someone help: in fact there is no difference between the array result and the array datas. Is that right?

I am getting this error: Cannot use a scalar value as an array

hello sir how are you doing, thank you for you tutorial, but i have one issue that i want you to help me because am working on my theist and i have error to submit my student attendance using mysqli array here are the code below ( =========== this part is the form side ======== × Mark Class Attendance Grade *

how to insert data array to database?

It would be great if you show how to do this in C language

how to insert into array in pdo?

Shouldn't you close the connection?

actually data is the plural and datum is singular that's according to my own knowledge

Multidimensional array is hard one to understand.

- how much data do we need? - like 8 datas

I'm looking for a way to do the opposite lol

Where is the next part bro ???

I swear, you are getting paid every time you say array or something

Thanks for the presentation. It helped me solving several questions. However, I am using PHP 8.2.2 and the code of the presentation generates an error. I am presenting the problem that might give you an idea for resolving it The code below reads the data $i = 0; $j = 0; while ($row = mysqli_fetch_array($result)) { $dbArr[] = $row; $dbArrTest[$i][$j++] = $row['strName']; $dbArrTest[$i++][$j] = $row['meaning']; } The code below just tests the reading $i = 0; foreach ($dbArr as $strF) { if ($i !== 0) { echo $i . ": " .$strF['strName'] . " : " . $strF['meaning']; echo ""; } $i++; } If $i = 0 --> PHP 8.2.2 generates an error. I have no idea why! I bypassed it by just skipping value $i=0 The same is happening no matter what is the initial value of $i (like 1, 2, 3). My test shows that the problem is generated when rtrying to echo the 1st value of $strF, that is EMPTY!!!