which is better/faster/efficient?

[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 :>

[psyd_1]

need jud mag create sa table? mejo expensive baya na.. hehehe.. why not tirahun sa session or somewhere nalang aside sa birahan sa table? hehehe.. bitaw suggestion ra na akoa, nya basin sayup na sad akoa suggestion..

[kamahak]

Makalibog ghapon. Di ko kasabot ngano kelangan jd PHP gamiton pra himo sa table. Or, ganahan lng ka na PHP imo gamiton pra mu populate ug table? di ka ganahan mg SQL?

If mao na stryaa, then no, walay diprensya kung imo ba lahi-on ug file ang imo display ug "sql" page.

[c-chan]

ahmm...sql man akong gamit pag create sa table. thought ako gi butang sulod sa php. O.o

cge ayaw nalang create. insert nalang.

bale isa ka page mag insert, is aka page mag view?
or
isa ka page mag insert ug view?

[kamahak]

daghan kag data e-insert brader? kay ang ako solution jd ana noh is katong gi post previously.

Solution C

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

But, if imo ni gibuhat for learning purposes or if daghan kaayo kag data e-insert and, preha nako, tapulan pa ka mugamit SQL pra insert. Pde rapod nmu gamitan ug PHP. e-usa lng na ka page. No need to make an extra page.

Bale, my first solution would be to.

1. Use SQL to create table
2. Use SQL to insert data
3. Use PHP to display data

otherwise, just use one page for everything with PHP.

[neigyl_noval]

Both suggested solutions are so elementary.

If you choose the first solution:
What if the row data of the table of your database are too many like 1000 or 5000? Displaying all data in one page may take at most 5 minutes to load depending on the speed of your TCP/IP connectivity.

If you choose the second solution:
It only increase overhead and still the same as the first solution when you display the data.

For me, the best solution is to separate the data into pages--say 50 rows per page.

However, if you have only few data to retrieve, the first one would be better. Redirecting to other page may take a few second. However, the result is the same, speed is compromised.

[c-chan]

ok thnx sa opinions ninyu :> na solve na ni sya nga problem ^^ thnx2x!

[chubibok]

c is the best man

[Tin_Tin]

c is the best man

Basa pud sa first post uy!

[moodsey211]

Pwede pahabol. I'll go with Option A