If im logged in (using sessions to log in) as admin, how do i get the data ONLY for admin. And i need to place the data in diffirent places (for example, id at the top at the page and name at the bottom). Help? :S
When i dump data on my site, I need those “enum” values to repersent what they stand for. Dumping them just prints what is in the fields. Like a “Male” = “0” and “Female” = “1”. To make my website display what the values mean. Maybe someone can point me in the right direction.
hi, thank you for your time and effert for creating these tutorials, can you make one tutorial of (how to querry the database from web using php, ie make the query from user input, rather than saying select * ,,, just put and id and then retrive the entire row that have connection with that row.
your time and effort appreciated very much. aram1918@yahoo.co.uk
@dashbyictfd i agree it worked perfect on my code and i looked at another site and the code was using loops like crazy this was a lot easier code very short ans sweet
thank you sir i will be glad to add money to a paypal email for this help, i have my own server and php my admin but i needed to display sku on a web page for my helper to have fast access very good help! i will formulate a question later on help in another issue
In mysql the date format is in yyyy/mm/dd , is there a way to manipulate this so that when it displays on your page with the rest of the retrieved data that it can be dd/mm/yy ?
I’ve tried and failed working with several php/MYSQL tutorials but this one works great! Can see the text clearly and the steps are clear and simple. Top stuff!
I have been following your tut and i’m trying to imply it to my coding. Pretty much im trying to do the same thing. i want to retrieve data from my forum that i made onto my site but its not working. do u have msn or an email so i can explain it more in detail? its probably an easy fix.
Firstly. Very well done tutorial. Wish I had found something like this when I was starting off. =(
Just a small note.
Using mysql_fetch_array is unnecessary as it returns both the name of the db column AND it’s index number. There’s no point in returning both when you’re only going to be using one. I’ve never been in a situation where I needed anything more than the associative name.
mastersuv says
So, that query will always take all the data and put it into an array? No exception?
angelbacs says
Hello Sir, What if i would like to retrieve the image from the database? i think the type is blog.it is the same process?plss help me…
from~gel_marc@yahoo.com
batangyagit20 says
man i love you very much 😀 now i know how to connect to an online database!
15Master1 says
If im logged in (using sessions to log in) as admin, how do i get the data ONLY for admin. And i need to place the data in diffirent places (for example, id at the top at the page and name at the bottom). Help? :S
samiwistler says
PHP gurus
titanicmusic14 says
You probably already know this but … YOU ARE THE MAN!!!!!!!! thanks for your help!
mmelson350 says
When i dump data on my site, I need those “enum” values to repersent what they stand for. Dumping them just prints what is in the fields. Like a “Male” = “0” and “Female” = “1”. To make my website display what the values mean. Maybe someone can point me in the right direction.
aramkurdi says
hi, thank you for your time and effert for creating these tutorials, can you make one tutorial of (how to querry the database from web using php, ie make the query from user input, rather than saying select * ,,, just put and id and then retrive the entire row that have connection with that row.
your time and effort appreciated very much. aram1918@yahoo.co.uk
anayfp says
Many Thanks, great Job!.
ncbookz says
@dashbyictfd i agree it worked perfect on my code and i looked at another site and the code was using loops like crazy this was a lot easier code very short ans sweet
ncbookz says
@TheyCallmeSR if your forum uses a database then it will work this worked perfect for me he did a great job it is perfectemente
ncbookz says
thank you sir i will be glad to add money to a paypal email for this help, i have my own server and php my admin but i needed to display sku on a web page for my helper to have fast access very good help! i will formulate a question later on help in another issue
dashbyictfd says
In mysql the date format is in yyyy/mm/dd , is there a way to manipulate this so that when it displays on your page with the rest of the retrieved data that it can be dd/mm/yy ?
dashbyictfd says
This was the first tutorial on this that I had followed that was
a) complete
and
b) I got working
great thanks.
betaalpha987 says
I’ve tried and failed working with several php/MYSQL tutorials but this one works great! Can see the text clearly and the steps are clear and simple. Top stuff!
TheyCallmeSR says
I have been following your tut and i’m trying to imply it to my coding. Pretty much im trying to do the same thing. i want to retrieve data from my forum that i made onto my site but its not working. do u have msn or an email so i can explain it more in detail? its probably an easy fix.
WayneWexford says
Firstly. Very well done tutorial. Wish I had found something like this when I was starting off. =(
Just a small note.
Using mysql_fetch_array is unnecessary as it returns both the name of the db column AND it’s index number. There’s no point in returning both when you’re only going to be using one. I’ve never been in a situation where I needed anything more than the associative name.
So instead, just use:
while($row = mysql_fetch_assoc($result)){
//etc
I’d be willing to be that it’s faster
WeedingWaimbow says
What keyboard are you using?
duubamg says
He’s got a beautiful accent. Which region people sound like this?
HxNxIxC says
YOU SOUND LIKE MARK ZUCKERBERG
timboiscool says
what is the link
Petterss22 says
Yes, sure.
But I hate the uploading limit.
littleweb1 says
hey if your pretty good at it could you make a video on how to put a username and pass on a site?
Petterss22 says
Great tutorial dude 🙂
Though I’m a Pro on PHP but I love your videos, you explain good.
Very good for newbies.
23528 says
good one..hope you can post more of these!