sqlnoob

March 23, 2008

Clearly I'm doing something wrong with the way I'm determining if the submit button has been clicked, or the way I'm submitting it to the same page.

but what? ???

March 23, 2008

It just doesn't seem to be doing anything after i submit it to the same page, no matter how I try to code it.

March 23, 2008

OK did that but unfortunately that's not where the problem is, as it's not even displaying an error message when the password is wrong, even though it supposed to.

the problem is somewhere in here:

<BODY><H1>Persons Table</H1>

<P><A HREF="index.htm">return</A>

<P><FORM method="Post" action="persona.php"> <INPUT type="password" size=5 maxlength=5 name="viewcheck">
<INPUT type="Submit" value="view" name="submit"> </FORM>
<P>
<?php
if ("view" != $submit) {
echo "need to submit password to view the table";
}
else {
$passcheck = $_POST['viewcheck'];

if ($passcheck == eling)

{

$con = mysql_connect("localhost","shugonl","wZ7cEBx6");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}mysql_select_db("shugonl", $con);

$result = mysql_query("SELECT * FROM persons");

while($row = mysql_fetch_assoc($result))

{

echo $row['Password'] . " " . $row['Clan'] . " " . $row['Username'];

echo "<BR/>";

}

}
else {
echo "incorrect password";
}

}

?>

March 23, 2008

It must be something really easy, but I just don't see what I'm doing wrong there

:'(

March 23, 2008

well I managed to solve the problem with the second page. Turns out the column name in the table was wrong.

but the first page still doesn't work. No matter what I try it just doesn't work. It will not get the POST password after I submit it to itself.

So please help if you can, cause I'm really stuck there.

March 22, 2008

oh yes a misplaced semicolon

March 22, 2008

what kind of errors are you getting?

I'd doublecheck this bit, because no doubt it's hard not to make an error there, like a misplaced semicolon, aphostrophe, or ampersand

print "<meta http-equiv='refresh' content='0;url=http://"."$site"."go.php?n1=$n2&p1=$p2&n2=$n3&p2=$p3&n3=$n4&p3=$p4&n4=$n5&p4=$p5&n5=$n6&p5=$p6&n6=$n7&p6=$p7&n7=$n8&p7=$p8&n8=$n9&p8=$p9&n9=$n10&p9=$p10&n10=&p10=&send=GO"."'>";

};

March 22, 2008

you sure this is ok?

$password = $_GET['password1'];

also can you show me the page before it sends it to this page.

I'm not sure what you're trying to do exactly

March 22, 2008

^

|

now that will work even better

March 22, 2008

how does it mess it up?

what error are you getting?

March 22, 2008

this is what I use in my site to figure out the difference in days between a made time and the current time

$century = mktime(12, 0, 0, 3, 13, 2008);
$today = time();
$timedifference = $today - $century;
$moddifference = floor($timedifference / 86400);

if you replace the $century variable with the time you get from an sql field (one that comes with the post). Then you can get the time that corresponds with the post.

I divide by 86400 for a reason. There are 60 seconds in a minute, 60 minutes in an hour and 24 hours in a day. So 60*60*24 = 86400

So there are 86400 seconds in a day. The $timedifference is the difference in seconds between the two dates, so if you divide it by 86400 you get it in days.

Naturally this is done for only one post. Now all you have to do is figure out a way, to get all the posts you want to check it for and then use an if-else construction to check wether it's a day old or not (or the way you want it to, like 2 days or whatever).

I'm only a noob at this, but I hope this helps you. Best of luck!

March 22, 2008

oh before I forget to mention I use phpadmin as to ore my sql tables

and the second page I get too from a page with an imagemap of Japan (if that's any help)

and example link in the imagemap will look like this:

March 22, 2008

<HTML>

<HEAD>

<TITLE>actions</TITLE>

h1,h2,h3,p {font-family: verdana;}

h1,h2,h3,p {text-align: center}

body {background-color: #2F7B3A;}

a:link {color: #80FFFF}

a:visited {color: #FF80C0}

a:hover {color: #FFFF80}

a:active {color: #80FFFF}

</style>

</HEAD>

<BODY><H1>Provincial survey</H1>

<P>



<?php
$iprov = $_GET['province'];

if(!filter_var($iprov, FILTER_VALIDATE_INT))
{
echo("Integer is not valid");
}
else
{
$con = mysql_connect("localhost","shugonl","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("shugonl", $con);

$resultor =  mysql_query ("SELECT * FROM provinces WHERE Identifier ='$iprov'");
$rower = mysql_fetch_array($resultor);

echo "The province " .$rower['Province']. " is ruled by " .$rower['Owner']. "<BR>The castle is a " .$rower['Castle']. " and the terrain is " .$rower['Machi'];

$rebi = $rower['Attitude'];
$owni = $rower['Owner'];

$dateresult = mysql_query ("SELECT Taxyear FROM persons WHERE Clan ='$owni'");
$daterow = mysql_fetch_assoc($dateresult);
$taxdate = $daterow['Taxyear'];

$thisdate = idate("d");

if ($taxdate == $thisdate) {
if  ($rebi < 4) {echo "<P>the province is peaceful";}
else {echo "<P>the province is rebellious";}
}
else {
$taxiresult = mysql_query ("SELECT Taxheight FROM persons WHERE Clan ='$owni'");
$taxirow = mysql_fetch_assoc($taxiresult);
$taxi = $taxirow['Taxheight'];

switch ($taxi) {
case 5:
$angi = 2;
break;
case 4:
$angi = 1;
break;
case 1:
$angi = -1;
default:
$angi = 0;
}

$newrebi = $rebi + $angi;
mysql_query("UPDATE provinces SET Attitude ='$newrebi' WHERE Identifier ='$iprov'");

if (rebi == 4) {echo "<P>the province is rebellious";}
elseif (rebi < 4) {echo "<P>the province is peaceful";}
else {
echo "<P>the province is lost to the rebels";

// time calculation als de datum elfde maart dit jaar is
$century = mktime(1, 0, 0, 3, 11, 2008);
$today = time();
$timedifference = $today - $century;
$moddifference = floor($timedifference / 86400);
$gameyear = $moddifference + 1477;
$seasonal = idate("H");
if ($seasonal == 18 || 19 || 20 || 21 || 22 || 23) {$season = "WIN";}
elseif ($seasonal == 11 || 12 || 13 || 14 || 15 || 16) {$season = "AUT";}
elseif ($seasonal == 05 || 06 || 07 || 08 || 09 || 10) {$season = "SUM";}
else {$season = "SPR";}

mysql_query("UPDATE provinces SET Owner='rebels' WHERE Identifier='$iprov'");
$messi = $season . " " . $gameyear . " the province of " . $nomprov . " is lost to the rebels";

$countmess = "SELECT * FROM person";
$countresult = mysql_query($countmess);
$mrows = mysql_num_rows($countresult);
$nrows = $mrows + 1;

mysql_query("INSERT INTO Adventures (MessageID, MessageText) 
VALUES ('$nrows', '$messi')");
}

}

}
?>

</BODY>

</HTML>

March 22, 2008

<HTML>

<HEAD>

<TITLE>Administrator Table</TITLE>

h1,p {font-family: verdana;}

h1,p {text-align: center}

body {background-color: #32CD3E;}

</style>

</HEAD>

<BODY><H1>Persons Table</H1>

<P><A HREF="index.htm">return</A>

<P>


<?php
if ("view" != $submit) {
echo "<FORM method='Post' action='persona.php'> <INPUT type='password' size=5 maxlength=5 name='viewcheck'>
<INPUT type='Submit' value='view' name='submit'> </FORM>";
}
else {
$passgood = "hello";
$passcheck = $_POST['viewcheck'];

if ($passgood == $passcheck){
$con = mysql_connect("localhost","shugonl","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("shugonl", $con);

$result = mysql_query("SELECT * FROM persons");

while($row = mysql_fetch_array($result))
  {
echo $row['Password'] . " " . $row['Clan'] . " " . $row['Username'];
echo "<BR/>";
   }

}
else {
echo "incorrect password";
}
}
?>

</BODY>

</HTML>

March 22, 2008

OK I got a problem with a password checking form on the same page.

Either I'm not fetching the sql table right, or it's not getting the POST variable.

Eitherway I'm supposed to get some data from an sql table or recieve a message that the password is incorrect. Instead I get nothing when I click the submit.

I'm quite new at this, so any help is greatly appreciated. I've been trying to get it to work, by looking at tutorials and walkthroughs, but somehow none are helpful, so that's why I post here.

I have a similar problem with another page, where it just don't seem to be displaying something where it should have.

The first page, is the persona.php page with the problem I just described.

The second page is one with a similar problem. I can use help with both.

March 21, 2008

oh wait lol

this is what I did wrong

I mixed the input type with the input name. hahaha silly me

anyway it works now!

thanks alot for the help

March 21, 2008

OK tried it and it doesn't work

March 21, 2008

3) You posted this in the MSSQL area, but you are looking for PHP/MySQL

yeah but that's non-posting. That's why I said, that I'm sorry that I did it here, but I couldn't do it there.

Anyway thanks for the help. I'll look into it and hopefully it will work now.

March 21, 2008

I mean this bit! Why is that necessary? ->

$myServer = "AESERVICES\SQLEXPRESS,1033";

$myUser = "user";

$myPass = "password";

I'm a noob myself, so don't go after my advise, if you really depend on it.

March 21, 2008

why are you using the connector with variables?

Can't you do it without it that way? I mean just place the name, just place your account and just place your password in the connector, instead of defening it, the way you are doing now.

I mean it's php, not javascript, so you don't have to define the variables.

March 21, 2008

I didn't know where else to put this. So please show some mercy, if I for some reason have done something wrong in the placing.

I'm only new at this and English isn't my native tongue.

March 21, 2008

<?php

if ($con = @mysql_connect('localhost', 'shugonl', 'password')) {

mysql_select_db('shugonl', $con);

echo 'connected to the database';

} else {

echo 'connection failed';

}

mysql_select_db("shugonl", $con);

$sqlpersons = "CREATE TABLE persons

(

Password varchar(,

Clan varchar(10),

Username varchar(20),

Coffer int(,

Taxheight int(1),

Yari int(6),

Dachi int(5),

Yumi int(5),

Daisho int(5),

Honjin int(2),

Taxyear int(2),

Attackp int(1),

Lastyear int(2)

)";

mysql_query($sqlpersons,$con);

$startday = idate("d");