Macemore
Circumcised pineapples
Client Database Manager by
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.
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
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.
2.1:
2.0:
1.0:
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
Admin.php:
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');
}
}
?>
Updated and styled by
Old thread:
Download:
Much thanks to
EDIT:
Screenies
EDIT(2):
I'll be keeping up with this, as a development.
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.
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