Anyone know PHP very well?

Badger · Nov 7, 2016

Would anyone like to tell me how this would work please? I created this like months ago and I'm not even sure if it's in any way right. Please let me know where I fucked up or if it all looks good and/or if you tested it for me. Thank you. - TheWolfBadger

PHP:

<?php
/**
* Created by PhpStorm.
* User: TheWolfBadger
* Date: 2/17/15
* Time: 2:35 PM
*/
function create_new_row($serverName, $ip, $bannerLocation, $creator) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $query = $con->query("INSERT INTO servers (server, ip, bannerLocation) VALUES ('$serverName', $ip, '$bannerLocation')");
    if($query == true) {
        //Run Success block
    } else {
        //Run Error block
    }
}
function remove_row($serverName, $creator) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $query = $con->query("DELETE FROM servers WHERE serverName='$serverName'");
    if($query == true) {
        //Run Success block
    } else {
        //Run Error block
    }
}
function getPage($num) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $result = $con->query("SELECT * FROM servers");
    $rows = mysql_fetch_assoc($result);
    return $rows;
}

The config.ini:

Code:

[Database]
host = ""
username = ""
password = ""
dbname = ""
port = ""
socket = ""

Malek668 · Nov 7, 2016

Badger said:

Would anyone like to tell me how this would work please? I created this like months ago and I'm not even sure if it's in any way right. Please let me know where I fucked up or if it all looks good and/or if you tested it for me. Thank you. - TheWolfBadger

PHP:

<?php
/**
* Created by PhpStorm.
* User: TheWolfBadger
* Date: 2/17/15
* Time: 2:35 PM
*/
function create_new_row($serverName, $ip, $bannerLocation, $creator) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $query = $con->query("INSERT INTO servers (server, ip, bannerLocation) VALUES ('$serverName', $ip, '$bannerLocation')");
    if($query == true) {
        //Run Success block
    } else {
        //Run Error block
    }
}
function remove_row($serverName, $creator) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $query = $con->query("DELETE FROM servers WHERE serverName='$serverName'");
    if($query == true) {
        //Run Success block
    } else {
        //Run Error block
    }
}
function getPage($num) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $result = $con->query("SELECT * FROM servers");
    $rows = mysql_fetch_assoc($result);
    return $rows;
}

The config.ini:

Code:

[Database]
host = ""
username = ""
password = ""
dbname = ""
port = ""
socket = ""

cant read it -_- its in black

Badger · Nov 7, 2016

Malek668 said:
cant read it -_- its in black

Lmao check your scheme or copy and paste it to hastebin?

lAkjtzAZ0 · Nov 7, 2016

Badger said:
Lmao check your scheme or copy and paste it to hastebin?

TheGreatBahamut said:
highlight it

yeah, but that wouldn't be necessary if op just used the default color, no need to make it black, it auto-adjusts.

omarhachach · Nov 7, 2016

Badger said:

Would anyone like to tell me how this would work please? I created this like months ago and I'm not even sure if it's in any way right. Please let me know where I fucked up or if it all looks good and/or if you tested it for me. Thank you. - TheWolfBadger

PHP:

<?php
/**
* Created by PhpStorm.
* User: TheWolfBadger
* Date: 2/17/15
* Time: 2:35 PM
*/
function create_new_row($serverName, $ip, $bannerLocation, $creator) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $query = $con->query("INSERT INTO servers (server, ip, bannerLocation) VALUES ('$serverName', $ip, '$bannerLocation')");
    if($query == true) {
        //Run Success block
    } else {
        //Run Error block
    }
}
function remove_row($serverName, $creator) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $query = $con->query("DELETE FROM servers WHERE serverName='$serverName'");
    if($query == true) {
        //Run Success block
    } else {
        //Run Error block
    }
}
function getPage($num) {
    $dir = parse_ini_file("/files/config.ini", true);
    $config = parse_ini_file($dir['Location'], true);
    $logindata = array();
    $logindata['User'] = $config['Database']['User'];
    $logindata['Server'] = $config['Database']['Server'];
    $logindata['Database'] = $config['Database']['Database'];
    $logindata['Port'] = $config['Database']['Port'];
    if($config['Database']['Password']!=null && $config['Database']['Password']!=""){
        $logindata['Password'] = $config['Database']['Password'];
    }else{
        $logindata['Password'] = null;
    }
    $con = new mysqli($logindata['Server'], $logindata['User'], $logindata['Password'], $logindata['Database'], $logindata['Port']);
    if($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $result = $con->query("SELECT * FROM servers");
    $rows = mysql_fetch_assoc($result);
    return $rows;
}

The config.ini:

Code:

[Database]
host = ""
username = ""
password = ""
dbname = ""
port = ""
socket = ""

Why are you doing

PHP:

$dir = parse_ini_file("/files/config.ini", true);
$config = parse_ini_file($dir['Location'], true);

If, you want $config["database"]["user"] or something like that.
Just do:

PHP:

$config = parse_ini_file("/files/config.ini", true);

It is all you need.

--
Best Regards,
Omar H. of NoClue Development.

Badger · Nov 9, 2016

OmarH said:
Why are you doing

PHP:

$dir = parse_ini_file("/files/config.ini", true); $config = parse_ini_file($dir['Location'], true);

If, you want $config["database"]["user"] or something like that.
Just do:

PHP:

$config = parse_ini_file("/files/config.ini", true);

It is all you need.

--
Best Regards,
Omar H. of NoClue Development.

Updated my code, let me know what ya'll feedback is! Thank you, appreciate any criticism!

Code:

<?php

// create_new_row("test", "test", "test");
// remove_row("test");
// getPage(1);

# Create a new row in table $table
# @Usage create_new_row("servers", "serverName, ip, bannerLocation, creator",
# "MinePlex, Mineplex.com, http://website.com/dir/banners/MineplexBanner, Jared"
function create_new_row($table, $tableCategories, $newValues) {
    $query = mysqli_prepare(connection(),
        "INSERT INTO '$table' ('$tableCategories') VALUES ('$newValues');"
    );

    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Create a database in MySQL
# @Usage create_database("myDatabase");
function create_database($database) {
    $query = mysqli_prepare(connection(),
        "CREATE DATABASE '$database';");
    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Delete a database in MySQL
# @Usage delete_database("myDatabase");
function delete_database($database) {
    $query = mysqli_prepare(connection(),
        "DROP DATABASE '$database'");
    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Create a table in MySQL
# @Usage create_table("appointments", "advisor VARCHAR(55), time TIME, appointmentMade TIMESTAMP,
# student VARCHAR(55), studentID VARCHAR(9)");
function create_table($tableName, $tableQuery) {
    $query = mysqli_prepare(connection(),
        "CREATE TABLE IF NOT EXISTS '$tableName' ('$tableQuery');");
    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Delete a table in MySQL
# @Usage delete_table("myTable");
function delete_table($tableName) {
    $query = mysqli_prepare(connection(),
        "DROP TABLE '$tableName';");
    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Remove a row from a table in MySQL
# @Usage remove_row("myTable", "serverName", "Mineplex");
function remove_row($table, $category, $equalcategory) {
    $query = mysqli_prepare(connection(),
        "DELETE FROM $table WHERE '$category' = '$equalcategory';"
    );

    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
    }
}

# Bring back an array of rows from table $table with $numPerPage per page
# @Usage getPage("myTable", 1, 16);
function getPage($table, $page, $numPerPage) {
    $max = $page * $numPerPage;
    $min = ($max - $numPerPage) - 2;
    $query = mysqli_prepare(connection(),
        "SELECT * FROM '$table' LIMIT '$max' OFFSET '$min';"
    );

    $rows = mysqli_fetch_assoc($query->execute());
    $array = [];
    while($min < $max) {
        if(sizeof($rows) >= $min) {
            array_push($array, $rows[$min]);
            $min++;
        }
    }
    return $array;
}

# Run a query to MySQL
# @Usage runQuery("")
function runQuery($query) {
    $query = mysqli_prepare(connection(),
        "'$query'"
    );
    return $query->execute();
}

# Establish MySQL connection()
function connection() {
    $config = parse_ini_file("config.ini", true);

    $connection = mysqli_connect(
        $config['Database']['Host'],
        $config['Database']['User'],
        $config['Database']['Password'],
        $config['Database']['Database'],
        $config['Database']['Port']
    );

    if (mysqli_connect_errno()) {
        die("Connection failed: " . mysqli_connect_error());
    }

    return $connection;
}

omarhachach · Nov 9, 2016

Badger said:

Updated my code, let me know what ya'll feedback is! Thank you, appreciate any criticism!

Code:

<?php

// create_new_row("test", "test", "test");
// remove_row("test");
// getPage(1);

# Create a new row in table $table
# @Usage create_new_row("servers", "serverName, ip, bannerLocation, creator",
# "MinePlex, Mineplex.com, http://website.com/dir/banners/MineplexBanner, Jared"
function create_new_row($table, $tableCategories, $newValues) {
    $query = mysqli_prepare(connection(),
        "INSERT INTO '$table' ('$tableCategories') VALUES ('$newValues');"
    );

    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Create a database in MySQL
# @Usage create_database("myDatabase");
function create_database($database) {
    $query = mysqli_prepare(connection(),
        "CREATE DATABASE '$database';");
    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Delete a database in MySQL
# @Usage delete_database("myDatabase");
function delete_database($database) {
    $query = mysqli_prepare(connection(),
        "DROP DATABASE '$database'");
    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Create a table in MySQL
# @Usage create_table("appointments", "advisor VARCHAR(55), time TIME, appointmentMade TIMESTAMP,
# student VARCHAR(55), studentID VARCHAR(9)");
function create_table($tableName, $tableQuery) {
    $query = mysqli_prepare(connection(),
        "CREATE TABLE IF NOT EXISTS '$tableName' ('$tableQuery');");
    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Delete a table in MySQL
# @Usage delete_table("myTable");
function delete_table($tableName) {
    $query = mysqli_prepare(connection(),
        "DROP TABLE '$tableName';");
    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
        print "False, Failed";
    }
}

# Remove a row from a table in MySQL
# @Usage remove_row("myTable", "serverName", "Mineplex");
function remove_row($table, $category, $equalcategory) {
    $query = mysqli_prepare(connection(),
        "DELETE FROM $table WHERE '$category' = '$equalcategory';"
    );

    if ($query->execute() == true) {
        //Run Success block
    } else {
        //Run Error block
    }
}

# Bring back an array of rows from table $table with $numPerPage per page
# @Usage getPage("myTable", 1, 16);
function getPage($table, $page, $numPerPage) {
    $max = $page * $numPerPage;
    $min = ($max - $numPerPage) - 2;
    $query = mysqli_prepare(connection(),
        "SELECT * FROM '$table' LIMIT '$max' OFFSET '$min';"
    );

    $rows = mysqli_fetch_assoc($query->execute());
    $array = [];
    while($min < $max) {
        if(sizeof($rows) >= $min) {
            array_push($array, $rows[$min]);
            $min++;
        }
    }
    return $array;
}

# Run a query to MySQL
# @Usage runQuery("")
function runQuery($query) {
    $query = mysqli_prepare(connection(),
        "'$query'"
    );
    return $query->execute();
}

# Establish MySQL connection()
function connection() {
    $config = parse_ini_file("config.ini", true);

    $connection = mysqli_connect(
        $config['Database']['Host'],
        $config['Database']['User'],
        $config['Database']['Password'],
        $config['Database']['Database'],
        $config['Database']['Port']
    );

    if (mysqli_connect_errno()) {
        die("Connection failed: " . mysqli_connect_error());
    }

    return $connection;
}

I would say that it is pretty solid code!
Pretty awesome!

--
Best Regards,
Omar H. of NoClue Development.

Anyone know PHP very well?

Badger

Software Developer

Malek668

Badger

Software Developer

lAkjtzAZ0

omarhachach

Your Friendly Neighbourhood Snorlax

Badger

Software Developer

omarhachach

Your Friendly Neighbourhood Snorlax