409 questions
<?phpdefine(HOSTNAME,localhost);define(USERNAME,root);define(PASSWORD,root);define(DB_NAME,testDB);$conn = new mysqli(HOSTNAME, USERNAME, PASSWORD, DB_NAME);if($conn->connect_errno) { echo(<b...
Hello!When I want to know the total number of mysql's table Using count (*) is too slow when there is a lot of data...select TABLE_ROWS from information_schema.tables where table_name = 'table name';Y...
I made a login form with HTml, but I don't know how to sign up and put it in db.How can I make it easier?
Hello, I'm a beginner developer.In MYSQL, if you add up to 20 characters of 300 digits, as shown below,substring('12111111111111111111122111111111111111111211111111111111111112111111111111111111121111...
I'm practicing how to use php, html, and mysql to sign up for a web page Php Grammar HTml Grammar Mysql Grammar is not that difficult, but like the example below,Combination? It's so hard to mix itSom...
Converting from Oracle to mysql...select days.mdate , ifnull(login_cnt,0) as login_cnt , ifnull(logout_cnt,0) as logout_cnt from ( select '2016-06-16' as mdate from ts_user where limit 1,1 ) days left...
Developing node.js. I have two years of experience in mssql.Initially, the db part was developed using the mysql module.But I found out that it's called Sequelize.js, so I've been using it.It was a li...
I'm using MacBook Pro Retina Elkepitane.I installed mysql with brew and ran it, but it didn't work, so I started mysql.server. And thenERROR! The server quit without updating PID file (/usr/local/var/...
Hi, everyone. Recently, I've been implementing a page with node.js.If I log in this part, I want to change it to log out. I have no idea how. The advice to use cookies didn't help much.I am using pass...
Hi, everyone.I'm running a simple website with a long story.However, not long ago, the sql injection attack wiped out both DB and server settings and robbed Linux of administrator rights.So I had to b...
« | - 28 - | » |
© 2024 OneMinuteCode. All rights reserved.