Jump to content

Search the Community

Showing results for tags 'data'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

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

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 17 results

  1. Ahmed Ashraf

    The difference between MySQL and SQL

    Hello w3schools community ! I would like to know .. - What is exactly the difference between SQL ( Structured query language ) and MySQL ?, ( with examples if possible ) - Does learning SQL suffice ? Or should I use a RDBMS such as MySQL, Oracle .. etc ? Thank you .
  2. BACKGROUND: I have successfully integrated both pagination and the simplePagination paginator into my website. Now I must fine tune the integration so as to overcome several associated non-optimal conditions. In order to achieve it appears that I need to understand better the use of the variables and functions utilized with the AJAX request. Please consider the following pieces of code and answer the questions below. The JAVASCRIPT: .click(function() { $.ajax({ url: '_utilities/php/ajax_data_dscr.php', dataType: 'JSON', data: { 'podType': podType }, statusCode: { 404: function() { alert( "Page not found" ); }}, success: function (jsonData){ console.log(jsonData) $('#main').html(''); $.each(jsonData, function(key, object){ $('#main').append("<div class='paginate'><div class='item_info podcast_item'><div class='pod_num'>" + object.podcast_no_item + "</div><div class='pod_title'>" + object.item_title + "<br />" + object.item_pubdate + "</div></div><div class='pod_describe'>" + object.item_description + "</div></div>"); }); var collection = $(".paginate"); var collNum = collection.length; var perPage = 10; collection.slice(perPage).hide(); $("#pagn").pagination({ items: collNum, itemsOnPage: perPage, cssStyle: "light-theme", onPageClick: function(pageNum) { var start = perPage * (pageNum - 1); var end = start + perPage; // console.log(event); // console.log(pageNum); collection.hide().slice(start, end).show(); } }); } The HTML: <div id='main'>...</div><!-- end div#main --> <div id='pagn'>&nbsp;</div><!-- end div#pagn --> BACKGROUND: From the above code you can probably notice that the #main DIV is emptied before it is dynamically filled via jQuery's .append() method. The heading of the newly filled #main DIV should vary with the kind of information that is entered. To this end I created the following switch. Unfortunately, however, I cannot get it to work. Either the value of the podType variable is not being read, or the code itself has not been properly set into the AJAX routine. The following is an example of one of my attempts. beforeSend: function(podType) { $('#main').html(''); switch (podType) { case clausal: $('#main').html('<h1>Clausal Analysis</h1>'); break; case linear: $('#main').html('<h1>Linear Analysis</h1>'); break; case inversion: $('#main').html('<h1>Socratic Inversion</h1>'); break; case chrono: $('#main').html('<h1>All Categories</h1>'); break; } } QUESTION ONE: How do I access the key-value pair entered as the value of the data property? QUESTION TWO: How would you go about insuring that a new list heading is entered with each different value of podType. NOTE: You can visit the page by clicking on the words PROXY LINK at the bottom of http://www.grammarcaptive.com/sender_proxy.php In the navigation bar on the page that opens find the word Chronology, click on it, and then click on the phrase Podcast index ... This will show you a successful implementation of simplePagination and provide you with a visual understanding of what I am able and not able to achieve. Roddy
  3. Hi, I've just built a basic web site, but I now realise (by going through the process) that I need to understand other languages & processes in order to make the site streamlined & fully functional. Because I've only learnt html & css (on a basic level) my understanding of php, sql, js, xml, etc is very poor. I therefor need some advice on what the best mechanisms are for inputting data, storing it & displaying it on the web, possibly with some type of rss feed too. The basic process the site is doing, can be described as follows: 1. Users enter data using an online form. 2. Data is stored on a database & manually verified. 3. Certain info from the database is automatically displayed on the site (but not all) in a friendly viewable format. 4. Every time the site is updated a feed is created (like an rss or blog). The first two processes I have achieved, but I am exploring ways of achieving the 3rd & 4th processes. Any advice on what methods or languages would be best to use would be greatly appreciated. I'm happy to learn any coding required. The data set can be stored in various formats (xlsx, csv, ods, tsv, etc), its really a question of the best way to interpret it & automatically display it that I am exploring. Along with creating the feed. Thanks for any advice. Old Guy.
  4. hi friend i am used the java script to display the currency of Iraqi dinars from this xml file http://www.xe.com/datafeed/samples/sample-xml-usd.xml and i used this code <script>if (window.XMLHttpRequest) { xmlhttp=new XMLHttpRequest(); }else { xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); }xmlhttp.open("GET","http://www.xe.com/datafeed/samples/sample-xml-usd.xml",false);xmlhttp.send();xmlDoc=xmlhttp.responseXML; currency=xmlDoc.getElementsByTagName("crate")[65].childNodes[0].nodeValue;document.write(currency);</script> but that is not work and i don't know why? please tell me what is my mistakes ... help me
  5. At the present this is my current website www.mcran.com The problem I am having is how to present all the radio shows I have done over the years including playlists so that visitors could easily access them. I started thinking on a one page solution as follows. These buttons or tabs would run along the top. When you click on a year, the shows and if there is a playlist would appear below on the same page. 2013 - 2012 - 2011 - 2010 - 2009 - 2008. Years ago I did something like this when I was using the Mac web creation app called Rapidweaver. I no longer use this app. At the moment I am using Yola.com. This is the Rapidweaver site I had a few years ago and this is the page that I am interested in when it comes to functionality. Click on a year, info is presented on the same page. Sounds pretty cool and user friendly to visitors to a page like that. http://67.20.76.108/~mcrancom/radionew/radionew.html Please let me know if this is possible to create the same kind of functionality for my site using maybe HTML and or something else? Thanks! Randy www.mcran.com
  6. fikiwan

    display datetime from DB

    Hey ... I want display datetime from DB... EX : 2013-06-10 12:10:5 I want display only year = 2013 MONT = 06 day = 10 how to do like above display the part from datetime. thanks regards
  7. jcc5018

    inserting data into xml

    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
  8. helloI have a question , I thinking whether we can delete a data in one or three table at once time??How Query fo that ?
  9. az.brimatel

    Data Transfer in joomla site

    Hi, I currently have a working joomla site online, but it seems to be affected wif virus, so i am thinking of a solution I tought of backing up the database from phpMyAdmin after doing that i tryed to reinstall joomla 2.5, it worked but it didnt bring back my articles
  10. I have an xml blog and a javascript file i am trying to use to publish this blog to a website with. I am just testing to see if AJAX is working at all because i have been having issues with this for a day now. Here is the Javascript code: function blog(){var xhr = new XMLHttpRequest(); xhr.onReadyStateChange = function(){if(xhr.readyState == 4 && xhr.status == 200){var xmldom = xhr.responseXML;alert(xmldom.documentElement);}} xhr.open("GET","blog.xml",true);xhr.send();} Here is the xml code: <?xml version="1.0" encoding="UTF-8"?><rss version="2.0"><channel><item><title>hello</title> <link>www.google.com</link> <description>world</description></item><item><title>hello</title> <link>www.google.com</link> <description>world</description></item><item><title>hello</title> <link>www.google.com</link> <description>world</description></item></channel> </rss> Finally, here is the HTML code: <div id="blog"><h4>News Updates</h4><script type="text/javascript" src="blog.js" async></script><button type="button" onclick="blog()">click me</button></div> I have it set up to where the button in the HTML code has the onclick event listener that calls the javascript "blog()" function. the problem is that i never does anything NO MATTER WHAT I DO. it is always unresponsive. I never get a single alert box no matter what i make the script do inside the onreadystate function.
  11. kevin.upshaw

    Web Page - Dynamic Table Data Navigation

    Hi. Not quite sure where to start with this one. Am creating a website at the moment, and within that site - in my SQL Compact database I have a "transaction" table. There will be thousands of records in that table - what I want the user to be able to do is search based on a particular parameter - which is fine as I can just use SQL to obtain that information. However, say for instance it returns 100 records - I don't want to display all that data to a user all at once. How would I go about creating a facility to navigate on a table? For instance so it displays ten records at a time? I am using WebMatrix to create this site. Thanks. Kevin
  12. kevin.upshaw

    ASP.NET - Insert Data

    Hi. Quite new to ASP.NET, doing a web design course. I have built a website, and am just building the order part - this is for an assignment. This is the code I have so far: @{ Layout="~/Shared/accountArea.cshtml"; Page.Title="New Order | Sarnies For All"; if (!WebSecurity.IsAuthenticated) { Response.Redirect("~/"); } var db = Database.Open("sarniesForAllCurrent");} <h1>New Order</h1> <p>Here you can create your own sandwich. First of all select your desired bread type from the drop down box below. Then move on to select the filling which you would like in your sandwich/wrap/baguette.</p> <p>All the products shown on this page are in stock, there will be no ringing you informing you that we can't make your order! If you have any issues with this, or have a special request don't hesitate to give us a call or use the Contact Us page.</p> <form id="newOrder" method="post" action="mailto:kevin.upshaw@live.co.uk"> <h2>Choose Bread Type</h2> <fieldset class="newOrder"> <div class="panel"> @{ var extractAvailableBread = "SELECT breadId, breadDescription, price, imgReference FROM [bread] WHERE UPPER(available) = 'YES' ORDER BY breadId "; } @foreach (var row in db.Query(extractAvailableBread)) { <div class="productArea"> <div class="productTitleArea"> <p class="productTitle">@row.breadDescription</p> </div> <div class="productImageArea"> <img class="productImage" src="@row.imgReference" alt="| Sarnies For All" /> </div> <div class="productPriceArea"> <p class="productPrice">£@row.price</p> </div> <div class="productSelectionArea"> <p class="productSelection"><input type="radio" name="breadSelection" value="@row.breadDescription" /></p> </div> </div> } </div> <p class="flip">Open/Close Available Bread Selection</p> </fieldset> <h2 class="clearBreak">Choose Your Filling</h2> <fieldset class="newOrder"> <div class="panel1"> @{ var extractAvailableFilling = "SELECT fillingDescription, price, imgReference FROM [filling] WHERE UPPER(available) = 'YES' ORDER BY filling "; } @foreach (var row in db.Query(extractAvailableFilling)) { <div class="productArea"> <div class="productTitleArea"> <p class="productTitle">@row.fillingDescription</p> </div> <div class="productImageArea"> <img class="productImage" src="@row.imgReference" alt="| Sarnies For All" /> </div> <div class="productPriceArea"> <p class="productPrice">£@row.price</p> </div> <div class="productSelectionArea"> <p class="productSelection"><input type="radio" name="fillingDescription" value="@row.fillingDescription" /></p> </div> </div> } </div> <p class="flip1">Open/Close Available Fillings Selection</p> </fieldset> <h2>Choose Salad Type</h2> <fieldset class="newOrder"> <div class="panel2"> @{ var extractAvailableSalad = "SELECT saladDescription, price, imgReference FROM [salad] WHERE UPPER(available) = 'YES' ORDER BY saladId "; } @foreach (var row in db.Query(extractAvailableSalad)) { <div class="productArea"> <div class="productTitleArea"> <p class="productTitle">@row.saladDescription</p> </div> <div class="productImageArea"> <img class="productImage" src="@row.imgReference" alt="| Sarnies For All" /> </div> <div class="productPriceArea"> <p class="productPrice">£@row.price</p> </div> <div class="productSelectionArea"> <p class="productSelection"><input type="radio" name="saladDescription" value="@row.saladDescription" /></p> </div> </div> } </div> <p class="flip2">Open/Close Available Salad Selection</p> </fieldset> <h2 class="clearBreak">Confirmation</h2> <p>Please confirm your selections and then hit the "Create" order button below. Your order will then be submitted and you will be redirected to your account.</p> <input type="submit" id="submit" name="submit" value="Create Order" /> <input type="reset" id="resetOrderForm" name="resetOrderForm" value="Reset Order Form" /> </form> All the code I have works absolutely fine so far. It queries the "bread" table in the database for "available" bread. The idea I had now is that for each section the user would select one option (hence the use of radio buttons) and when the user selects the option in each section the "*Id" for the option selected is stored in a variable - in which I can then do a SQL INSERT INTO - into the order database. However everything I try code wise has failed on me and wondering if anyone has any suggestions/advice?
  13. Hi, I am reworking an old web site by starting over. I have done a lot of reading on xml to make a database for random or next page link to put on all my web site pages. I have some 1500 pages so when I rebuild I probably only have 500 after cutting the less viewed pages. Anyway, I have inspyder to create gmz sitemaps but can set it to make a xml site map for a database for the web site. I use expression web to create my web site but mostly I hand code in html and a bit of php. I have been doing this since 1999 and still love html.. My problem is how to put a button on my site using the xml sitemap so I can have a next or random link on my web site. I tried using the expression web tools to do this but on my text web site it did not work. I also have zoom indexer that indexes my 11 web sites to create a search engine which I can use to create a sitemap or site index. I have been reading for two day now looking for an answer or software to buy that would allow me to add some type of button to my site so people did not have to search or go back to the navigation to find the next pages. I have found javascript but I can do the same with putting up an html button and simply putting a link to another pages. However I really wanted to find a way to do this without having to add a next buttons by hand on each new website I build so if I remove a page, I don’t have to go back and remove the html link in the future. Does anyone have any advice for an old woman? LOL ThanksKimberly
  14. I'm not quite sure where this should go. JavaScript? I have a search bar, below it, results display in a slider of sorts. Picture I could use cookies or a session to remember the slider's position and what entry the user has selected but it seems easier to use a few hidden input fields and simply update them with a little JavaScript. Is there a reason not to do it this way? Providing that the information being stored is relatively harmless (not a password or anything like that).
  15. scottf

    Simple Data Transfer

    So the user enters a number. the number is stored as the javascript value "fname". When the user goes to a new page, i want that number to still display, but it does not. how can i push that number to the next messages? I looked at the php get method, but i don't see how i could automatically set the entry. So i just need to get this number to the next page. I don't really want to use cookies, i want to use the URL.
  16. scottf

    Transferring Data

    So first my user enters their name. examplevar username = "Scott" So i want this to carry over to the next page. Right now var username is only accessible on this page. Right now, I start on the index.html, user enters name, on welcome.php it says hi scott, then on account.php I want it to say hi scott again, but it says that the value has not been declared. How can i transfer this variable using the URL or a form or something? By the way, welcome.php redirects to account.php, so it needs to be something automatic.
  17. 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 /> <div id="myDiv"><h2>Let AJAX change this text</h2></div> Javascript code I got mostly from w3schools.com:(str = <?php echo $_SESSION['myusername']; ?> --> username of the current user) function showUser(str){if (str=="") { document.getElementById("myDiv").innerHTML="no username"; return; }if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); }else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); }xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("myDiv").innerHTML=xmlhttp.responseText; } }xmlhttp.open("GET","../modules/get.php?q="+str,true);xmlhttp.send();} This is my php file (get.php):(it has a database connection) <?php$q=$_GET["q"];$sql="SELECT * FROM pictures WHERE username='".$q."'";$result = mysql_query($sql);while($row = mysql_fetch_array($result)) { echo "['" . $row['path'] . "', '" . $row['title'] . "'], </br>"; }?> The output is: ['1.jpg', 'Bat bridge in Austin'],['2.jpg', 'Blossoming tree'], ---------- So I want to combine the 2 codes so the image slider will select the right images automatically by connection to the database and getting the "image-links" which correspond with the username. I want this to happen without having to push a button (--> automatically ). I'm not an experienced user/writer of javascript at all, so I hope someone on this forum can help me out. ~ xemx
×