Multiple PHP pages, one MySQL connection info page?

Question

I am trying to include a PHP page into another PHP page.

I find it annoying that I have to change the connection info on every page when I upload it to the web host all over agin when I like to edit.

I was wondering if there was a way to include a page that way so I can keep the connection info in one file for all pages.

$username = "a";
$password = "a";
$hostname = "a.com"; 

$mysqli = new mysqli($hostname,$username , $password, 'a');

For example:

http://php.net/manual/en/function.include.php – Jay Blanchard Nov 12 '14 at 20:29 — Jay Blanchard, Nov 12 '14 at 20:29
should i delete it ? ([duplicate]) – user1246950 Nov 12 '14 at 21:01 — user1246950, Nov 12 '14 at 21:01

score 1 · Answer 1 · answered Nov 12 '14 at 20:29

1

Use include to include other files.

1.php:

<?php

$username = "a";
$password = "a";
$hostname = "a.com"; 

$mysqli = new mysqli($hostname,$username , $password, 'a');

2.php:

<?php

include '1.php';
// Rest of your code

3.php:

<?php

include '1.php';
// Rest of your code

answered Nov 12 '14 at 20:29

Bas Peeters

thx i did see this example in 3wschool but it was in to html and it didnt work for me when i tryed it, but i tryed it agin now seem to work not sure why but got what i needed so :) – user1246950 Nov 12 '14 at 20:44

score 1 · Accepted Answer · answered Nov 12 '14 at 20:32

You need to create to files auth.php and config.php
In config.php specify your variables

//config.php
    $username = "a";
    $password = "a";
    $hostname = "a.com";

Include your config file in auth.php

//auth.php
include('config.php');

$mysqli = new mysqli($hostname,$username , $password, 'a');

Use different config.php file on your local and web servers.:)

score 0 · Answer 3 · answered Nov 12 '14 at 20:29

0

You could read a bit on AJAX .. that way you could stay on the same page sending info asynchronously

answered Nov 12 '14 at 20:29

Onilol

3 Answers3