which is better/faster/efficient?

[c-chan]

---

problem:
create a database table.
view the data from the table you created previously.

Solution A:

create table and view the date in one single page (lets say 'pageA.php')

Solution B;

create a separate page for creating the table and another for viewing then just include the page for creating the table to the viewing page.


pageA.php (for creating the database)
pageB.php(for viewing the data. Includes pageA.php)


which solution is best/faster/efficient?
or will the result be the same?

:> thank you.

[kamahak]

Hi. Some questions lng.

How are you creating the table? Do you let the user create the table or is it pre-made? better/faster/more efficient in terms of what mn imo gipangita? bandwidth consumption? computer resources?

Anyway, in your case. Best would be just make it one page. Unless you're going to add this to a later project. That would require more planning. Pero mrag assignment rmn ni tingai, dba? So yeah, this kind of thing is trivial for now. Mag diprensya ra jd na kung dako na kaayo imo database pero dli pd na masulbad ug lahi-lahi lng ug page. Ang search algorithm nmu ang imo planohon.

[personalmgt]

I don't get it.

pageA.php will create a database using the CREATE clause? or you meant inserting data in a table using the INSERT clause? Because you don't want people to click on links in your page that creates tables and databases.

Depending on the bulk (how many forms/input boxes) and frequency (how many times do you enter these data in a period of time) of your data entry, if its not that much, merge the view and the data entry forms.

If Bulk<Frequency = separate the form/input boxes with the view.
If Frequency<Bulk = merge the form/input boxes with the view.

[c-chan]

better/faster/efficient in terms of processing time? PHP is procedural right? so i was thinking, would it be better/faster/efficient if another page processes the creation of the table.

no forms are involved in either of the 2 pages. i won't let the user create the table. i create the table.

and no, its not an assignment. :>

[personalmgt]

This should give you synthetic results, but you have to do the experiment on your own to figure out which one is faster.

Determine execution time in PHP - PHP code snippet - developer Fusion

[psyd_1]

quick question, why put the creation of table logic in a php file? xensya na basin sayup ako question, but curious lang ko..

[simoncpu]

Solution C

Create the table beforehand, and just let your application display it.

[kamahak]

Solution C

Create the table beforehand, and just let your application display it.

This

If kelangan jd ka mugamit ug PHP to create/insert data into the tables, I would use one page.

[psyd_1]

follow-up question sa akoang previous na question..

sakto ba akong sabot sa question ni ts na magbuhat ug table gamit ang php?
or ang gi mean ni ts is gamit php to insert data/values to that table?

so if magbuhat ug table gamit ang php ang gi mean ni ts --> wala ko ka gets ngano ing-anion?

please enlighten me pud ky basin sayup ako panguta...

[c-chan]

@personalmgt: thnx for the link. I'll try it out.

bale sulod sa php nga page nai sql to create the tables apil na insert2x. one time ra ang creation sa table. but ang insertion is balik2x. bale mura raman siyag temporary table gani.

sorry kung lisud sabtun ang question >.<
thank you for helping :>