Generate Table From Which Can Easily Edit Contents Of A MySQL Database
Jul 30, 2009
I would like to be able to generate a table from which I can easily edit the contents of a mySQL database (similar to phpMyAdmin.) In that table I would like to have a button that will open a pop-up, allowing me to edit - and maintain formatting such as apostrophes and line breaks - a long description field. That popup will then populate a hidden input field on its parent with the modified description.
I've got the pop-up opening and its fields are populated using php's GET function (see line 11). The special characters, particularly carriage returns, are messing me up; I can remove them using php's str_replace, but I want to retain them for formatting.
I have a form.On the form I have a drop down box that allows the user to select a data set to work with (A or B). The table loads just fine and all is right with the world. No problems there.What I need is for the user to be able to edit the data set and have those changes written directly back to the mySQL database. They also need the option of deleting a record entirely.I know how to do all the database queries, updates, etc. I just don't know how to write the ajax forms to accomplish this.
I am having no luck with my post form to mysql. It is only posting the first letter of the word/phrase for the text input fields to the mysql database. It is a photo and text post form. The photo and only first letter of text are posting to database. I am using Jqtouch, jquery, and phonegap.
i am using the folowing jquery function to generate a table of contents from the h tags in my web page. I could make some changes but i am not able to extend the function, so that it puts numbers in front of my toc elements like
What I'd like to do is have a dropdown box populated with data from a database. Based on what you select from the drop down a table will be generated (in this case a 3 column table) from another query to the database. I will eventually want a way to select one of the rows from the table, but for now I'd be happy with just generating the table.
I know it will have to deal with DHTML, dom documents, getElementID, removeNode, recreating the node. What I am not sure about is how to
1) Dynamically create a table 2) Step 1 with data from a database (recordset)
Like I said, I'd also like to be able to select a row from the table. I'd be happy with making the ros a radio group, though it would be interesting to be able to select the row. I take it I'd use CSS to highlight the row selected then.
This way we can both input our transactions as we spend money and know at all times how much money is in the account. What do I need to study to be able to program this?
I am trying to generate an ajax form based on a database value of max and min years. At present i have the following.
What I am struggling with is the logic to say if minyears is more than 1 (string in option needs to say years), then add in every year between min and max as additional options. My brain has been melting with this for a few days now
Below i have attached my code. This code is working.....but i want some modification in that code such that when i select 'vegetable' or 'fruits', it should give list of that selected one in second list, BUT THAT list should be stored in mysql database.
In the below program , i have hard-coded that second list, but i want second list to be dynamic from database.
if I use the page without ajax it works, if I use the script jquery it works but doesn't insert the dates in the field, it send only white field. can't pass the variable POST beetween the ajax script and the php script.
Am looking to find the easiest way to populate an order form that customers can email through to us.
I have created a database with 2 fields, id and name.
I would like to be able to have a form on my page with 3 fields, id name and qty.
I want to link the id and name fields on my form to my database so that when a customer starts to type a product id or description it will show a list of available matches. underneath which once clicked will populate the mssing field.
So for example is i have 2 products id 998 green apples and 999 red apples.
Typing in 999 in the id field of the form would populate the name field with red apples and typing red apples in the name field would populate the id field with 99.
if someone didn't know which apples they wanted they could type apples in the name field and underneath it would show both red and green which when clicked will populate both fields.