Jump to content
Please Use CODE Tags

Website Programming Help

ReesZRB
By ReesZRB
in Programming
 Share
Posted

Does anyone know how to code a login authenticator in php using sql database? I have little experience with php and the only way I have done a login system is through jankey code like saving the database as .txt file that no one can access but me. I need something more secure now.

 

Spoiler

JumpStart - My 2nd Build - $1000

Link to comment
https://linustechtips.com/topic/424323-website-programming-help/
Share on other sites
Link to post
Share on other sites
Posted

Does anyone know how to code a login authenticator in php using sql database? I have little experience with php and the only way I have done a login system is through jankey code like saving the database as .txt file that no one can access but me. I need something more secure now.

 

i dont recommend asking anyone here. They can really mess you up.

"In the middle of every difficulty lies opportunity."
- Albert Einstein

Link to comment
https://linustechtips.com/topic/424323-website-programming-help/#findComment-5696453
Share on other sites
Link to post
Share on other sites
Posted

it's actually quite easy but instead of writing a huge post right here I'd rather link some guides:

 

Bitfenix Phenom M White | ASUS RoG Maximus VIII Gene | Intel i7 6700K @4.6GHz | HyperX Savage 2800MHz CL14 DDR4 16GB | EVGA GTX1080 SC | Intel 750 Series PCIe SSD 400GB | EVGA SuperNova G2 550W | Windows 10 Professional x64 | Logitech G900, Corsair K70 RGB MXbrown O-ringed, BeyerDynamic DT880 (600 Ω) on Fiio E10K & Samson Meteor | Dell U2715H 27", Samsung SyncMaster P2450H 24", Samsung SyncMaster 931BF 19" | DIY Ambilight

Link to comment
https://linustechtips.com/topic/424323-website-programming-help/#findComment-5696483
Share on other sites
Link to post
Share on other sites
Posted

Where to my friend?

 

Maybe w3schools?

My Rigs:

Gaming/CAD/Rendering Rig
Case:
 Corsair Air 240 , CPU: i7-4790K, Mobo: ASUS Gryphon Z97 mATX,  GPU: Gigabyte G1 Gaming GTX 970, RAM: G.Skill Sniper 16GB, SSD: SAMSUNG 1TB 840 EVO, Cooling: Corsair H80i PCPP: https://au.pcpartpicker.com/b/f2TH99SFF HTPC
Case:
Silverstone ML06B, CPU: Pentium G3258, Mobo: Gigabyte GA-H97N-WiFi, RAM: G.Skill 4GB, SSD: Kingston SSDNow 120GB PCPP: https://au.pcpartpicker.com/b/JmZ8TW
Link to comment
https://linustechtips.com/topic/424323-website-programming-help/#findComment-5696487
Share on other sites
Link to post
Share on other sites
Posted

Does anyone know how to code a login authenticator in php using sql database? I have little experience with php and the only way I have done a login system is through jankey code like saving the database as .txt file that no one can access but me. I need something more secure now.

 

I used to do the same thing (except that the passwords in the text files were encrypted) before I did a long and tedious upgrade to an SQLite database. It's like MySQL but without all the database port/username garbage. It's also a good place to start in my opinion. In future I'll be moving to a proper MySQL database but SQLite is fine for me at the moment.

 

TL;DR Look into SQLite. If you want the challenge though you can take on MySQL and leap ahead. They both use the same SQL syntax so there are effectively no downsides. Also look into SQL Injection - you don't want people doing that to your database.

 

i dont recommend asking anyone here. They can really mess you up.

 

Lol

Speedtests

WiFi - 7ms, 22Mb down, 10Mb up

Ethernet - 6ms, 47.5Mb down, 9.7Mb up

 

Rigs

Spoiler

 Type            Desktop

 OS              Windows 10 Pro

 CPU             i5-4430S

 RAM             8GB CORSAIR XMS3 (2x4gb)

 Cooler          LC Power LC-CC-97 65W

 Motherboard     ASUS H81M-PLUS

 GPU             GeForce GTX 1060

 Storage         120GB Sandisk SSD (boot), 750GB Seagate 2.5" (storage), 500GB Seagate 2.5" SSHD (cache)

 

Spoiler

Type            Server

OS              Ubuntu 14.04 LTS

CPU             Core 2 Duo E6320

RAM             2GB Non-ECC

Motherboard     ASUS P5VD2-MX SE

Storage         RAID 1: 250GB WD Blue and Seagate Barracuda

Uses            Webserver, NAS, Mediaserver, Database Server

 

Quotes of Fame

On 8/27/2015 at 10:09 AM, Drixen said:

Linus is light years ahead a lot of other YouTubers, he isn't just an average YouTuber.. he's legitimately, legit.

On 10/11/2015 at 11:36 AM, Geralt said:

When something is worth doing, it's worth overdoing.

On 6/22/2016 at 10:05 AM, trag1c said:

It's completely blown out of proportion. Also if you're the least bit worried about data gathering then you should go live in a cave a 1000Km from the nearest establishment simply because every device and every entity gathers information these days. In the current era privacy is just fallacy and nothing more.

 

Link to comment
https://linustechtips.com/topic/424323-website-programming-help/#findComment-5696507
Share on other sites
Link to post
Share on other sites
Posted
  • Author

I used to do the same thing (except that the passwords in the text files were encrypted) before I did a long and tedious upgrade to an SQLite database. It's like MySQL but without all the database port/username garbage. It's also a good place to start in my opinion. In future I'll be moving to a proper MySQL database but SQLite is fine for me at the moment.

 

TL;DR Look into SQLite. If you want the challenge though you can take on MySQL and leap ahead. They both use the same SQL syntax so there are effectively no downsides. Also look into SQL Injection - you don't want people doing that to your database.

 

 

Lol

Also I need a new host for my domain. I would also love to have DDoS Protection. Do you recommend any that is affordable? 

 

Spoiler

JumpStart - My 2nd Build - $1000

Link to comment
https://linustechtips.com/topic/424323-website-programming-help/#findComment-5696532
Share on other sites
Link to post
Share on other sites
Posted

Also I need a new host for my domain. I would also love to have DDoS Protection. Do you recommend any that is affordable? 

you should pick something regional so it wont be too expensive. I only know of german hosters like netcup, strato or webtropia.

Bitfenix Phenom M White | ASUS RoG Maximus VIII Gene | Intel i7 6700K @4.6GHz | HyperX Savage 2800MHz CL14 DDR4 16GB | EVGA GTX1080 SC | Intel 750 Series PCIe SSD 400GB | EVGA SuperNova G2 550W | Windows 10 Professional x64 | Logitech G900, Corsair K70 RGB MXbrown O-ringed, BeyerDynamic DT880 (600 Ω) on Fiio E10K & Samson Meteor | Dell U2715H 27", Samsung SyncMaster P2450H 24", Samsung SyncMaster 931BF 19" | DIY Ambilight

Link to comment
https://linustechtips.com/topic/424323-website-programming-help/#findComment-5696553
Share on other sites
Link to post
Share on other sites
Posted

Also I need a new host for my domain. I would also love to have DDoS Protection. Do you recommend any that is affordable? 

 

I don't have much knowledge regarding webhosts since I host from home (at the moment). But, for DDoS protection check out CloudFlare.

Speedtests

WiFi - 7ms, 22Mb down, 10Mb up

Ethernet - 6ms, 47.5Mb down, 9.7Mb up

 

Rigs

Spoiler

 Type            Desktop

 OS              Windows 10 Pro

 CPU             i5-4430S

 RAM             8GB CORSAIR XMS3 (2x4gb)

 Cooler          LC Power LC-CC-97 65W

 Motherboard     ASUS H81M-PLUS

 GPU             GeForce GTX 1060

 Storage         120GB Sandisk SSD (boot), 750GB Seagate 2.5" (storage), 500GB Seagate 2.5" SSHD (cache)

 

Spoiler

Type            Server

OS              Ubuntu 14.04 LTS

CPU             Core 2 Duo E6320

RAM             2GB Non-ECC

Motherboard     ASUS P5VD2-MX SE

Storage         RAID 1: 250GB WD Blue and Seagate Barracuda

Uses            Webserver, NAS, Mediaserver, Database Server

 

Quotes of Fame

On 8/27/2015 at 10:09 AM, Drixen said:

Linus is light years ahead a lot of other YouTubers, he isn't just an average YouTuber.. he's legitimately, legit.

On 10/11/2015 at 11:36 AM, Geralt said:

When something is worth doing, it's worth overdoing.

On 6/22/2016 at 10:05 AM, trag1c said:

It's completely blown out of proportion. Also if you're the least bit worried about data gathering then you should go live in a cave a 1000Km from the nearest establishment simply because every device and every entity gathers information these days. In the current era privacy is just fallacy and nothing more.

 

Link to comment
https://linustechtips.com/topic/424323-website-programming-help/#findComment-5696563
Share on other sites
Link to post
Share on other sites
Posted

Also I need a new host for my domain. I would also love to have DDoS Protection. Do you recommend any that is affordable? 

 

I don't think you will need DDoS Protection, honestly, don't worry about that now! I would simply look for a cheap affordable host (regional), you can switch to a more powerful and more expensive one later, if you need more features. 

Business Management Student @ University St. Gallen (Switzerland)

HomeServer: i7 4930k - GTX 1070ti - ASUS Rampage IV Gene - 32Gb Ram

Laptop: MacBook Pro Retina 15" 2018

Operating Systems (Virtualised using VMware): Windows Pro 10, Cent OS 7

Occupation: Software Engineer

Link to comment
https://linustechtips.com/topic/424323-website-programming-help/#findComment-5697566
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programming

×