Search the Community

ok, just quick... im getting this when trying to login: Unknown column 'e5035533a816cac4c54012281f58543d' in 'where clause' and this is my takelogin.php file: /*==========RUN LOGIN PROCEDURE===============*/$uname = sqlesc($_POST['username']); /*Form Names...*/$pass = sqlesc($_POST['password']); /*Form Names...*/if(isset($pass)){$passhash = md_5($pass); /*Securing The Data...*/}$query = "SELECT * FROM users WHERE username = $uname AND passhash = $passhash AND enabled = 'yes' AND status = 'confirmed'";$query_result = mysql_query($query)or die(mysql_error());//Running query to the DB...if(mysql_num_rows($query_result) == 1)/*if the DB returns somfthing, then run...*/{$row = mysql_fetch_array($query_result);$_SESSION['uid'] = $row['u_id'];$_SESSION['username'] = $row['username'];$_SESSION['pass'] = $row['passhash'];$_SESSION['status'] = $row['status'];$_SESSION['enabled'] = $row['enabled'];$_SESSION['email'] = $row['email'];$_SESSION['ip'] = $row['ip'];$_SESSION['class'] = $row['class'];$_SESSION['time_offset'] = $row['time_offset'];$_SESSION['dst_in_use'] = $row['dst_in_use'];$_SESSION['auto_correct_dst'] = $row['auto_correct_dst'];header('Refresh: 3; url=index.php');//with time delay...}else/*Error messeage...*/{$HTMLOUT .= "<center>Error reading login-session coding base, or a wrong username/pass inserted...</center>";header('Refresh: 3; url=index.php');//with time delay...}/*==========RUN LOGIN PROCEDURE===============*/ any ideas? Oo...

Yo W3S again... i have this little project of my own.its a little hard to explain, but also only a theory, so feel free to ask in to it... i have been watching a project called TBdev (its a torrent project, yes, but hear me out first...). i have been trying to see how they have builded up their login system with cookies. and to be more specific, their functions inside the main-file called bittorrent.php. anyways, i am kinda building my own functions for this to work, but im trying to build in a little different way then them... i think... here is my functions: function login_session($db_output, $update_user_db = 0){set_my_session( "uid" );//name the sessionset_my_session( "pass" );//name the sessionset_my_session( "stylesheet" );//name the sessionif ($update_user_db == '1'){ @mysql_query("UPDATE users SET last_login = ".TIME_NOW." WHERE id = $id");}}function set_my_session( $name ){CODE HERE...}function unset_my_session( $session_name ){unset($_SESSION['{$session_name}']);}function logout_session() {unset_my_session('uid');unset_my_session('pass');} now, as you see. then the login_session is the main function here to login with..now, this is my login file: $res = mysql_query("SELECT id, passhash, username, secret FROM users WHERE username = " . sqlesc($username) . " AND status = 'confirmed'");$row = mysql_fetch_assoc($res);login_session($row); now, as you see. im taking ALL my DB info out into the function. now here comes the part from where im a little lost, because now i need to build up the function that builds it.that would be the (set_my_session)... my point is to take ALL rows/data out FROM where the username are...so i can see WHAT the kind of data the user has.... BUT. as you see on the login_session, im trying to give them different names for Each and one, so i can see the difference on them...that is the way the TBdev project did it, and that was the thing that was giving into me mostly... so here comes the question...if i am going to take ALL the data out from DB, and i need to know the different name on each and one.is it possible to take the row/col name... like if one of the rows were named 'user_id', is it possible to use THAT name to the session?, and as you can see here at my project right now, do you think i can get it to work?... -thanks for advice if possible!... EDIT: and ohh, as you see... im also needing to UNSET the sessions again, that is where the names for the different sessions come into the picture, but give me some advice, because im pretty surtent that this one will work, just needing a little advice to go on with... -thanks!...

Hello everybody, I have a little problem here...I have a XML file, that is a database itself containing information about terminology in two languages... This exemple file is to be "uploaded" into a MySQL databse, on Ubuntu, which is already built and ready to get the information from the XML files... The thing is: how can I start doing this uploading process? Is shell script a good way? Or is it better to use another tool? How? The file is here, attached. Thank you XML_exemple.mtf.xml

hello again, since most of my websites are made in PHP.i would like to ask a maybe little kind of rookie question, if i have 2 servers, and wonna have the Database on the other, and the website on the other.what to do?... i know its possible... just, how?... do i replace the localhost with (examble) speed-scene.com?... (one of my websites)... or do i get it wrong again?... -thanks as usually.

I have a question about the XML. I will admit, I havent spent a ton of time trying to find the answer to this now because I've looked into it in the past with no luck, which is why I never really started using XML to begin with. But I feel like it would be the best option for a site I want to create, and I just need a few clarifications on how to use it.I think I understand the basic structure of an XML document, and all the tags you can create. But my question is once you create the structure, or Schema, What do you do with that to easily insert data. Say I have a simple structure like this<article><title> ABC</title><keywords> </keywords> (Question: would I have several of these tags with multiple keywords?)<summary> </summary><text> </text></article>That may or may not be right, but close enough. If I have many articles I want to post, I really don't want to have to go through and retype all the tags everytime I add something, especially if my actual data has a lot more tags. But I have yet to figure out what I use to insert the data into that format. I'm assuming I can build a form, but I'm not sure how that gets transfered. Can it be done with HTML only or do I need another language?Also, when retrieving the information from the xml file, is that straight html or something else as well? If I missed the page that explains this on the site, you can just point me in the right direction. Also, If I wanted to just pull everything except for the text itself to include on one page, and then specific articles when a linked is clicked on other pages, that can be done right? Would I have a separate page for each dataset? or is it dynamic. Meaning If i click article one, it will show article one without needing a separate file for each additional article?I am somewhat familar with sql and PHP, so that is the method I'm thinking of. I just don't think I need a full fledge database for what I'm doing. I just need to know how data gets inserted once the structure is in place. Thanks

I'm trying to have a website where i take a set of people [ (a) & ( ] and match them automatically, after matched--- person ( gets an email with all of the info of person (a). I would like each to have a seperate sign-on member page… I have no idea where to start so any guidance is appreciated.

Hello all, thank you all for your help so far on problems I have been having over the last few months with a couple of my websites. The one for my motorbike is finished now (I didnt get around to making a PHP contact form as got an apprenticeship so ran out of time to teach it as it was complicating things) I'm back on to my website for my product reviews. Its a 100% non profit organisation and just looks out dated in comparision to other sites that I have seen, plus I have been informed its not IE friendly and when I got it checked for errors it basically broke it with so many errors (totalled about 4000 errors) I have an issue that its not a simple site that I can just upload the content and leave it as it is as I am constantly imputting news and reviews onto the website.There are a few things that I want on the website 1. A news blog for posting news onto it from companies promoting their products that I will review2. Have drop down menus for content3. have content on a database (so a backend is needed) and be able to edit text fast, E.g Copy and paste from word as currently I C+P and then spend 20 mins formatting it as wordpress dont like word content it seems.4. Make it easier to imput pictures to the content where its needed.5, Make it SEO friendly so that I can gain higher rankings in the google searches so my website can then get a bigger audience6. be HTML 5 compatible and all browser friendly7. Have a stylish layout8. Allow changes easily.9. Be safe or safer from hacking. I know that it probably sounds like I am basically asking for the website to be made but I am not. What I am asking for it the time someone will take to suggest how to do something or to help me with a design. My basic website designs that I have 100% scratch built is www.repsolhondanc24.co.uk all but the contact form. The website in question is www.madmercsairsoft.co.uk and the facebook page I want to link to is www.facebook.com/madmercsairsoftreviews I really need to get this sorted soon even with an SEO widget on the site Its not helping at all and im now only hitting 1000 views a week compared to another site I know that gets 1000000 a month at times. I hope someone will help (I would even pay but I cannot afford much at all hence just asking for help finding the right editor/blogger which i can then with help make a theme around Richard

Hello all, I'd like to thank thescientist and niche for the help they gave me on my first help topic. I am now here asking in the PHP side of things of how i can get php to connect to a .mdb (MS Access Database), use that to input text, save, and display. Here is my html source: <html><head><title>Tasks to Complete</title></head><body><table border="1" width="100%" height="100%"><tr width="100%" height="10%"> <td colspan="2" height="10%"> <h2 align="center">Welcome to the Task List</h2> </td></tr><tr width="100%" height="90%"> <td width="50%" height="100%"> <form action="insert.php" method="post"> <fieldset> <legend>Insert Tasks Here:</legend> <textarea rows="15" cols="50" name="task"></textarea> </br> </br> <input type="radio" name="importance" id="highly important" value="Highly Important">Highly Important</input> </br> <input type="radio" name="importance" id="important" value="Important">Important</input> </br> <input type="radio" name="importance" id="can wait" value="Can Wait">Can Wait</input> </br> <p>Date Assigned <input type="text" name="date" id="date" /></p> <p>Time Assigned <input type="text" name="time" id="time" /></p> <input type="submit" id="submit task" value="Submit Task" /> </fieldset> </form> </td> <td width="50%" height="100%"> <iframe width="100%" height="100%" src="viewTasks.php"> </iframe> </td></tr></table></body></html> I tried to use mysql in php, but it did not work. The three attached files are the php i have created so far in trying to get a mysql database. If it can work, i'll stick with the php files, other wise, i'll need some help in trying to get connected to a .mdb file. Thanks, -ProSpartan connect.php insert.php viewTasks.php

Hi guys,I want to create a vb.net application with a login.I want that the login verify the username and password with a table witch contains all usernames and passwords of all members and if the login found a correspondence with the table, I want that the login connect the user at the application.In the next form, I want that the application show some 'informations' like Name, E-mail, ... for the user that is logged in.I have try a lot of code, but none was working correctly.What can I do for make this 'simple' application? Best regards,Francesco

Are there any articles from W3Schools about CGI scripts? I want my forms to send info like username and password to a server so I can process that information with a script in like a mySQL database (so that the user can log on to their customized page in the future). I think that's right at least. Two questions: First: Where and how can I utilize a server to contain this user login info(for now)? Would I use like GoDaddy to get my own server?Second question: How would a CGI script have to be coded in order for it to process this info for later use on my website? or do I need to use PHP for that. I've heard that mentioned in conjunction with mySQL databases.I know this all sounds pretty vague, but I'm continually doing more research on the topic, just wanted to know if anyone could shed some light on the topic. This is a great site, thanks for any and all replies.

Hi. Wonder if anyone can help. Am trying to retrieve records from my order table from a date inputted by the user. I've done all the SQL on my site up to here - this one is really baffling me through. Query: SELECT * FROM [order] WHERE orderDateTime LIKE '04/05/2012%'; However, it doesn't return any values - see my data types in my table below: As you can see from the data view there is data applicable in there to my query: Am at a loss. Can anyone help? Thanks. Kevin

PHP's manual states that the MySQL extension is deprecated, you can see it on any of the mysql function references as in the following page:http://es.php.net/manual/en/function.mysql-connect.php I think it would be good if W3Schools changed or appended new information to their PHP tutorial about the MySQLi extension since it seems to be the most commonly used alternative. Maybe the object-oriented style might not be good to teach, as object-oriented programming would need to be explained in the tutorials, but MySQLi does have a procedural style as well.