[Rel] Client Database manager 2.0

[Macemore]

Client Database Manager by

You must be registered for see links

and

You must be registered for see links

I got tired of having a load of sticky notes on my desktop so I decided to create this (With Sean)

Planned features:
Delete clients [d]
Add clients [d]
Edit clients [ns]
List clients [ns]
View clients who owe you money [d]
Specific searches [ns]
[ns] = Not started, [d] = done, [s, %xxx], started %done
More features to be added

Screanshots in spoiler.

Spoiler: downloads

2.1:

You must be registered for see links

2.0:

You must be registered for see links

1.0:

You must be registered for see links

Spoiler: Snippets

Admin.php:

<?php
session_start();
 
if(isset($_SESSION['username'])) {
define('dbm', '1');
include('./incs/inc.php');
 
    if(isset($_GET['page'])) {
 
        $page = $_GET['page'];
       
        if($page == 'home') {
 
            include('./html/home.html');
 
        } elseif($page == 'loader') {
 
            $loader = $_GET['loader'];
 
            if($loader == 'add_client') {
 
define('varinc', '1');
include('./incs/vars.php');
                mysql_query("INSERT INTO clients (name, payamnt, paydate, service, notes) VALUES('{$name}', '{$payamnt}', '{$paydate}', '{$service}', '{$notes}') ") or die(mysql_error());
include('./html/add_success.html');
            } elseif($loader == 'del_client') {
 
define('varinc', '1');
include('./incs/vars.php');
mysql_query("DELETE FROM clients WHERE name='{$name}'") or die(mysql_error());
include('./html/delete_success.html');
 
}
        } elseif ($page == 'delete') {
 
            include('./html/delete.html');
 
        } elseif ($page == 'add') {
 
include('./html/add.html');
 
} elseif ($page == 'check') {
 
include('./incs/date.php');
$cockass = mysql_query("SELECT * FROM clients WHERE paydate='". $date ."'") or die(mysql_error());
if(mysql_num_rows($cockass) == '0') {
include('./html/status_start.html');
echo "No clients owe money today";
} else {
 
if(mysql_num_rows($cockass) > 0) {
include('./html/status_start.html');
while($bobbas = mysql_fetch_array($cockass)) {
 
echo "
<table>
<tr>
<th>Name</th>
<th>Amount ($)</th>
<th>Service</th>
</tr>
<tr>
<td>{$bobbas['name']}</td>
<td>{$bobbas['payamnt']}</td>
<td>{$bobbas['service']}</td>
</tr>
</table>
";
include('./html/status_end.html');
}
}
}
} else {
 
include('./html/home.html');
 
}
} else {
 
include('./html/home.html');
 
}
}
?>

Spoiler: Screen shots and old thread

Updated and styled by

You must be registered for see links

, looks awesome.

Old thread:

You must be registered for see links

Download:

You must be registered for see links

Much thanks to

You must be registered for see links

for the styling. Screen shots coming soon.


EDIT:
Screenies

EDIT(2):
I'll be keeping up with this, as a development.

Change log:
2.1:
Fixed errors after changing file structure
Fixed other errors
2.0:
Styled, changed file structure
Fixed Vulnerabilities and some errors
1.0:
Finished essential system, no styling and SQL vulnerabilities