Simple Database problem .

Anon

Man it's amazing how could be hard when you try to find a simple Flat-Database solution in this world of Mysql and Postgrep stuff !!

Can someone help here with a tip , script , program wherever else =)

I just need over web using php a simple "view/add/delete" users .

Like this .

1 - List the currently users on the flat file .

2 - Add new user using this kind of method:
name(space)Myserver(space)password.
(The myserver must be in the line)

3 - Delete user .

Then in the archive appear like this :

carlos myserver abc1234
michael myserver cde1323
hello myserver fgh6753

the user enter the informations over web of course =)

Just that simple , anyone can do it very fast , anyone but not me =(

Can someone help ?

Thanks .

kbhatta

I am having a problem with mysql_connect function.
I am using the following version of software for my web server and databse-

php-4.1.2.-7
mysql-3.23.49-3
apache-1.3.23-11

Apache, mysql & php all are running in the same machine.
I have trying to connect to mysql database using "mysql_connect" function in my mysql.php file. But when I am browsing the page I am getting the error message: "Fatal error: Call to undefined function: mysql_connect() in /net/web/tg/php/mysql.php on line 41 "
This
Please help me to fix the problem.

aaadee

View Users

<?php

$connection = mysql_connect or die ("Couldn't connect to server.");
$db = mysql_select_db("DB_NAME") or die ("Unable to select database.");
$sql = "SELECT * FROM TABLE NAME";
$result = mysql_query($sql) or die ("Couldn't get results.");
$sql_result = mysql_query($sql,$connection) or die ("Couldn't execute query.");
$num = mysql_numrows($result);

if (!$sql_result) {
echo "<P>Couldn't get list!";
} else {

echo "
<tr>
<td>User</td>
<td>DATA</td>
<td>DATA</td>
</tr>
";

while( $row = mysql_fetch_array( $sql_result ) )

{

$user = $row["User"];
$data = $row["DATA"];
$data = $row["DATA"];

echo "
<tr>
<td>$user</td>
<td>$data</td>
<td>$data</td>
";

}

aaadee

DELETE USER

PAGE 1

$sql = "SELECT Task_ID, Task_Name FROM jtrs ORDER BY Task_ID";
$connection = mysql_connect( "localhost:3306", "", "" ) or die ("Couldn't connect to server.");
$db = mysql_select_db("JTRS", $connection) or die ("Couldn't select database.");
$sql_result = mysql_query($sql) or die("Couldn't execute query.");

if (!$sql_result) {

echo "<P>Couldn't get list!";

} else {

echo "

<table width=760 border=0 align=center>
<font face=\"Arial, Helvetica, sans-serif\" size=3>
<tr>
<td colspan=5>
<div align=center><img src=../images/jtrs_top.gif width=750 height=125></div>
</td>
</tr>
<tr>
<td align=center><img src=../images/btn_add.gif border=0 width=50 height=15></td>
<td align=center><img src=../images/btn_edit.gif border=0 width=50 height=15></td>
<td align=center><img src=../images/btn_delete.gif border=0 width=50 height=15></td>
<td align=center><a href=../tasks.php><img src=../images/btn_tasks.gif border=0 width=50 height=15></a></td>
<td align=center><a href=../index.php><img src=../images/btn_logout.gif border=0 width=50 height=15></a></td>
</tr>
</table>
<form name=\"deleteForm\" method=\"POST\" action=\"delete2.php\">
<table width=760 border=0 align=center>
<tr>
<td colspan=5 align=center>
<font size=5>Choose a Task to Delete:</font>
</td>
</tr>
<tr>
<td align=right>Task ID / Task Name:</td>
<td valign=top>
<select name=\"sel_record\" onchange=\"javascript:checkDeleteButton();\">
<option value=\"\"> -- Select an Item -- </option>";
while ($row = mysql_fetch_array($sql_result)) {
$task_id = $row["Task_ID"];
$task_name = $row["Task_Name"];
echo "
<option value=\"$task_id\">$task_id : $task_name</option>";
}
echo "
</select>
</td>
</tr>
<tr>
<td align=center colspan=2><input type=\"submit\" name=\"deleteButton\" value=\"delete\" width=50 height=15 DISABLED></td>
</tr>
</table>
</form>
</body>

";
}
?>

aaadee

DELETE USER

PAGE 2

$sql = "SELECT * FROM jtrs WHERE Task_ID='$sel_record'";
$connection = mysql_connect( "localhost:3306", "", "" ) or die ("Couldn't connect to server.");
$db = mysql_select_db("JTRS", $connection) or die ("Couldn't select database.");
$sql_result = mysql_query($sql) or die("Couldn't execute query.");

if (!$sql_result) {

echo "<P>Couldn't get list!";

} else {

$row = mysql_fetch_array($sql_result);

$user = $row["User"];
$task_id = $row["Task_ID"];
$task_name = $row["Task_Name"];
$hours_worked = $row["Hours_Worked"];
$date_work = $row["Date_Work"];
$hours_complete = $row["Hours_Complete"];
$date_complete = $row["Date_Complete"];
$comment = $row["Comment"];

echo "

<head>
<title>e-result JTRS - Delete Page</title>
</head>
<body>
<form method=\"POST\" action=\"delete3.php\">
<input type=\"hidden\" name=\"sel_record\" value=\"$task_id\">
<table width=760 align=center>
<font face=\"Arial, Helvetica, sans-serif\" size=3>
<tr>
<td colspan=5>
<div align=center><img src=../images/jtrs_top.gif width=750 height=125></div>
</td>
</tr>
<tr>
<td align=center><img src=../images/btn_add.gif border=0 width=50 height=15></td>
<td align=center><img src=../images/btn_edit.gif border=0 width=50 height=15></td>
<td align=center><img src=../images/btn_delete.gif border=0 width=50 height=15></td>
<td align=center><a href=../tasks.php><img src=../images/btn_tasks.gif border=0 width=50 height=15></a></td>
<td align=center><a href=../index.html><img src=../images/btn_logout.gif border=0 width=50 height=15></a></td>
</tr>
</table>
<table width=350 align=center>
<tr>
<td align=center><p><b>Delete this from JTRS.</b></p></td>
</tr>
</table>
<table width=350 align=center>
<tr>
<td>User:</td>
<td>$user</td>
</tr>
<tr>
<td>Task Name:</td>
<td>$task_name</td>
</tr>
<tr>
<td>Hours Worked:</td>
<td>$hours_worked</td>
</tr>
<tr>
<td>Date Work:</td>
<td>$date_work</td>
</tr>
<tr>
<td>Hours to Complete:</td>
<td>$hours_complete</td>
</tr>
<tr>
<td>Completion Date:</td>
<td>$date_complete</td>
</tr>
<tr>
<td>Comment:</td>
<td>$comment</td>
</tr>
<tr>
<td align=center colspan=2><input type=\"image\" src=\"../images/btn_delete.gif\" width=50 height=15></td>
</tr>
</table>
</form>
</body>

";
}
?>

aaadee

$sql = "DELETE FROM jtrs WHERE Task_ID = \"$sel_record\"";
$connection = mysql_connect( "localhost:3306", "", "" ) or die ("Couldn't connect to server.");
$db = mysql_select_db("JTRS", $connection) or die ("Couldn't select database.");
$sql_result = mysql_query($sql) or die("Couldn't execute query.");

if (!$sql_result) {

echo "<P>Couldn't get list!";

} else {
echo "Not Working";
}
?>

aaadee

Add a user page.

create a basic form page then submit it to add.php (or whatever)

$sql = "INSERT INTO jtrs (Task_ID, User, Task_Name, Hours_Worked, Date_Work, Hours_Complete, Date_Complete, Comment)
VALUES ('$task_id', '$user', '$task_name', '$hours_worked', '$date_work', '$hours_complete', '$date_complete', '$comment')";
$connection = mysql_connect( "localhost:3306", "", "" ) or die ("Couldn't connect to server.");
$db = mysql_select_db("JTRS", $connection) or die("Couldn't select database.");
$sql_result = mysql_query($sql,$connection) or die("Couldn't add record.");

if (!$sql_result)
{
echo "<p>Couldn't add task!";
}
else
{

echo "

<table width=350 align=center>
<tr>
<td align=center><p><b>Your task was added successfully.</b></p></td>
</tr>
</table><p>
<table width=350 align=center>
<tr>
<td>Task ID:</td>
<td>$task_id</td>
</tr>
<tr>
<td>User:</td>
<td>$user</td>
</tr>
<tr>
<td>Task Name:</td>
<td>$task_name</td>
</tr>
<tr>
<td>Hours Worked:</td>
<td>$hours_worked</td>
</tr>
<tr>
<td>Date Work:</td>
<td>$date_work</td>
</tr>
<tr>
<td>Hours to Complete:</td>
<td>$hours_complete</td>
</tr>
<tr>
<td>Completion Date:</td>
<td>$date_complete</td>
</tr>
<tr>
<td>Comment:</td>
<td>$comment</td>
</tr>
<tr>
<td align=center colspan=2><a href=\"../tasks.php\"><img src=\"../images/btn_continue.gif\" border=0></a></td>
</tr>
</table>
</font>
</body>

";
}
?>