DECISION SUPPORT SYSTEM (DSS) using php?
Moderator: General Moderators
DECISION SUPPORT SYSTEM (DSS) using php?
Hello everyone, greetings to all, good day.
I am a newly registered user here in devnetwork. I am currently a 4th year student and I'm having my thesis. The topic of my thesis was "Lourdes C Online Decision Support System".
I am wondering is it possible to create a Decision support system in php? Does anyone have any idea on how to do it? or is it possible? I really need your help everyone. I'm humbly asking for your help.
I hope you'll help me.
Thanks in advance.
I am a newly registered user here in devnetwork. I am currently a 4th year student and I'm having my thesis. The topic of my thesis was "Lourdes C Online Decision Support System".
I am wondering is it possible to create a Decision support system in php? Does anyone have any idea on how to do it? or is it possible? I really need your help everyone. I'm humbly asking for your help.
I hope you'll help me.
Thanks in advance.
Re: DECISION SUPPORT SYSTEM (DSS) using php?
I'm not familiar with what a Decision Support System is. Could you elaborate?
Re: DECISION SUPPORT SYSTEM (DSS) using php?
thank you for the quick reply chalks.
DSS or DECISION SUPPORT SYSTEM is information system which helps the administrator to decide. Lourdes C is the owner of 3 businesses. 1 is the hotel, and 2 are the restaurants.
Each of the business has it's own managers. And managers pass monthly reports to their employer. In my thesis i proposed a project that the manager of every business inputs the information on their website and then submits the report to their employer, then it is where the DSS comes in. The employer will be able to view the whole month's expenses, including the billing expenses, facility expenses, salary expenses for her employee's. She will be able to view how each of her business spends in and out of the money, how much they earn, how much did they spend.
The DSS will help the employee decide what to do, for example, her business profit are falling, then she will access her admin site to find how she could further improve it. Like what if she will deduct some of her employee, will it improve her profit?
That's it for the scope of my thesis. It's not AI. It's just merely a DSS, It helps the owner decide.
DSS or DECISION SUPPORT SYSTEM is information system which helps the administrator to decide. Lourdes C is the owner of 3 businesses. 1 is the hotel, and 2 are the restaurants.
Each of the business has it's own managers. And managers pass monthly reports to their employer. In my thesis i proposed a project that the manager of every business inputs the information on their website and then submits the report to their employer, then it is where the DSS comes in. The employer will be able to view the whole month's expenses, including the billing expenses, facility expenses, salary expenses for her employee's. She will be able to view how each of her business spends in and out of the money, how much they earn, how much did they spend.
The DSS will help the employee decide what to do, for example, her business profit are falling, then she will access her admin site to find how she could further improve it. Like what if she will deduct some of her employee, will it improve her profit?
That's it for the scope of my thesis. It's not AI. It's just merely a DSS, It helps the owner decide.
Re: DECISION SUPPORT SYSTEM (DSS) using php?
Ok, what you're describing is certainly possible to do with php. I would approach it like so:
Decide the way your app will flow. The easiest way to do this will be to have a form that only managers can access. You could secure it either via individual passwords or a corporate wide password, the former being more secure but slightly more complicated. When they fill it out and submit it, it is inserted into a database. The second part of the site would be an application that only a CEO or corporate manager has access to. This part would pull data from the database and you could manipulate it many different ways, depending on what was in the original form that the managers use.
The whole system could get fairly complicated depending on how much information you try to manipulate, but the basic outline of the site is simple.
Decide the way your app will flow. The easiest way to do this will be to have a form that only managers can access. You could secure it either via individual passwords or a corporate wide password, the former being more secure but slightly more complicated. When they fill it out and submit it, it is inserted into a database. The second part of the site would be an application that only a CEO or corporate manager has access to. This part would pull data from the database and you could manipulate it many different ways, depending on what was in the original form that the managers use.
The whole system could get fairly complicated depending on how much information you try to manipulate, but the basic outline of the site is simple.
Re: DECISION SUPPORT SYSTEM (DSS) using php?
hello there sir, thanks for the response.
Please help me, I'm currently having problem connecting with my mySQL database, here is code:
<?php
ob_start();
$host = "localhost"; // Host name
$username = ""; // Mysql username
$password = ""; // Mysql password
$db_name = "4dmIn"; // Database name
$tbl_name = "m3mb3rs"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// Define $myusername and $mypassword
$myusername=$_POST['username'];
$mypassword=$_POST['password'];
...when i tried to browse my login.php file, it displays CANNOT SELECT DB. Please help me. Don't know what to do. Am i missing something?
Please help me, I'm currently having problem connecting with my mySQL database, here is code:
<?php
ob_start();
$host = "localhost"; // Host name
$username = ""; // Mysql username
$password = ""; // Mysql password
$db_name = "4dmIn"; // Database name
$tbl_name = "m3mb3rs"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// Define $myusername and $mypassword
$myusername=$_POST['username'];
$mypassword=$_POST['password'];
...when i tried to browse my login.php file, it displays CANNOT SELECT DB. Please help me. Don't know what to do. Am i missing something?
Re: DECISION SUPPORT SYSTEM (DSS) using php?
Well, there's a few things that could be the cause.
Firstly, you are enclosing your variables in quotation marks. They can just be directly referenced in function calls.
When connecting to a database, I like to assign the connection to a variable and then select the table for that connection. I don't think it is technically needed, but I like to keep track of things like that in case it trips me up later on.
Or maybe your database name is incorrect?
Anyhow, here's how I would imagine that code snippet should look.
Cheers
Firstly, you are enclosing your variables in quotation marks. They can just be directly referenced in function calls.
Code: Select all
mysql_connect("$host", "$username", "$password")or die("cannot connect");
// becomes ...
mysql_connect($host, $username, $password) or die("cannot connect");Code: Select all
mysql_connect($host, $username, $password) or die("cannot connect");
mysql_select_db($db_name)or die("cannot select DB");
// becomes ...
$db_link = mysql_connect($host, $username, $password) or die("cannot connect");
mysql_select_db($db_name, $db_link)or die("cannot select DB");
Anyhow, here's how I would imagine that code snippet should look.
Code: Select all
<?php
ob_start();
$host = "localhost"; // Host name
$username = ""; // Mysql username
$password = ""; // Mysql password
$db_name = "4dmIn"; // Database name
$tbl_name = "m3mb3rs"; // Table name
// Connect to server and select databse.
$db_link = mysql_connect($host, $username, $password) or die("cannot connect");
mysql_select_db($db_name, $db_link)or die("cannot select DB");
// Define $myusername and $mypassword
$myusername=$_POST['username'];
$mypassword=$_POST['password'];
?>Re: DECISION SUPPORT SYSTEM (DSS) using php?
Thanks for the quick reply sir.
I followed what you recommended, but still it displays same error, cannot connect DB.
Please help me. Please. Does it require some windows services? when you type services.msc in the run command, all windows services will appear, does it need any there?
I followed what you recommended, but still it displays same error, cannot connect DB.
Please help me. Please. Does it require some windows services? when you type services.msc in the run command, all windows services will appear, does it need any there?
Re: DECISION SUPPORT SYSTEM (DSS) using php?
Ah ... so you don't have mySQL installed on your system?
If you're developing on your own machine, what PHP environment did you install? Did you just install PHP or did you install Apache, mySQL and PHP as a bundle? If just PHP, what web server are you using?
Or maybe you're working off a hosting server, in which case you'll need to find out about mysql access and configuration.
Sorry I cant be any more specific than that ... it's difficult without more information about your setup and requirements.
If you're developing on your own machine, what PHP environment did you install? Did you just install PHP or did you install Apache, mySQL and PHP as a bundle? If just PHP, what web server are you using?
Or maybe you're working off a hosting server, in which case you'll need to find out about mysql access and configuration.
Sorry I cant be any more specific than that ... it's difficult without more information about your setup and requirements.
Re: DECISION SUPPORT SYSTEM (DSS) using php?
Hello sir, thanks for all the help. But i've figured it out. The only thing i change is the localhost,username and password into "root".
i got it working.
Thanks once again. Can you be my friend?
Thanks once again. Can you be my friend?