MySQL secure password on shared hosting

Question

I created a simple web page for business clients that works with the MySQL database, used mainly by our B2C Prestashop online store. We use shared hosting. This site is mainly based on jQuery jTable (jtable.org) and is intended to display the current approximate supply of products.

I used jQuery jTable 'starter pack' and created a simple interface for our partners. It looks something like the jTable tutorial:

        $(document).ready(function () {

        //Prepare jTable
        $('#PeopleTableContainer').jtable({
            title: 'Product Availability',
            actions: {
                listAction: 'someconfigfile.php?action=list',
            },
            fields: {
                column1: {
                    title: 'column1',
                    width: '70%',
                    key: true
                },
                column2: {
                    title: 'column2',
                    width: '30%'
                }
            }
        });

        //Load person list from server
        $('#PeopleTableContainer').jtable('load');

    });

Since I want to show the data that I have in the MySQL database, I have prepared the user for read-only, and I use his credentials to access the database. As can be seen from the jQuery script, I access the database through someconfigfile.php and a "list".

someconfigfile.php MySQL, SQL- . , , - someconfigfile.php , public_html. , HTML, PHP CSS front-end, public_html.

:

• -, public_html? - jQuery jTable .
• SQL Injection, mysql_fetch_assoc ($ result), json_encode ()? .

: , , jTable CRUD- Read. "", "" "" .

Answer 1

, , , , , .

GoDaddy , , , . , .

, "" , ( , ), - , , - , , .

:

/home/www/html/someSite/dbCredentials.php

( ):

/home/www/html/someSite/application/index.php

:

dbCredentials.php :

<?php
$strHostName = "10.10.10.10"; 
$strDbName = "dbname";
$strUserName = "dbuser";  
$strPassword = "xxx***xxx";
?>

- :

<?php
require_once ('/home/www/html/someSite/dbCredentials.php');
$db_found = new PDO("mysql:host=$strHostName..........);
?>

:

http://support.godaddy.com/help/article/4175/specifying-a-new-default-document-root-on-your-hosting-account?pc_split_value=4&countrysite=uk

, , .

Answer 2

php , , HTTP-, public_html.

, , -, -, , , , , , .

, html , .