|
I never post here but I just need advice, most of C&G's too stupid for this.
For MySQL, if the mysqli is the improved database connections- what were the old ones and how were they different?
help pls |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
mysql_etc
go to google, since it's there... |
|
Tr3eJoin Date: 2011-08-03
Post Count: 54 |
Since cntkillme has no idea how this stuff works I'll be happy to help you out.
MySQL is an older database driver, and MySQLi is a more updated one.
The new features include
- Object-oriented interface
- Support for Prepared, Multiple Statements
- Support for Transactions
- Better debugging capabilities
- Server Support that is Embedded
|
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
Since you are stupid and can't read "what were the old ones and how were they different?"
Not the new ones |
|
|
Ohaider alpha.
Anyway, MySQLi also fixed some serious security issues. Do NOT use Mysql |
|
Tr3eJoin Date: 2011-08-03
Post Count: 54 |
@cntkillme
I gave the new features of MySQLi that differ from MySQL. If you cannot comprehend this, then please leave. Also, why bother posting on a topic you have no knowledge about? You do this often, and it's getting quite annoying. |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
Nope, I know about the features, he is asking for the old ones and how it differs, not for nothing and what the new one includes
Leave |
|
Tr3eJoin Date: 2011-08-03
Post Count: 54 |
@cntkillme
You don't know even the basics on how MySQL or MySQLi works and it's rather obvious.
"MySQL_etc"
He asked for the old ones and how they differ from the new ones. I told him MySQL is an older version, and MySQLi has these new features that differ from MySQL. That is what differs (there's also security updates.. etc). You don't seem to be able to comprehend that sadly enough. |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
"You don't know even the basics on how MySQL or MySQLi works and it's rather obvious."
For your information, I have used MySQL for years until it's deprecated, then I researched a lot on MySQLi and now I'm using PDO.
You are really stupid, he most likely knows MySQLi by the way he asked the question.
"For MySQL, if the mysqli is the improved database connections- what were the old ones and how were they different?"
Read and learn english stupid |
|
Tr3eJoin Date: 2011-08-03
Post Count: 54 |
...
I've tried to explain this as best as possible, but it seems I have to spell it out for you. You don't know anything about MySQL, so please, stop acting like you know what you're talking about. If you actually knew anything about MySQL and MySQLi, then you would be able to answer his question. I never said anything about him not knowing MySQLi, I said you didn't.
Ok, let me try to explain this as BEST as possible to you. These new features enable a user to establish database connections easier and more efficient. It's easier for a developer, and more efficient than the traditional MySQL. MySQL does not contain these "newer" features, so it was less efficient and harder to use.
Any further questions? |
|
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
"You don't know anything about MySQL, so please, stop acting like you know what you're talking about."
I do, you don't obviously.
"If you actually knew anything about MySQL and MySQLi, then you would be able to answer his question. I never said anything about him not knowing MySQLi, I said you didn't."
I answered his question the way I wanted, since this is the wrong forum
"Ok, let me try to explain this as BEST as possible to you. These new features enable a user to establish database connections easier and more efficient. It's easier for a developer, and more efficient than the traditional MySQL. MySQL does not contain these "newer" features, so it was less efficient and harder to use. "
tl;dr and I already know most of what you are going to say either way |
|
Tr3eJoin Date: 2011-08-03
Post Count: 54 |
@cntkillme
Sigh, you're one of the users that tries to talk like he knows something.
Cntkillme if you know MySQL create a php script that does this.
The MySQL arguments be the I P you'e connecting to (localhost is fine), the user, pass, and a statement.
Then check to see if the connection fails. If it does- then please print out Connection Failed along with the cause.
Also return the name of the current default database. |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
"The MySQL arguments be the I P you'e connecting to (localhost is fine), the user, pass, and a statement.
Then check to see if the connection fails. If it does- then please print out Connection Failed along with the cause."
In what? MySQL, MySQLi, or PDO? |
|
|
Thanks for the help.
Shame that for some reason XAMPP isn't working right now, localhost works but phpmyadmin isn't. Apache may be having some issues.
Also, while I'm here- how can I encrypt my user "you know whats" better than MD5 without going completely overboard? Making a website and don't want it to have crappy SQLi/XSS/RFI/LFI vulnerabilities, but not much a use if the "you know whats" aren't encrypted well. |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
just use sha1
and xss isn't going to be patched with a simple encryption, I prefer csrf |
|
Tr3eJoin Date: 2011-08-03
Post Count: 54 |
Odd, my last post got messed up.
Create a PHP script that connects to a database.
Here's what you need to know:
* Arguments of the MySQL connection will be IP, User, Pass, and a simple statement.. feel free to name it anything.
* You will need to check if the connection is successful or not. If it's not successful please print out Connection Failed, and the cause of it.
* If you establish the connection successfully, please return the current default database.
* Once you return the current default database, please rename the database to "Hi!".
|
|
|
I know XSS wouldn't be, I'm going to make sure the data's secure.
I guess that works, but I do expect a lot of hackers, so I'm making sure the site is going to be quite a challenge.
|
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
You didn't answer my question... |
|
Tr3eJoin Date: 2011-08-03
Post Count: 54 |
Well, I'll give you the option Cntkillme, MySQL or MySQLi, preferably MySQLi. |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
pastebin/c5qZfted
Not tested and writtin on this forum thinking it would let me, but apparently not so ignore the extra white spaces |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
remove the "{" after the query |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
and the bottom should be $hastag
this is whwat i get for rushing... |
|
Tr3eJoin Date: 2011-08-03
Post Count: 54 |
It's been about 10 minutes, the php script takes less than five for someone who knows even the basics. |
|
cntkillmeJoin Date: 2008-04-07
Post Count: 49450 |
Roblox gave me page error
add spaces
Roblox gave me page error
add more spaces
Roblox game me page error
rename things
Roblox game me page error
pastebin it |
|