Mobile Technologies Web Technologies Digital Marketing Creative Design Career Talk Medical General Tech Interviews Internet Of Things

Embark on a journey of knowledge! Take the quiz and earn valuable credits.

Take A Quiz

Challenge yourself and boost your learning! Start the quiz now to earn credits.

Take A Quiz

Unlock your potential! Begin the quiz, answer questions, and accumulate credits along the way.

Take A Quiz

Popular Categories

Interview Questions
QuestionBank
Quantitative Aptitude
Engineering
Govt Exams
Digital Marketing
Management
Interviews
All

Best practices - technology for web/php/mysql application

General Tech Technology & Software 2 years ago

0 1 0 0 0 tuteeHUB earn credit +10 pts
5 Star Rating 1 Rating
Previous Next

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.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (1)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago

 

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 "

  ";while($row = $result->fetch_array(MYSQL_ASSOC)){
    echo "";}
$result = $mysqli->query($query3);while($row = $result->fetch_array(MYSQL_ASSOC)){
    $plot_row1[]= $row['value'];
    $plot_row2[]= $row['date'];}

echo "";
echo "";
echo "
Date of operationDescriptionAmount
 

";
    echo $row['date'];
    echo "";
    echo $row['name'];
    echo "";
    echo $row['value'];
    echo "



 
  

Summary$sum_list
";
                                            

                                                

                                                                                                        
                                                    
                                                

                                                


                                                    

                                                        
                                                            0
                                                            views 

                                                            
                                                            

                                                            0
                                                            shares

                                                            


    

        
        
        
        
        
         
        
        
    




                                                        

                                                    

                                                

                                            


                                            

                                        

                                    
                                                                    
                                

                                                                    


                                

                                    
                                    
                                

                                                                                                                                                

                        
                    


                    

                        
                        
                    


                    

                        

                            
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.

                        

                        
                    


                    

                    


                    
                    

                        

                            

                                
                            

                            

                                
                                

                                    


    

                

                        

                                

                    

                    

                        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
                        

                        

                            
Struggling to grow your email list in 2025? Tried these proven hacks yet?

                            

                                Digital Marketing
                                0 Answers
                            

                        

                    

                

                    

            

                            

                    

                        

                            Q
                        

                        

                            
What if losing weight could be as easy as sipping delicious smoothies every day?

                            

                                Health
                                0 Answers
                            

                        

                    

                

                    

            

                            

                    

                        

                            Q
                        

                        

                            
Will Satellite Connectivity in Smartphones Make Mobile Networks Obsolete?

                            

                                Mobile Technologies
                                0 Answers
                            

                        

                    

                

                    

            

                            

                    

                        

                            Q
                        

                        

                            
Will Augmented Reality (AR) and Virtual Reality (VR) Revolutionize Mobile Gaming?

                            

                                Mobile Technologies
                                0 Answers
                            

                        

                    

                

                    

            

                            

                    

                        

                            Q
                        

                        

                            
Can Smartphones Fully Replace Laptops for Work and Productivity?

                            

                                Mobile Technologies
                                0 Answers
                            

                        

                    

                

                    

    


                                


                            

                        

                    

                    

                    

                        

                            

                                
Explore Other Libraries

                                

                            

                            

                        

                        

                            Blogs
                            Tutorials
                            Question Bank
                            Feeds
                            Careernews
                        

                        

                                                            

                                    

                                        
 Tags

                                        

                                    

                                    

                                                                            
                                            best practices
                                        
                                                                            
                                            technology
                                        
                                                                            
                                            web php mysql application
                                        
                                                                    

                            
                        

                    


                    

                        
                        
                    

                

                

            

        

            
Important General Tech Links


                            

                    
                        
                            
                            Bugs  & Fixes
                        
                    
                

                            

                    
                        
                            
                            Technology & Software
                        
                    
                

                            

                    
                        
                            
                            Learning Aids/Tools
                        
                    
                

                            

                    
                        
                            
                            QA/Testing