Jump to content

Search the Community

Showing results for tags 'MySQL'.

  • 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

  1. Hey you all! I'm sorry if it's in the wrong topic, but couldn't find a more suitable one.I've struggled with my code for the past two days, but somehow can't get it to work.First off HTML+PHP+MySQL code: if($_POST){ $name = $fgmembersite->UserFullName(); $comment = $_POST['comment']; $connect = mysql_connect("random", "ranom", "random", "random") or die(mysql_error()); if($connect){ mysql_select_db("random",$connect); $query = "INSERT INTO data(Name, Comment, date) VALUES ("" . $name . "","" . $comment . "",'DATETIME: Auto CURDATE()')"; if(mysql_que
  2. Hy everyone I would like to get some kind of input for a problem I have. I've got a page (A) wich calls an guestid and selects from the DB the data. Now, I wanna do a Page ( witch is a form Thing is, I need to bring the Guestid from page (a) to page ( - also need to have a new ID (ex. clientid) for the form So far I did it with $_GET['id']; in the page ( i got: $id= (isset($_GET['id']) && is_numeric($_GET['id'])) ? $_GET['id'] : 'new'; the thing is, by opening the form I loos the guestid which I need to reecall somehow. so that there will be at the end: $ID =
  3. Hello, I have run into an issue with what i think might be special characters. Basically I have expanded on the W3 Web Tutorial. http://www.w3schools.com/website/web_spa_daas.asp I have a PhP file that successfully retrieves data form a MySql database (I call the PhP file directly from my browser and it displays the data in the correct format etc) When i then attempt to display the data in an HTML table (of the called upon PhP file ^mentioned above) it fails to display. I am pretty sure that the issue is that in several fields of the PhP query the data contains "[" and "]". Because when i r
  4. Hi i have a table called hospitails. the table structure is as below Hospitals:- Hospital_id Bigint name varchar(45) city_id bigint district_id bigint state_id bigint now i need to search hospitals based on name,city_id,district_id,state_id. the query must cntain all the 4 fields. when user does not provide any of the value all the hospitals with all the names from all the cites,districts,states has to be listed. when user provides partial name and ignores the rest of the three fileds, it has to provide all the hospitals that starts wi
  5. Hello. I have a form with 5 textfields and 1 file field. It can already upload the file to a specified folder but I can't make it work when there are multiple textfields.It doesn't insert into the db table. How do you guys do it? <?phpif(isset($_FILES['filename'])){ $errors = array(); $file_name = $_FILES['filename']['name']; $file_size =$_FILES['filename']['size']; $file_tmp =$_FILES['filename']['tmp_name']; $file_type=$_FILES['filename']['type']; $file_ext=strtolower(end(explode('.',$_FILES['filename']['name'])));if(isset($_POST['name_sender'])){ $nameSender = $_
  6. Dear all. I am planning to embed a google map into a PHP script. The script retrieves data from a MySQL DB into the map. All sources I have come across so far demand the use of XML as an intermediary between MySQL and the map. There is the possibility of writing the map page as a PHP file and outputting JS for markers to be created in the map, but this is claimed to be more problematic method. Is there an easier way to achieve the above without XML or JS?
  7. I've built some pretty sophisticated PHP / HTML / MYSQL scripts at work, but in each case, the action recalls, and reloads the page. So far, I have not needed to use JavaScript, and the pages work exactly as intended. For my purposes, so far, this has worked quite nicely. But, I have a new requirement, that I can not seem to get to work. I am trying to initialize a form, but the form includes a select dropdown box. I would really like to have this update the database entry, and the display, whenever the value in this dropdown box is changed. I am including some snippets
  8. I am making packet type system when in my **Packet Table** , parent packet ( `id` which is primary key ) and its N -Sub Packet is under (`parent_id`) is stored , below is my table structure :**Packet_table** id | packet_name | parent_id | 1 | 01 | 0 2 | 02 | 0 3 | 03 | 1 4 | 04 | 1 5 | 05 | 1 6 | 06 | 4 7 | 07 | 4 8 | 08 | 3 9 | 09 | 5 10 | 010 | 2 ........................so on and on with N packets in same table Below is what i have tried *but
  9. I can not get the values from the javascript add row to go dynamically as a row into MySql only the form values show up as the form below as one row. I made it as an array, but no such luck, I have tried this code around a multitude of ways. I don't know what I am doing wrong, kindly write out the correct way. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Dyn
  10. I am struggling from past 2 hours .Tried : location.reload(); reset form many features but after i close my popup and when reopen or open some another id ..my previous id data is still seen there and its continuous for all id. style : #overlay { position: fixed; top: 0; left: 0; width: 100%; height: 100%; background-color: #000; filter:alpha(opacity=70); -moz-opacity:0.7; -khtml-opacity: 0.7; opacity: 0.7; z-index: 100; display: none; } .content a{ text-decoration: none; } .popup{ width: 100%; margin: 0 auto; display: none
  11. Hi i am using HTML5 Server-Sent Events Actually i need to show notification ( new record enter and which are unread ) thats when any new record is insert in database ( php / mysql ) So for testing purpose i just tried with count of total row. but getting below error message in my localhost : Firefox can't establish a connection to the server at http://localhost/project/folder/servevent/demo_sse.php.line is : var source = new EventSource("demo_sse.php"); WHAT I HAVE TRIED : index.php <script>if(typeof(EventSource) !== "undefined") {var
  12. I have a session running after someone registers and log into my page and i want to use that session ID How can i use the session id to store new information into a other mysql database and when the same user logs in retrieve it again from that database? I want that the user log into the page and then create a character. I just don't know how to bind it together. I made a new page where you need to create/select Character name, $ex, Race, Home world and a new table called "players" with those 4 in it plus id and User_id how would i code it so that the users session ID from the
  13. I have 4 Column ( id (primary) , a, b ,c ,d ) --------------------------------------------------------------------------------------------------------------------------------ID | A | B | C ( where C = SUM B ) | D ( where D = C / A1 , Where A1 = 6 )-------------------------------------------------------------------------------|------------------------------------------------1 | 4 | 3 | 8 | 22 | 6 | 2 |
  14. hi all! please guide me how can i setup table prefix for different users while registering. like. i want to provide same table structure for all users and i think it would be better to use different table prefixes. please suggest me how can i select table prefix from registration data and write it to the mysql connection script automatically. and how can i setup mysql connection better with prefixes..... thank u in advance...
  15. i'm trying to write some line for stock valuation with FIFO method. in the internet somewhere i found with STACK &/or QUEUE method it might be done. but i couldn't understand how it might be done. can anyone please suggest me if STACK &/or QUEUE are the real solution. if no suggest me something better and if yes help me understand these functions.. tahnks in advance.....
  16. i want to insert student result that he calculate some equation and send it to his cell in users database my problem is i cant send the result of some student to his own cell in the users table when i try to do it ,,its always (result) go to the first user that i logged in with ,, i think the issues with my SESSION can any 1 help please ??? my index.php code was <html><head><title>Home Work Page</title></head><body><form action="login.php?login=yes" method="POST"><table border=1> <tr> <td> username : <input type="text" na
  17. hello dear all new to this forums and also new to php. so do not bear with me.well i am not too familiar with PHP. We just should run a few more xpath queries inside the loop for all the address keys and the website. we need to do this here <?php/** * OSM Overpass API with PHP SimpleXML / XPath * * PHP Version: 5.4 - Can be back-ported to 5.3 by using 5.3 Array-Syntax (not PHP 5.4's square brackets) *///// 1.) Query an OSM Overpass API Endpoint//$query = 'node ["amenity"~".*"] (38.415938460513274,16.06338500976562,39.52205163048525,17.51220703125);out;';$context = stream_context_
  18. plus one ("+1") "like button"-voting system I just want to have non-authorization (non-voting "system" at all - just for like button). I want to click "Like"-button key and want to have other users which visit this webpage to see this. Like-button with no additional things (no dislike) just: 1. Press - HTML/Javascript 2. Send PHP (PDO!) 3. Receive Textfile (may be.. mysql) *it has to be as simple as it could be* 4. Show +1, which would be visible to other visitors (ajax/js - optional). That example to be working. I have mysql and apache and php PDO (php5.5.6)! This is with no PDO a
  19. i'm trying to union some tables but it is showing some errors here is what i wrote SELECT sum(amt) AS pamt FROM purchaseUNION SELECT sum(amt) AS samt FROM salesUNION SELECT sum(amt) AS ramt FROM receiptUNION SELECT sum(amt) AS ptamt FROM payment AS pt but it is selecting onle from first table (i.e. purchase) and for others it is saying "undefined index"
  20. i just wanna create website in it..i have my civil plans for home and offices....in it i want to create cart so that when client press the buy button it will come to cart.......and i also wanna create checkout button in cart so that when client finish shopping he will ba able to buy everything he selected........pls post the codes to do this ..........
  21. i learnt how to update single mysql row using jquery and ajax. now i want to learn how can i update multiple rows the same way. this was done to update one row -- var where_val = form.find('#where').val(); var where_col = form.find('#where').attr('name'); input.bind('blur', function(event) { var value = input.val(); $.ajax({ url: action, type: method, data: { val: value, col: column, w_col: where_col, w_val: where_val, }, to try if it works or not for updating multiple rows, i changed this to -- var where_val = form.find('#where').val(); var where_col = form.find('#w
  22. why the last row of the auto increment value is taken as '9' after reaching '10' ? how can i select the last row value from auto increment field after '9'?
  23. I HAD TO RUN resetroot.bat IN MYSQL DIRECTORY WHEN I LOST MY root user account. NOW ALL IS REDEEMED BUT I CANT SEEM TO SET MY root password. SOMEONE SHOULD PLS HELP OUT.
  24. HELLO, PLEASE I NEED TO CONNECT TO A MYSQL SERVER NOT ON MY COMPUTER. I REALLY NEED TO WORK WITH THE DATABASE ON A PROJECT AM DOING. HOW DO I GO ABOUT THIS?
  25. HELLO,PLS, I UNKNOWINGLY DELETED MY "ALL PRIVILEGES" ACCOUNT IN MySQL. RIGHT NOW I CANT CREATE DB, VIEW DB/TABLES. I CANT DO NOTHING JUST LOOK IN THERE. WHAT CAN I DO PLS, IN ORDER TO GAIN CONTROL BACK OF MySQL ACCOUNT. IT MEANS A LOT IF YOU CAN HELP.
×
×
  • Create New...