php - Approving information prior to storing in database? -


i developing web-based iphone app , possibly pc friendly website version well. goal here to allow users submit form specific input values stored table in database.

mind information being gathered public display , posted onto calendar or list.

however, prevent trolling or spamming, i'd make submissions have approved prior being submitted table.

i have no problem creating table, connecting database, storing input values corresponding table columns. issue how go setting approval system? can add information table via email? there way approve admissions in cpanel?

this make smooth possible, expecting lot of submissions daily quite bit of information.

thank you

you can have 2 approaches this.

approach 1

  • have 2 copies of table (which want save information into). first 1 should named tablename_input. second 1 should tablename_final.

  • any data in '_input' considered raw , needs approval. once approved data moved '_final'. live list/calendar read '_final' data.

approach 2

  • have column named 'isapproved' flag 0/1. if 1 approved, else not. show data approved.

now, how data approved ?

  • you have hard fast rule spam filter tells post valid , approved default
  • after every post, send user email or notification (unique user - post) when answered back, shall mark approved.

optional: can place column called 'approval comments' fill in @ time of approval.

flow chart

tables

  • 'firstsubmitcontent' - table store user submitted information prior approval.
  • 'finalsubmitcontent' - table stores final information

code pages

  • content page --> contains form user fills content
  • contentactionpage --> calls controller --> calls model
  • controller --> calls model based on page action
  • model --> interacts database table

flow chart various steps in process

i not have tools @ disposable write more detailed code or flowchart. hope puts in right direction.


Comments

Post a Comment

Popular posts from this blog

.htaccess - First slash is removed after domain when entering a webpage in the browser -

sometimes when hit address of webpage in browser, removes first slash after domain. examples: www.mywebsite.com/scripts/script_6.php -> trying load www.mywebsite.comscripts/script_6.php www.mywebsite.com/test.php -> trying load www.mywebsite.comtest.php after entering again, loads page. a .htaccess settings must wrong: rewritebase / errordocument 404 http://www.mywebsite.com/oops.php errordocument 401 /notallowed.php rewriteengine on # turn on rewriting engine #gzip <ifmodule mod_deflate.c> addoutputfilterbytype deflate text/text text/html text/plain text/xml text/css application/x- javascript application/javascript </ifmodule> #end gzip rewritecond %{http_host} ^mywebsite\.com rewriterule ^(.*)$ http://www.mywebsite.com$1 [r=permanent,l] directoryindex index6.php rewriterule ^termsofuse/?$ termsofuse.php [nc,l] # handle requests "adpolicy" rewriterule ^privacy-policy/?$ privacy-policy.php [nc,l] # handle requ...
Read more

Automatically create pages in phpfox -

i have array of information of places , wanna use them create multiple pages in phpfox site. first tried manually insert data in phpfox database (in tables of phpfox_pages , phpfox_pages_text ). the page shown in site when opening it's link, site says: the page looking cannot found. do know other tables should manipulate make work? or know plugin phpfox same? thanks, solved ( @purefan guide): "pages" has user if take @ phpfox_user table, you'll found out how fetch new records on that. there 2 ambiguous fields in table ( password & password_salt ). can use script create values fields: <?php function generaterandomstring() { $length = 164; $characters = '-_0123456789abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz'; $randomstring = ''; ($i = 0; $i < $length; $i++) { $randomstring .= $characters[rand(0, strlen($characters) - 1)]; } return $randomstring; } $ssalt = '';...
Read more

c# - Farseer ContactListener is not working -

i'm using farseer in xna project, have trouble contactlistener. created class contactlistener these 2 error messages , don't know how fix problems. the type or namespace name 'contactlistener' not found (are missing using directive or assembly reference?) the type or namespace name 'contactimpulse' not found (are missing using directive or assembly reference?) what wrong contactlistener class? class mycontactlistener: contactlistener { void begincontact(contact contact) { /* handle begin event */ } void endcontact(contact contact) { /* handle end event */ } void presolve(contact contact, ref manifold oldmanifold) { fixture fixturea = contact.fixturea; fixture fixtureb = contact.fixtureb; if (fixtureb.collisioncategories == category.cat10) { contact.enabled = false; } } void postsolve(contact contact, ref contactimpulse impulse) { /* handle post-solve event */ } }...
Read more