Jump to content

Search the Community

Showing results for tags 'database'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL








  1. 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(my
  2. 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_outp
  3. 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
  4. 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.
  5. 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&
  6. 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.
  7. 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 (totall
  8. ProSpartan

    PHP Database

    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="
  9. 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
  10. 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 tha
  11. 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
  12. 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.
  13. hello , i has a problemo fo make a relation in database my sql , I use XAMP 1.7.7 , can anyone help me , the relation can work , if delete 1 data in database master then data in database relation also remove , ... thx for help
  14. I have information in a php database. I want to retrieve it. The fields are text or memo fields meaning it can hold a lot of data. I got this error. When I retrieve the data, it only gives me the first record. Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 35 bytes) in C:\Users\Public\EasyPHP-\www\phptests\AccountingClass\PrintOutScript.php on line 19 What does this mean and what can I do about it? Thank You Also, i retrieved the first row of data but don't know how to print it out on my page.Here's the script I usedif($choice ='review'){$result=mysql_q
  15. Hello. I am very stuck at one point in my web-page project, and I hope that anyone of you can help me. In short, I'm trying to achieve an AJAX-like effect in a SVG-document. What I mean is that when the SVG-document (in my example below called SVGPage.php) has finished loading and is just sitting there waiting, I want to use AJAX on the click of an SVG-element (in my example the rectangle) to send a request to an external PHP-file (in my example called UpdateSVGPage.php).This "UpdateSVGPage.php" is building up SVG-code based on information from a database, and it will echo it back to the SVG-d
  16. Ok friends: I'm totally stuck, and I desperately need some guidance from you professionals. For the last couple of months I've been working on a web-page project.This is what I've got so far: - I've got a HTML5 page (index.php)- In this HTML5 page, I've got an embedded SVG-file, which is converted to a PHP-file (drawing.php)- It is converted to PHP, because it uses some data in a database to decide what the SVG-image should look like.- In this SVG-file, a PHP-script builds some graphics, and applies some animations to it.- The SVG-file also has a javascript-library attached to it, which I need
  17. i Have 3 table with following fields, 1.users table id, name, password, sub category id, email 2. category table categorie name, category id 3.subcategory table sub category name, sub category id, category id my questian is, how to get users details from user table using category id???????? pleae help
  18. I have included a SVG-file into the html-page with the embed-tag, like this: index.html <!DOCTYPE html><html><head> <script type="text/javascript" src="jquery-1.7.1.js"/> function AJAX(){ $.post("UpdatePage.php",function (PhpParameter){ $("#SVGfile").html(PhpParameter); });} </head> <body> <div style="height:50px;width:50px;background-color:black;" onclick="AJAX()"/> <embed src="SVGimage.svg" type="image/svg+xml" /></body></html> The SVG-file looks like this: SVGimage.svg <?xml version="1.0" standalone="no"?&g
  19. I am working on a website for my work but they will not give me a webserver. So basically I have to run it off a fileshare. This limits me to HTML, Javascript, and CSS formats to get anything done. I need to be able to accept data entered into a form and store it somewhere so it can later be queried for analysis in another website type format. Any suggestions? Somethings to keep in mind also so you know what I'm working with here. - older dell workstations running XP- IE7 is the only browser we are able to use on the work machines- No web server access or ability to pull in data from outside r
  20. Hi I have a very basic question regarding the design of a database. I thought I knew the answer, but after seeing an online tutorial on a triple dropdown menu and the design of the demo database, I'm not so sure anymore. Ok here's the setup, there are three tables involved. First table: tblcountryFields: country_id country Second table: tblstateFields: state_id country_id state Third table: tblcityFields: cidy_id state_id city N
  21. Hello I have this SQL Statement: de.SqlStatement = "SELECT A.Name, A.Catagory , COUNT(Patient_ID) AS PNO FROM PatientApplyToAssociation P INNER JOIN Association A on A.Association_ID = P.Association_ID WHERE A.Catagory='" & "health" & " '" & "' GROUP BY A.Name '" with this Exception: System.Data.SqlClient.SqlException was unhandled by user code class="16" ErrorCode=-2146232060 LineNumber=1 Message=Column 'Association.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. I had this exception when I added the whe
  22. I am making eCommerce Store..there are lot's of inventory and it's update everyday.. I confused, which database support fast indexing ? MySQL, Oracle, MSsql
  23. Hello,I am working on my final project for school and I have to post certain form tasks to the database. I am not all that sharp on every aspect of data connections yet and am struggling. I am using the connection that visual studio creates when you drag and drop the table on the form. It is all working great when I do things by my book, but my teacher asked us to insert something into the data base and I cannot figure out that part. I was looking at an article online about saving something to the database, but it was creating a new object of the class for a specific table and they did not hav
  24. Hello, I am installing a javascript imageslider on my website. But I want to be able to store the "image-link" in a database, so every user can have his own images. This comes from the slidercode (jas.js): var JaS = {// Customization parametersimagePath : "../pictures/",images : [["1.jpg", "Bat bridge in Austin"],["2.jpg", "Blossoming tree", "Tree"],], A lot of other vars are beneath here. ---------- Right now it works with this: <button type="button" onclick="showUser(this.value)" value="<?php echo $_SESSION['myusername']; ?>">Change content</button> <br /> <d
  25. I am working on a website for a company who does Karaoke and they need a song list. I have a sample page of a few songs selected from a sample database I set up. The MySQL and PHP I used organize the artists (removing the word "the" from the artist name), and then the songs when the artist has multiple songs on their list. However, when the artist has multiple entries in the database, I only want their name to appear in the first instance. For example: Adam Ant - Goody Two ShoesThe Beatles - Eleanor Rigby__________ - Hey Jude__________ - The Long and WInding RoadBlondie - Call Meetc. (obviousl
  • Create New...