Best practices - technology for web/php/mysql application

manpreet Best Answer 3 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 operation
Description
Amount
 
";
    echo $row['date'];
    echo "
";
    echo $row['name'];
    echo "
";
    echo $row['value'];
    echo "


 
  
Summary
$sum_list
";
                                            

                                                

                                                                                                        
                                                    
                                                
                                                

                                                    

                                                        
                                                            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.
                        
                    
                    

                    

                    


                    

                    

                        
                        
                    
                    
                    

                                                

                                

                                    
Similar Forum
                                    

                                
                                

                            
                            

                                
                               
                                                                            

                                            

                                                    

                                                        

                                                            

                                                                Q
                                                            
                                                            

                                                                
Which operating system you favour and why? 
                                                                  
                                                            
                                                                
                                                            
                                                        
                                                    

                                                
                                            
                                        
                                                                            

                                            

                                                    

                                                        

                                                            

                                                                Q
                                                            
                                                            

                                                                
What are the most popular tech portals in India?
                                                                  
                                                            
                                                                
                                                            
                                                        
                                                    

                                                
                                            
                                        
                                                                            

                                            

                                                    

                                                        

                                                            

                                                                Q
                                                            
                                                            

                                                                
What are best technologies available today for education / aiding learning?
                                                                  
                                                            
                                                                
                                                            
                                                        
                                                    

                                                
                                            
                                        
                                                                    
                                

                                    View All
                                
                            
                         
                        
                            

                                

                                    

                                        
Explore Other Libraries
                                        

                                    
                                    

                                
                                
                                    



        
            
 Online Exams
            
            
 Question Bank
            
            
Career News
            
            
Feeds
            
            
 Full Forms
                  
 Dictionary
                  
 Interview Question
         

            
 Gigs
        
            
 Quotes
        
            
 Lyrics
        
            
 Videos
        
            
 Courses
        
            
 Blogs
       
            
 Tutorials
         
            
 Forum
        
            
 Educators
        
            
 Corporates
        
            
 Tools
                                      

                                

                                    

                                        

                                            
Related Searches
                                            

                                        
                                        


                            
                                        General Tech                                            Technology & Software                                     
                                
                            
                        
                    

                    

                        
                        
                    
                

                

            

        

            
Important General Tech Links

                            

                    
                        
                            
                            Bugs  & Fixes
                        
                    
                
                            

                    
                        
                            
                            Technology & Software
                        
                    
                
                            

                    
                        
                            
                            Learning Aids/Tools
                        
                    
                
                            

                    
                        
                            
                            QA/Testing
                        
                    
                
                    
    

            

            
            
                
                

                    

                    

                    

                
            
            

        
        

    
    


    

        

            

                
                    ×
                
                

                    
                
            
            

                
Please allow ads on our site
                
Kindly log in to use this feature. We’ll take you to the login page automatically.
                
                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
                                
                            
                        
                    
                    

                        

                            
                        
                    
                
            
        
    




    

        

            


                
            
            

                


                

            
        
    



    



    

  
      


    

    

        

            

                Your experience on this site will be improved by allowing cookies.
                Read Cookie Policy
            

            

                
                    Reject
                
                
                    Allow cookies
                
            
        
    

    

            
    
    
    
    

    
            
        
    


    

    

        

            

                Your experience on this site will be improved by allowing cookies.
                Read Cookie Policy
            

            

                
                    Reject
                
                
                    Allow cookies