sql - Hide Database Login Information in PHP Code -

-

im total beginner in web programming. im trying create simple website reading data sql database. @ first wrote database password , login directly php code:

<?php $username = "login"; $password = "pw"; mysql_connect("server", $username, $password); ... ?>

this isn't idea! (much) more "secure" way this? read putting php code seperate file, meaning not main php document of website, , restricting access file. maybe .htaccess file. way go?

the config.php file , .htaccess classic/good way go. it's way done cms or frameworks.

as pointed johnp, can store config.php outside of public directory, means can't accessed via http. little better security (if don't make mistake .htaccess, there no more risks).

file structure example :

  • config/ -> configuration files
  • lib/ -> libraries , utils php files
  • public/ -> public pages/files/images...

that way, http://www.your-site.com/ points public/, there's no way access config. solution implies can change root web directory (or that).

finally, have remember set file readable , writeable apache user only, not (unix file access rights), if gain access server through user, can't read file.


Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more