jquery-number | Easily format numbers for display use | Code Quality library
kandi X-RAY | jquery-number Summary
kandi X-RAY | jquery-number Summary
Easily format numbers for display use. Replace numbers inline in a document, or return a formatted number for other uses.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of jquery-number
jquery-number Key Features
jquery-number Examples and Code Snippets
Community Discussions
Trending Discussions on jquery-number
QUESTION
ANSWER
Answered 2020-Mar-18 at 23:10my way to deal with it:
QUESTION
I have a quote table that people insert basic information, such as name, product type etc. Which is all fine.
The admin can see the quote table and has a button to view the information in a structured manner.
Now what i have been trying to do is add a button called "Accept" and "Deny" which would move the table entry to the Denied or accepted table (same structure as the quote table)
I have looked around on google but only found assistance in making a button to delete entries or add new entries.
Below is the admin quote viewing page code with the view button:
...ANSWER
Answered 2017-Dec-10 at 17:17Have you considered a different approach? If the two tables have the exact same structure, then all you need is a single table and add a column called 'accepted' and use 1 and 0 values to act as true and false.
Then you can search this single table WHERE 'accepted' = 1
for accepted entries, or 0 for denied entries. And to change an entry's status, simply update a single column. Much easier.
Example:
$result = mysqli_query("SELECT * FROM tableName WHERE accepted = 1");
That will get only entries you have marked as accepted.
Change it to WHERE accepted = 0"
to get the denied entries.
And here is how you can allow the admin to change an entry's accepted/denied status easily:
$update = mysqli_query("UPDATE tableName SET accepted = 1 WHERE id = 12345");
By the way, I suggest you use mysqli instead of mysql, heres a good answer why.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install jquery-number
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page