i am new on this forum and want to help to make it better. i have more than ten years working experience on oracle mssql access mysql. post or send me your question and i will try my best to help you.
Can you handle the this post below: <?php include("../../temp_con/config.php"); // The above include file has established a connection to a database that has sample person and financial data // I need to do the following with the data. Can someone write the example code for the following // 1. Display each person's information (Name, Address, Phone, Email) followed by the financial history ordered by date in ascending order. // 2. Format the phone number as (xxx) xxx-xxxx // 3. Format date as mm/dd/yyyy. // 4. Determine and display the outstanding balance for each person at the end of their financial history. // 5. Lastly, update the "balances" table to the outstanding balance for the person at hand (currently all balances in this table are 0.00). // Database information: // Below are the details concerning the tables // 4 tables "people", "address", "charges" and "balances" // table people columns: peopleID, lastName, firstName, emailAddress, phone // table address columns: id, peopleID, address_line_1, address_line_2, city, state, zip // table charges: id, peopleID, date_created, description, type (5=charge; 10=payment), amount // table balance: id, peopleID, balance ?>
I am not that skilled with database development at this point. Can you code this for me? <?php include("../../temp_con/config.php"); // The above include file has established a connection to a database that has sample person and financial data // I need to do the following with the data. Can someone write the example code for the following // 1. Display each person's information (Name, Address, Phone, Email) followed by the financial history ordered by date in ascending order. // 2. Format the phone number as (xxx) xxx-xxxx // 3. Format date as mm/dd/yyyy. // 4. Determine and display the outstanding balance for each person at the end of their financial history. // 5. Lastly, update the "balances" table to the outstanding balance for the person at hand (currently all balances in this table are 0.00). // Database information: // Below are the details concerning the tables // 4 tables "people", "address", "charges" and "balances" // table people columns: peopleID, lastName, firstName, emailAddress, phone // table address columns: id, peopleID, address_line_1, address_line_2, city, state, zip // table charges: id, peopleID, date_created, description, type (5=charge; 10=payment), amount // table balance: id, peopleID, balance ?>
i want to know the core of RDBMS in with example( if possible ).Also i want to know the disadvantages of RDBMS