Adamb10
-
Posts
19 -
Joined
-
Last visited
Never
Posts posted by Adamb10
-
-
I made a powerful guestbook script months ago. It was my most advanced script since it had advanced features but it lacked efficentcy. In order to fix that I tried recoding the query backend which thus forced a complete DB redesign.
If I have a table called "settings" which would store items such as feature enabling/disabling, the title, and other various options what fields would I create? I get Fields, rows and columns mixed up alot. :(
Thanx -
haha oops sorry. Wasnt thinking, was watching the baseball game. Heres the code...
[code]
<?
// START MEMORY BUFFER
ob_start();
//index.php
//Start the session
session_start();
//Load required files
require('sources/functions.php');
//COUNTER STSRT
$c_ip = $HTTP_COOKIE_VARS["user_ip"];
$counter_file = "sources/counter.txt";
$counter_file_line = file ($counter_file);
if(!$c_ip) {
setcookie("user_ip", $REMOTE_ADDR, time()+360000); $counter_file_line[0]++;
$cf = fopen ($counter_file, "w+");fputs($cf, "$counter_file_line[0]"); fclose($cf);
}
elseif($c_ip != $REMOTE_ADDR){
$counter_file_line[0]++; $cf = fopen ($counter_file, "w+");
fputs($cf, "$counter_file_line[0]");
fclose($cf);
}
//END COUNTER
//Essential Functions
db_connect();
//Prepare for Query in 5..4..3..2..1
function query($query){
$sql = "$query";
$result = mysql_query($sql);
return mysql_fetch_array ($result);
}
// Figure out the limit for the query based
// on the current page number.
$from = ($page * $max_results);
//QUERY START
$row = query("SELECT * FROM settings"); //settings query
$row1 = query("SELECT * FROM colors"); //colors query
$max_results = $row['maxshow'];
$q1 = 'SELECT * FROM Bans'; //ban query
$r1 = mysql_query($q1) or die(mysql_error());
if($row['postorder'] == "descend") { //Comment Query 1
$q = 'SELECT * FROM comments ORDER BY Date DESC LIMIT '.$from.', '.$max_results.'';
$r = mysql_query($q) or die(mysql_error());
} else{
if($row['postorder'] == "ascend"){ //Comment Query 2
$q = 'SELECT * FROM comments ORDER BY Date ASC LIMIT '.$from.', '.$max_results.'';
$r = mysql_query($q) or die(mysql_error());
}
}
$hf = query("SELECT * FROM hf"); //HF Query
if (!$hf) {
die('Invalid query: ' . mysql_error());
}
//QUERY END
//CSS BEGIN
echo '
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
<head>
<title>'.$row['title'].'</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
<!--
a:link {
color: #'.$row1['link'].';
text-decoration: none;
}
a:visited {
color: #'.$row1['visitedlink'].';
text-decoration: none;
}
a:active {
color: #'.$row1['activelink'].';
text-decoration: none;
}
a:hover {
color: #'.$row1['hoverlink'].';
text-decoration: none;
}
body {
background-color: #'.$row1['bodybg'].';
font-family: '.$row1['fontfamily'].';
font-size: '.$row1['fontsize'].';
color: #'.$row1['font'].';
margin:0px;
';
if ($row1['bodybgimage'] != "") {
echo 'background-image: url('.$row1['bodybgimage'].');';
}
echo '
}
.titlebg {
background-color: #'.$row1['titlebg'].';
font-family: '.$row1['titlefontfamily'].';
font-size: '.$row1['titlefontsize'].';
color: #'.$row1['titlefont'].'; ';
if ($row1['tilebgimage'] == "") {
echo '
background-image: url('.$row1['titlebgimage'].');';
}
echo '
}
.windowbg {
background-color: #'.$row1['windowbg'].';
font-family: '.$row1['windowfontfamily'].';
font-size: '.$row1['windowfontsize'].';
color: #'.$row1['windowfont'].';';
if ($row1['windowbgimage'] != "") {
echo 'background-image: url('.$row1['windowbgimage'].');';
}
echo '
}
.windowbg2 {
background-color: #'.$row1['window2bg'].';
font-family: '.$row1['window2fontfamily'].';
font-size: '.$row1['window2fontsize'].';
color: #'.$row1['window2font'].';';
if($row1['window2bgimage'] != "") {
echo 'background-image: url('.$row1['window2bgimage'].');';
}
echo '
}
.border {
background-color: #'.$row1['border'].';
}
td {
font-size: 11px;
}
input,textarea {
font-family: '.$row1['fontfamily'].';
font-size: 11px;
}
select {
font-family: '.$row1['fontfamily'].';
font-size: 11px;
}
--!>
</style>
<title>'.$row1['title'].'</title>
</head>
<body>';
//CSS END
if($_GET['action'] == "")
{
getUserIp();
}
//echo out the Guestbook Header
guestbook_header();
echo '<br><br><br>';
require('sources/actions.php');
//Check if this really is index.php.
if($_GET['action'] == "")
{
echo '<br>'.$hf['header'].'';
if($row['posting'] == "enabled") {
if($row['kwikpost'] == "yes"){
if($row['kwikpostlocation'] == "top"){
kwikpost();
}
}}
}
//PAGINATON STARTS HERE
if(!isset($_GET['page'])){
$page = 0;
} else {
$page = $_GET['page'];
}
echo '<br><br>
<table style="width: 55%;" class="border" border="0" cellpadding="4" cellspacing="1" align="center">';
//COMMENT SYSTEM BEGIN
if($_GET['action'] == ""){
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM comments"),0);
// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);
echo '<center>Select a Page: ';
// Build Page Number Hyperlinks
if($page > 0){
$prev = ($page - 1);
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a> ";
}
for($i = 0; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
}
}
// Build Next Link
if($page < $total_pages){
$next = ($page + 1);
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>";
}
{
while($row = mysql_fetch_array($r)){
///END PAGINATION, PROCEED TO NORMAL CODE
echo "</center>";
$date = explode("|", $row['date']);
$name = $row['name'];
$comment = $row['comment'];
$email = $row['email'];
$website = $row['website'];
$hideemail = $row['hideemail'];
if(!isset($cmd)){
echo '
<tr class="windowbg2">
<td style="width: 27%;">';
//HI, WHATS YOUR NAME?
echo
"$name
<br>";
if($hideemail != "o") {
echo "
<a href=\"mailto: $email\">
[email]</a>";
}
if($website != "") {
echo "<a href=\"$website\">[website]</a>";
}
echo '
</td>
<td>';
//DATE SYSTEM
$d = $row['date'];
$month = date("M");
$day = date("d");
$year = date("Y");
//MORE DATESYSTEN
echo 'Posted on ';
if($date['0']==$month && $date['1']==$day && $date['3']==$year){
echo '<b>Today</b>';
} elseif($date['0']==$month && $date['1']==$day-1 && $date['3']==$year){
echo '<b>Yesterday</b>';
} else {
echo '<b>'.$date['0'].' '.$date['1'].''.$date['2'].', '.$date['3'].'</b>';
}
echo ' at <b>'.$date['4'].'</b>';
}
echo "<br><br>
$comment
</td>
</tr>";
}
echo '
<table>
<br>';
//KWIK POST
$row = query("SELECT * FROM settings");
if($row['posting'] == "enabled") {
if($row['kwikpost'] == "yes"){
if($row['kwikpostlocation'] == "bottom"){
kwikpost();
}}}
echo '
'.$hf['footer'].'';
}}
//COMMENT SYSTEM END
copyright();
// FLUSH MEMORY BUFFER (CLEANER THEN LEAVING IT OUT)
ob_flush();
?>
[/code] -
I added a feature that allows the user to set the # of comments per page the software will show. It appears that that featured broke pagination though. Specifically...this line..
[code]
$max_results = $row['maxshow'];
[/code]
Originally $max_results was hardcoded to = 3 but now that its set to whatever is in the DB, not working anymore.
-
[!--quoteo(post=387703:date=Jun 25 2006, 02:25 AM:name=shortj75)--][div class=\'quotetop\']QUOTE(shortj75 @ Jun 25 2006, 02:25 AM) [snapback]387703[/snapback][/div][div class=\'quotemain\'][!--quotec--] try changing this
[code]
if($row['postorder'] == "descend") { //Comment Query 1
$q = 'SELECT * FROM comments ORDER BY Date DESC';
$r = mysql_query($q) or die(mysql_error());
} elseif($row['postorder'] == "ascend"){ //Comment Query 2
$q = 'SELECT * FROM comments ORDER BY Date ASC';
$r = mysql_query($q) or die(mysql_error());
}
[/code]
to this
[code]
if($row['postorder'] == "descend") { //Comment Query 1
$q = 'SELECT * FROM comments ORDER BY Date DESC';
$r = mysql_query($q) or die(mysql_error());
} else{
if($row['postorder'] == "ascend"){ //Comment Query 2
$q = 'SELECT * FROM comments ORDER BY Date ASC';
$r = mysql_query($q) or die(mysql_error());
}
}[/code]
you forgot to put { after else and with that you would need to add } at the end try that and see if it helps [/quote]
Doesnt help at all I dont think. Please note that I have this code in several files too...
[code]
$q1 = 'SELECT * FROM Bans'; //ban query
$r1 = mysql_query($q1) or die(mysql_error());
if($_GET['action'] == "login")
{
$ip1 = $_SERVER['REMOTE_ADDR']; //grab the users ip address
while($row = mysql_fetch_array($r1)){
$ip = $row['ip'];
$reason = $row['reason'];
if($ip==$ip1){
error('You ('.$ip.') have been baned from this guestbook for '.$reason.'');
}
}
if($ip != $ip1) {
[/code]
-
This is hard to explain but here it goes...
I implented a ban system in my guestbook software, ban by ip. However I have a problem with it. When Im not banned I cant access the admin center and add new post page which I should be able to. All I get is a blank page. When I am baned though it works, I get an error message saying im baned and the reason. Heres the code of index.php.
[code]
<?
//index.php
//Start the session
session_start();
//Load required files
require('sources/functions.php');
//Counters are cool, I think we need one...
$c_ip = $HTTP_COOKIE_VARS["user_ip"];
$counter_file = "sources/counter.txt";
$counter_file_line = file($counter_file);
if(!$c_ip) {
setcookie("user_ip", $REMOTE_ADDR, time()+360000); $counter_file_line[0]++;
$cf = fopen ($counter_file, "w+");
fputs($cf, "$counter_file_line[0]"); fclose($cf);
}
elseif($c_ip != $REMOTE_ADDR){
$counter_file_line[0]++; $cf = fopen ($counter_file, "w+");
fputs($cf, "$counter_file_line[0]");
fclose($cf);
}
//Essential Functions
db_connect();
//Prepare for Query in 5..4..3..2..1
function query($query){
$sql = "$query";
$result = mysql_query($sql);
return mysql_fetch_array ($result);
}
//Query time!
$row = query("SELECT * FROM settings"); //settings query
$row1 = query("SELECT * FROM colors"); //colors query
$q1 = 'SELECT * FROM Bans'; //ban query
$r1 = mysql_query($q1) or die(mysql_error());
if($row['postorder'] == "descend") { //Comment Query 1
$q = 'SELECT * FROM comments ORDER BY Date DESC';
$r = mysql_query($q) or die(mysql_error());
} elseif($row['postorder'] == "ascend"){ //Comment Query 2
$q = 'SELECT * FROM comments ORDER BY Date ASC';
$r = mysql_query($q) or die(mysql_error());
}
$hf = query("SELECT * FROM hf"); //HF Query
if (!$hf) {
die('Invalid query: ' . mysql_error());
}
//Lets output the html
echo '
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
<head>
<title>'.$row['title'].'</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
<!--
a:link {
color: #'.$row1['link'].';
text-decoration: none;
}
a:visited {
color: #'.$row1['visitedlink'].';
text-decoration: none;
}
a:active {
color: #'.$row1['activelink'].';
text-decoration: none;
}
a:hover {
color: #'.$row1['hoverlink'].';
text-decoration: none;
}
body {
background-color: #'.$row1['bodybg'].';
font-family: '.$row1['fontfamily'].';
font-size: '.$row1['fontsize'].';
color: #'.$row1['font'].';
margin:0px;
';
if ($row1['bodybgimage'] != "") {
echo 'background-image: url('.$row1['bodybgimage'].');';
}
echo '
}
.titlebg {
background-color: #'.$row1['titlebg'].';
font-family: '.$row1['titlefontfamily'].';
font-size: '.$row1['titlefontsize'].';
color: #'.$row1['titlefont'].'; ';
if ($row1['tilebgimage'] == "") {
echo '
background-image: url('.$row1['titlebgimage'].');';
}
echo '
}
.windowbg {
background-color: #'.$row1['windowbg'].';
font-family: '.$row1['windowfontfamily'].';
font-size: '.$row1['windowfontsize'].';
color: #'.$row1['windowfont'].';';
if ($row1['windowbgimage'] != "") {
echo 'background-image: url('.$row1['windowbgimage'].');';
}
echo '
}
.windowbg2 {
background-color: #'.$row1['window2bg'].';
font-family: '.$row1['window2fontfamily'].';
font-size: '.$row1['window2fontsize'].';
color: #'.$row1['window2font'].';';
if($row1['window2bgimage'] != "") {
echo 'background-image: url('.$row1['window2bgimage'].');';
}
echo '
}
.border {
background-color: #'.$row1['border'].';
}
td {
font-size: 11px;
}
input,textarea {
font-family: '.$row1['fontfamily'].';
font-size: 11px;
}
select {
font-family: '.$row1['fontfamily'].';
font-size: 11px;
}
--!>
</style>
<title>'.$row1['title'].'</title>
</head>
<body>';
//Ban System
if($_GET['action'] == "")
{
$ip1 = $_SERVER['REMOTE_ADDR']; //grab the users ip address
while($row = mysql_fetch_array($r1)){
$ip = $row['ip'];
$reason = $row['reason'];
if($ip==$ip1){
error('You ('.$ip.') have been baned from this guestbook for '.$reason.'');
}
}
}
if($ip != $ip1) {
//echo out the Guestbook Header
guestbook_header();
echo '<br><br><br>';
require('sources/actions.php');
//Check if this really is index.php.
if($_GET['action'] == "")
{
echo '<br>'.$hf['header'].'';
if($row['posting'] == "enabled") {
if($row['kwikpost'] == "yes"){
if($row['kwikpostlocation'] == "top"){
kwikpost();
}
}}
}
echo '<br><br>
<table style="width: 55%;" class="border" border="0" cellpadding="4" cellspacing="1" align="center">';
//Prepare the comment system...
if($_GET['action'] == "")
{
while($row = mysql_fetch_array($r)){
$date = explode("|", $row['date']);
$name = $row['name'];
$comment = $row['comment'];
$email = $row['email'];
$website = $row['website'];
if(!isset($cmd)){
echo '
<tr class="windowbg2">
<td style="width: 27%;">';
//Hi, whats your name?
echo
"$name
<br><a href=\"mailto: $email\">
[email]</a>";
if($website != "") {
echo "<a href=\"$website\">[website]</a>";
}
echo '
</td>
<td>';
//Date System
$d = $row['date'];
$month = date("M");
$day = date("d");
$year = date("Y");
//Was the comment posted yesterday or today?
echo 'Posted on ';
if($date['0']==$month && $date['1']==$day && $date['3']==$year){
echo '<b>Today</b>';
} elseif($date['0']==$month && $date['1']==$day-1 && $date['3']==$year){
echo '<b>Yesterday</b>';
} else {
echo '<b>'.$date['0'].' '.$date['1'].''.$date['2'].', '.$date['3'].'</b>';
}
echo ' at <b>'.$date['4'].'</b>';
}
echo "<br><br>
$comment
</td>
</tr>";
}
echo '
<table>
<br>';
//Kwik Post time!
$row = query("SELECT * FROM settings");
if($row['posting'] == "enabled") {
if($row['kwikpost'] == "yes"){
if($row['kwikpostlocation'] == "bottom"){
kwikpost();
}}}
echo '
'.$hf['footer'].'';
}
copyright();
}
?>
[/code]
Thanks!! -
Now, I cant get the code that actually edit's the DB to work. Ah well, Im sure I can tackle it on my own. :)
-
Yep that was it, I moved the textboxes to a new file and now it works.
Thanks!! -
hmmm... I see. I should probobly close that if statement earlier then?
-
ummm..I posted the code on the last page, but heres more of it.
[code]
if(!isset($cmd))
{
$result = mysql_query("select * from comments order by id");
while($r=mysql_fetch_array($result))
{
$name=$r["name"]; //take out the title
$id=$r["id"]; //Take out the id
$date=$r["date"]; // Take out the Date
echo "
<tr>
<td class='windowbg2'>$id</td>
<td class='windowbg2'>$name</td>
<td class='windowbg'><a href='?action=comments&cmd=edit&id=$id'>Edit</a></td>
<td class='windowbg'><a href='?action=comments&cmd=delete&id=$id'>Delete</a></td>
</tr>
</center>";
if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
if (!isset($_POST["submit"]))
{
$id = $_GET["id"];
$sql = "SELECT * FROM comments WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
//PHP, we need you to cool down so get a drink and relax.
?>
<form action='?action=editing' method='post'>
<input type=hidden name='id' value="<? echo $myrow["id"] ?>">
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<td class='titlebg' colspan='2'><b>Edit Comment</b></td>
</tr><tr>
<td class='windowbg2' width='30%'><b>Name:</b><br>
<font class='subtext'>The name the person used to tell who they are.</font></td>
<td class='windowbg'><input type='text' name='title' size='40' value="<? echo $myrow["name"] ?>"></td>
</tr><tr>
<td class='windowbg2' width='30%'><b>Email:</b><br>
<font class='subtext'>The email the person used to be contacted.</font></td>
<td class='windowbg'><input type='text' name='name' size='40' value="<? echo $myrow["email"] ?>"></td>
</tr><tr>
<td class='windowbg2' width='30%'><b>Website:</b><br>
<font class='subtext'>The website the person entered in. This field is optional</font></td>
<td class='windowbg'><input type='text' name='name' size='40' value="<? echo $myrow["website"] ?>"></td>
</tr><tr>
<td class='windowbg2' width='30%'><b>Comment:</b><br>
<font class='subtext'>The comment the user entered in.</font></td>
<td class='windowbg'><textarea name='comment' cols='38' rows='5'><? echo $myrow["comment"] ?></textarea></td>
<input type='hidden' name='cmd' value='edit'>
</tr>
<tr>
<td class='titlebg' colspan='2' align='right'><input type='submit' value='Edit Comment'> <input type='reset' value='Reset'></td></tr>
</form>
<?
}
}
}
}
[/code]
-
[img src=\"http://www.adamb10.com/edit2.jpg\" border=\"0\" alt=\"IPB Image\" /]
Theres the new screenshot, what it looks like after you hit edit.
-
:p Right now I just wanna get a working script and then optimize/clean it up.
P.S. Adding a & and removing the ? kinda works. I get the same page only without the posts. -
Second edit? Theres only 1 edit you click to get to the form.
[img src=\"http://adamb10.com/edit.jpg\" border=\"0\" alt=\"IPB Image\" /]
OR...
[a href=\"http://adamb10.com/ub2/?action=login\" target=\"_blank\"]http://adamb10.com/ub2/?action=login[/a]
adam/hakkar are the login details
Click comments
Click Edit for any of the comments
-
Instead of creating a new topic...
I got the code to run thanks to starting and stopping PHP like previously mentioned. Now I got another problem(not a parse error :)).
The whole purpose of this file is to let the admin edit/delete comments. When the admin clicks edit to edit a topic, the url goes to ?action=comments?cmd=edit&id=15. Unfortuantely, when I do click edit, it goes to a blank page instead of a few text boxes. The code for this is right here...
[code]
if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
if (!isset($_POST["submit"]))
{
[/code]
I use the action urls system where every action(like ?action=logout) is stored in actions.php. Heres a sampling from that file...
[code]
$action = $_GET['action'];
if($action == "login"){
require('login.php');
}
if($action =="admin"){
require('admin/admin.php');
}
[/code]
Any reason this wont work?
Thanks! -
I did do that Caesar(just not in this file), but in this file nothing works.
-
Yeah, I get confused with the variable stuff and quotes.
-
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/adamb10/public_html/ub2/sources/admin/commentmanagement.php on line 74
[/quote]
I looked over the code twice, the only thing that catches my eye is the value= part and I tried changing that but I still got the error. -
Scroll down to post #11 plz.
-
Hey all,
[a href=\"http://adamb10.com/ub2/index.php?action=login\" target=\"_blank\"]http://adamb10.com/ub2/index.php?action=login[/a] See that the guestbook header(the menu on the bottom) is being printed well on the bottom? :p I dont want it there. I only want it on the top.
Time for some code.
Index.php....
[code]
<?
//index.php
//Start the session
session_start();
//Load required files
require('sources/functions.php');
require('sources/actions.php');
require('sources/actions2.php');
//Essential Functions
db_connect();
//Prepare for Query in 5..4..3..2..1
function query($query){
$sql = "$query";
$result = mysql_query($sql);
return mysql_fetch_array ($result);
}
//Query time!
$row = query("SELECT * FROM settings");
$row = query("SELECT * FROM colors");
//Lets output the html
echo '
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
<!--
a:link {
color: #'.$row['link'].';
text-decoration: none;
}
a:visited {
color: #'.$row['vistedlink'].';
text-decoration: none;
}
a:active {
color: #'.$row['activelink'].';
text-decoration: none;
}
a:hover {
color: #'.$row['hoverlink'].';
text-decoration: underline;
}
body {
background-color: #'.$row['bodybg'].';
font-family: '.$row['fontfamily'].';
font-size: 11px;
color: #'.$row['font'].';
margin:0px;
}
.titlebg {
background-color: #'.$row['titlebg'].';
font-family: '.$row['fontfamily'].';
font-size: 11px;
color: #'.$row['titlefont'].';
}
.windowbg {
background-color: #'.$row['windowbg'].';
font-family: '.$row['fontfamily'].';
font-size: 11px;
color: #'.$row['font'].';
}
.windowbg2 {
background-color: #'.$row['window2bg'].';
font-family: '.$row['fontfamily'].';
font-size: 11px;
color: #'.$row['font'].';
}
.border {
background-color: #'.$row['border'].';
}
td {
font-size: 11px;
}
input,textarea {
font-family: '.$row['fontfamily'].';
font-size: 11px;
}
select {
font-family: '.$row['fontfamily'].';
font-size: 11px;
}
--!>
</style>
<title>'.$row['title'].'</title>
</head>
<body>';
//echo out the Guestbook Header
guestbook_header();
echo '
</body>
</html>';
?>
[/code]
Login.php...
[code]<?
//login.php
//essential functions to life
db_connect();
guestbook_header();
echo '
<br>
<center>
<table class="border" style="width: 25%; text-align: left; margin-left: auto; margin-right: auto;" border="0" cellpadding="4" cellspacing="1" class="border">
<tr class="titlebg">
<td>Login</td>
</tr>
<tr class="windowbg2">
<td>
Please
login using your details below:<br>
<table style="width: 25%; text-align: left; margin-left: auto; margin-right: auto;" border="0" cellpadding="4" cellspacing="1">
<tr>
<br> <form method="post" action="?action=loggingin" name="Login">Username: <input size="20" name="Username"></tr><tr>
Password: <input size="20" name="Password" type="password"></tr><br><br>
</table>
<div style="text-align: center;"><input value="Login" type="submit"></div>
</td>
<br>
</form>
</td>
</tr>
</table>
</center>
';
?>
[/code]
actions.php....
[code]
<?
//actions.php
$action = $_GET['action'];
if($action == "login"){
require('login.php');
}
if($action =="admin"){
require('admin.php');
}
?>
[/code]
actions2.php....
[code]
<?
//actions2.php
if (isset($_GET['action'])) {
$action = $_GET['action'];
if($action == "login"){
return('actions.php');
}elseif ($action == "processlogin"){
return('actions.php');
}
}
?>
[/code]
The code in actions2.php is supposed to prevent what is happening right now but it's not now.
Any help is greatly welcomed! [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]
Thanks!
Fields, Rows, Columns, it's all confusing!
in MySQL Help
Posted