Jump to content

ohad

Members
  • Content Count

    20
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ohad

  • Rank
    Member
  1. Hello I have 2 database tables: 1) products which contain 3 columns: id, description and unit 2) units which contains 2 columns: id and description I need to pupulate html table with data from 2 database tables.this is the structure: id, description, unit, unit_description (the first 3 columns come from table 1 and the fourth column from table 2 I know hot to pupulate the table according to the 3 columns: (the remarks are for the 4th column that i dont know how to call). I want this column to get the description of the unit in the row from the second table in the
  2. Hi I have a table i populate from database (upon a parameter the user insert and with PHP $_GET i take this value and populate the table accordint to if). After I allow the user to add or edit data in rows by using jquery. The last part I do is to want to save the changes back to database using PHP. The jquery i use suppose to serve different tables. So its written in a way that get the table structure and add rows upon it. In this example I put it in the index page Everything works fine,but I cant build the array from the added rows. My variables in the php part got null
  3. Hi all, I try to populate html table by query and ajax. The idea is that i have a textbox in which the user enter a code, the system get its description upon focusout event from the database. (This section works well) After that, upon double click on the description that was retrived, the js should populate the table upon the code the user enterd. The problem is that in this case i get an error: Uncaught TypeError: Cannot use 'in' operator to search for 'length' in I tried to search the web. Most suggest to add JSON.parse. But the data is already on JSON format
  4. Thank you very much Works great. Issue is closed
  5. Hi all I build an app with a header, side-bar, footter and main area (here is the index.php code (Removed all php activity cause its not relevant here <!DOCTYPE html> <html> <head> <title>Login</title> <meta charset="UTF-8"> <script type="text/javascript" src="../../php-ajax/jquery-3.5.1.js"></script> <script type='text/javascript' src='js/dynamicpage.js'></script> <link href="css/global_style.css" type="text/css" rel="stylesheet" madia="all"/> </head> &l
  6. Hi I use bootstrat treeview which is build upon a databse query. I have no idea how many nodes will apear at the treeview. I limit its size by using min-height and overflow-y:scroll in the css file it all looks good when the nodes are folded. but when i open a node it exceed the limit i declared. Does anyone has an idea how can i limit the height of the treeview no matter if nodes are expanded? Thank you
  7. Hi All I have a site which is built from 3 folders: folder1 frolder2 frolder3 folder1 is the "master" folder. Means, In it I have the login page, connecxtion to DB elements, and header, footer and bootstrap treeview sidebar which I want to use in all the pages of the site. folders 2 and 3 each store all pages concern a specific vertical. The sidebar, which is located at folde1 retrive the content from database using AJAX, and Ive overloaded some of the original css by using custom css. here is psrt of the sidebar code: <link href="custom.css" typ
  8. OK problem solved The issue was $id = $value['ID']; once i changed names of fields to capital letters, all works fine
  9. This still leaves $id from this $id = $value['id'] line null
  10. Hi all, I have a query that return data into the array $row with values, but $id from the first line of the while stay null. Why? $con = oci_connect("xxx", "xxx", "xxx"); $query = "SELECT id, name from table_web WHERE record_module='AA' and parent_id='".$parentId."'"; $stid=oci_parse($con, $query); oci_execute($stid); while($value = oci_fetch_assoc($stid)) { $id = $value['id']; $row[$id]['id'] = $value['id']; $row[$id]['name'] = $value['name']; } return $row;
  11. Ok, I did replacement of double quote symbol by using this data=data.replace(/['"]+/g, ""); before assigning the value to the in[put textbox Issue is closed
  12. Ok tnx. did it. now it returned the data to the input textbox as i wanted but wrapped with "" is it ok? i just need to take care to ommit these "", or still i do something wrong?
  13. Barand. The suggstion exit(json_encode($data)); didn't make a different. I did a change and the took the php code that was in the same page of the html and script to a different php page (which i put int the ajax url) Now I get data like this: [{:"productname":"product1"}] when i see it on debug it has the symbol of enter key before but when i try to use it in the success function: $('#productid_desc').val(data.productname); I get undefined. When I use it $('#productid_desc').val(data.); I get [{:"productname":"product1"}] in the input textbox What d
  14. Hi all I try to fill a readonly textbox on my page with a description of a product the user put in an product_id inputbox. for that I use a jquery and ajax as a json form but the result i get when i debug it is that the data.productname is undefined. I have no idea what is wrong with my code. Can anyone guide me to the reason? This is the part of the php that get the product desc from the database and the relevant sources I use of jquery and bootstrap btw after the json_encode i added json_last_error_msg and recieved no error message, so its something in the jquery in my un
  15. Thank you very much. Splitting the open_empty into 2 pages and call each of them seperatly did the work Issue solved
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.