Speak now
Please Wait Image Converting Into Text...
Embark on a journey of knowledge! Take the quiz and earn valuable credits.
Challenge yourself and boost your learning! Start the quiz now to earn credits.
Unlock your potential! Begin the quiz, answer questions, and accumulate credits along the way.
General Tech Technology & Software 2 years ago
Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
Turn Your Knowledge into Earnings.
I have a small application hosted on the common hosting service (MySQL, PHP) and what I am doing is entering and fetching data from database and making some tables generating in html where the fetched data are displayed. The example of the code is below.
I am 100% sure that this is really not a good way how to do such application. What really annoys me is, that next to the fetching data using PHP (which i think is OK) I have also to generate the HTML using the PHP (which I think is really not good).
Is there some good, recommended technology how to separate these 2 things? To have some HTML pages and have some data structure which only delivers request to server and delivers fetched data from server to client? Or some other technique?
Thank you for your answer
$mysqli = new mysqli('localhost', 'money_l', 'password', 'money_l'); $query1 = "SELECT date, name, value FROM list WHERE date between '$s_date' and '$e_date' ORDER BY date"; $query2 = "SELECT date, name, value FROM income WHERE date between '$s_date' and '$e_date'"; $query3 = "SELECT date, name, SUM(value) value FROM list WHERE date between '$s_date' and '$e_date'GROUP BY date UNION ALL SELECT date, name, SUM(value) value FROM income WHERE date between '$s_date' and '$e_date' GROUP BY date"; $result = $mysqli->query($query1); while ($row = $result->fetch_array(MYSQL_ASSOC)) { $sum_list = $sum_list + $row['value']; } echo ""; $result = $mysqli->query($query1); echo "List of costs from " . $s_date . " to " . $e_date; echo " Date of operationDescriptionAmount"; while ($row = $result->fetch_array(MYSQL_ASSOC)) { echo ""; echo $row['date']; echo ""; echo $row['name']; echo ""; echo $row['value']; echo ""; } $result = $mysqli->query($query3); while ($row = $result->fetch_array(MYSQL_ASSOC)) { $plot_row1[] = $row['value']; $plot_row2[] = $row['date']; } echo ""; echo "Summary$sum_list"; echo ""; REPLY 0 views 0 likes 0 shares Facebook Twitter Linked In WhatsApp No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores. Hot Topics Most Read Not Answered Q Which operating system you favour and why? General Tech 9 Answers Q What are the most popular tech portals in India? General Tech 7 Answers Q What are best technologies available today for education / aiding learning? General Tech 3 Answers Q What professional training certifications are most marketable? General Tech 9 Answers Q What are the course certificates or skills that engineers should have other than their academics? General Tech 2 Answers Q What is the full form of NABARD ? Banking, Finance & Insurance Q How to refresh app upon shaking the device? Mobile Technologies Q What are the govt exams after BCA? Career Talk Q TYPO3 v8. Override function in Core class General Tech Q Why do people in India give so much importance to Government jobs? Commerce & Accounting Q How can I know Qibla direction? General Tech 0 Answers Q How to viral my instagram post ? Digital Marketing 0 Answers Q Prepare a slogan against imperialism that exist at present in one form or the other form.. plss fast Interview Questions 0 Answers Q Des cribe the main features of neolithic culture Interview Questions 0 Answers Q And Identify the relationship between the suisthe state from the eighth to the eto the eighteenthcentury Interview Questions 0 Answers Explore Other Libraries Blogs Tutorials Question Bank Feeds Careernews Related Searches best practices technology web php mysql application Important General Tech Links Bugs & Fixes Technology & Software Learning Aids/Tools QA/Testing × Give Rating Login Join Our Community Today Ready to take your education and career to the next level? Register today and join our growing community of learners and professionals. Please complete the CAPTCHA. Subscribe Now
No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
General Tech 9 Answers
General Tech 7 Answers
General Tech 3 Answers
General Tech 2 Answers
Ready to take your education and career to the next level? Register today and join our growing community of learners and professionals.