redarrow

barand how you do it , are you a mysql designer, it like you no every think about mysql structure, your fast cool dude

thank you so much your brilliant.

i was told if i use the date function use strtodate() and var char for database. so what can i do if i use the date database format any think interesting? how it more easy that interesting lol

you set the database to a var char setting then you use the date function. <?php $update_date=date("d-y-m"); ?> you update to the database. you then Paul them out with the code you provided. but you want to do what put them back as a array what?

so i lost my password . I got a link for forgotten password, The link gives me a box asking for my email address, when the email address is entered, i then check that email is in the database . i send them a email conformation code via a link with hashed info id ect , i use there id for the database update when they use the email link. they open there email and press the reset password link, it takes them to a page for them to re type a password, i also make a note of data and time they last updated there password, i set a trigger of 5 password changes then there account get ban not deleted, Then i admin contact them sound ok.

i read it from my notes from site pro maybe there wrong only had to try it...

ok what ever. What are you talking about? Removing the quotes from 'rejected' will attempt to set the `completed` field to the value of the `rejected` field if one exists, and has nothing to do with a LIKE comparison.

your correct, auto load files are files that need to start self working usually a database of updates. the folder you got with your host index.php is the folder you add folder in ok... after adding folders then you can use all them flash back and forward slashes. not recommended as said ok.

$ <<<<<<< missing? $ add the >>>rejected

try with no '<<< acts like a LIKE then see what happens? $qq = "update dos set completed = rejected, rejectreason='$rejectreason' where dos_id = '$dosid' LIMIT 1"; mysql_query($qq) or die(mysql_error()); echo out the input see what happening. echo $qq;

http://dev.mysql.com/doc/refman/5.0/en/enum.html let also check if completed is a reserved name for mysql. http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html not seen nothing yet thinking.

we need to see the ajax aswell but it in php forum we don't mind i think?

from a writer of php books You should have one directory as web root, where only files you want exposed to the whole internet should reside. project/ web/ index.php css/ js/ images/ config/ lib/ web/ is the root shown to visitors lib/ is here the library folder, and where autoload look for files. You can add more subfolders to project/ like controller, modules, view, helper, etc. This depeds on your framework.

the way your setting up your folders are silly billy. index.php index.php/images/image.gif index.php/javascript/what_ever.jsp index.php/html/template.html home folder ------ then image folder ----- JavaScript folder------html folder---------- you should be spelling out the folders in realty, not good for seo what your doing sorry. sorry all i no. lets also image that the service provider for all your files went down for good then the next provider got complete different folder structure ill be upset. also let look at a folder, it true to say that in seo one just one extra target word might win your competitors and that can be written as a folder name. i am just saying you can do what you want only p[pointing out facts.

do you mean something like this? you would need to include this at the top of index page.php. the code will always go off and find all the ones in the database then delete the 1 and put back as a 0 and then send a email to the users 1 it just changed. might be bugs is that what you want? <?php $num=1; if($num=="1"){ $db=bd_connection("localhost","username","password"); mysql_connect("database name",$db)or die.mysql_error(); $organogram=$_POST['organogram']); if($organogram){ $select="Select table where organogram = '1'"; myslq_query=($select)or die.mysql_error(); while(delete_entry=mysql_fetch_assoc()){ $to = '$delete_entry['email_address']; $subject = 'There activity with your account'; $message = 'hello please check your account'; $headers = 'From: webmaster@example.com' . "\r\n" . 'Reply-To: webmaster@example.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); mail($to, $subject, $message, $headers); $update="table_name set organogram="0" where organogram = '$delete_entry'"; myslq_query=($update)or die.mysql_error(); } } } ?>

this is a nice way aswell <html> <head> <head> <title> </title> </head> <body> <?php session_start(); $self=$_SERVER['PHP_SELF']; echo"<a href='$self?a=a '>link 1</a>"; echo"<br/><br/>"; echo"<a href='$self?a=b '>link 2</a>"; if($_GET['a']=="a"){ echo " <center> <br /><p> <b> This is page a </b> </p> </center> </body> </html>"; exit; } if($_GET['a']=="b"){ echo " <center> <br /><p> <b> This is page b </b> </p> </center> </body> </html>"; exit; } ?>

you put it altogether now. might be errors not tested the example ok. <?php echo"<a href=" ".$_SERVER["PHP_SELF"]."?a="a" ">link 1</a><br/><br/>"; echo"<a href=" ".SERVER["PHP_SELF"]."?b="b" ">link 2</a>"; if $_GET["a"]=="a"){ echo " this is page a"; break; } if $_GET["b"]=="b"){ echo " this is page b"; break; } ?>

Mahngiel that was a example of when a user put his/her name in on there own. Mahngieli i will shock you, there are a thu websites that people use daily that keep a copy of the unrepeated password in a database and use it on a forgotten issue your be shocked how big business do silly things daily. sorry but i got a password showing when my user join, i send it when they forget there password, i do advise them to change it from month to month. i see what your saying i guess, because i make a admin page to auth all goings on so nothink get auth till i say so. but in the event of a normal website and a learner i agree and sorry.

add a captcha that slow them down http://www.codewalkers.com/c/a/Miscellaneous/Creating-a-CAPTCHA-with-PHP/ go all the way and only allow registered users use your website.

lots of real programmers now days add the famous capcha. it the real only way to solve the problem. http://www.codewalkers.com/c/a/Miscellaneous/Creating-a-CAPTCHA-with-PHP/

loading image example from another web site read it ok. http://www.sitepoint.com/forums/showthread.php?590826-how-to-show-ajax-loading-gif-above-the-page-using-javascript

please take a look at this and use it as a example, your see how it works then add what needed. <?php if (isset($_POST['submit'])){ $password_unhased=$_POST['password']; $password=sha1(md5($_POST['password'])); echo" hello my password is un hashed: $password_unhased"; echo "<br><br>"; echo " hello my password hased what in the database is: $password"; } ?> <form method="POST" action=""> Please enter a password <br /> <input type="password" name="password"> <br /> <input type="submit" name="submit" value="add password"> </form>

when you send the email you send them the unscripted password not the hash password. the hash password goes in the database and the un hashed version goes to the user.

your need ajax mate, sorry php can not do that. you could just tell the user and direct them somewhere else in php/html. if you want a count down to when every think done then your need ajax/JavaScript.

just correctly tell people on the site that the content uploaded is not the ownership of the website and any proven copy written uploads will be deleted./ make sure the person reporting the find proves it there dont fulll in a trap where it a website competitor trying to out do you. remember content uploads help in goggle and can earn you ?????$$$$$