Breadcrumbs

[Gameboy]

Hello everyone,

I am currently developing a YouTube Partner Dashboard system and I am revamping my old network manager/admin page and am trying to make a new user level in MySQL. To do this, I need to be able to delete a user from the admin level on my dashboard. I was wondering what code I'd be needing to delete a row in MYSQL via PHP on a secure Hypertext Protocool connection.

Thanks!

[CodenStuff]

Not sure about this one.

Typically to delete an entry you would use a command such as:

Code: Select all

"DELETE FROM Users WHERE theusersid=78"

[Gameboy]

Not sure about this one.

Typically to delete an entry you would use a command such as:

Code: Select all

"DELETE FROM Users WHERE theusersid=78"

This may work, I have a complex database with over 30 columns

[visualtech]

For starters, HTTP/S shouldn't really matter. It's just a security protocol for transferring data from the browser to the server. Now, if you're using secure MySQL instances using ECC or TLS (yeah, they have that for MySQL as well), then you might want to tell us a little bit more about it.

Secondly, consider Database Normalisation. If you have 30 columns, there is a high chance that you aren't doing something the way you were supposed to.

And yeah, Cody's reply is perfect. That's the way to go!

[Gameboy]

For starters, HTTP/S shouldn't really matter. It's just a security protocol for transferring data from the browser to the server. Now, if you're using secure MySQL instances using ECC or TLS (yeah, they have that for MySQL as well), then you might want to tell us a little bit more about it.

Secondly, consider Database Normalisation. If you have 30 columns, there is a high chance that you aren't doing something the way you were supposed to.

And yeah, Cody's reply is perfect. That's the way to go!

Alright, thank you very much @visualtech, highly appreciated. I have my databases setup correctly, it is just that I have so many added on additions for the YouTube API that it becomes almost confusing!