RE: [Apc-aa-coders] Re: anonymous form filling

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi all,

I see Honza already answered this, but my answer adds some details so I
am sending it as well.

I hope I already described the lovely feature post2shtml: There is no
way to POST to a .shtml page, you must always use the GET method, which
has several disadvantages. Thus I created a PHP script post2shtml.php3,
the variables are sent to it and stored to database. Than you are
redirected to the .shtml page and PHP scripts called through SSI
includes retrieve againt the variables from the database. 

The table post2shtml is a part of sql_update.php3, just create it.

Jakub

> -----Original Message-----
> From: apc...@li...
> [mailto:apc...@li...] On Behalf Of Mitra
> Sent: Wednesday, February 26, 2003 10:25 PM
> To: apc...@so...
> Cc: ra...@pa...
> Subject: [Apc-aa-coders] Re: anonymous form filling
> 
> 
> Ram - the main problem seems to me that the table this is being sent
> to - post2shtml - doesn't exist.
> 
> I don't understand how this works, or where you set the table for it
> to go to ...... I thought anonymously posted items got added as 
> regular items in some slice or other.
> 
> - Mitra
> 
> 
> At 12:59 AM +0530 27/2/03, Ram Prasad wrote:
> >Mitra
> >
> >I was trying out the anonymous form filling wizard for my
> Taskss Slice.
> >The form got created fine. I clicked on send, without providing any
> >values (a blank form) and got the following dump on the 
> screen: (should
> >it have not just complained about the values not being there ?)
> >
> >Database error: Invalid SQL: INSERT INTO post2shtml (id, vars, time)
> >VALUES ('b24442e11fdfa9dc45c04fca69e844a1',
> >'a:4:{s:4:\"post\";a:25:{s:7:\"err_url\";s:31:\"http://FILL_Y
OUR_PAGE_U
> >RL.sh tml\";s:6:\"ok_url\";s:31:\"http://FILL_YOUR_PAGE_URL.shtml\"
> ;s:8:\"slice_id
> >\";s:32:\"cd5409ecfbeba5303da25590203d7d03\";s:14:\"use_post2
> shtml\";s:1:\"1
> >\";s:10:\"my_item_id\";s:0:\"\";s:45:\"edtv686561646c696e652e
> 2e2e2e2e2e2e2e_
> >FontName\";s:1:\"0\";s:45:\"edtv686561646c696e652e2e2e2e2e2e2
> e2e_FontSize\";
> >s:1:\"0\";s:33:\"v686561646c696e652e2e2e2e2e2e2e2e\";s:0:\"\"
> ;s:37:\"v686561
> >646c696e652e2e2e2e2e2e2e2ehtml\";s:1:\"h\";s:33:\"v6162737472
> 6163742e2e2e2e2
> >e2e2e31\";s:4:\"Mark\";s:45:\"edtv66756c6c5f746578742e2e2e2e2
> e2e2e_FontName\
> >";s:1:\"0\";s:45:\"edtv66756c6c5f746578742e2e2e2e2e2e2e_FontS
> ize\";s:1:\"0\"
> >;s:33:\"v66756c6c5f746578742e2e2e2e2e2e2e\";s:0:\"\";s:37:\"v
> 66756c6c5f74657
> >8742e2e2e2e2e2e2ehtml\";s:1:\"h\";s:33:\"v63617465676f72792e2
> e2e2e2e2e2e2e\"
> >;s:11:\"In_Progress\";s:33:\"v746578742e2e2e2e2e2e2e2e2e2e2e3
> 2\";s:0:\"\";s:
> >33:\"v746578742e2e2e2e2e2e2e2e2e2e2e31\";s:0:\"\";s:33:\"v656
> e645f646174652e
> >2e2e2e2e2e2e31\";s:0:\"\";s:45:\"edtv61627374726163742e2e2e2e
> 2e2e2e32_FontNa
> >me\";s:1:\"0\";s:45:\"edtv61627374726163742e2e2e2e2e2e2e32_Fo
> ntSize\";s:1:\"
> >0\";s:33:\"v61627374726163742e2e2e2e2e2e2e32\";s:0:\"\";s:37:
> \"v616273747261
> >63742e2e2e2e2e2e2e32html\";s:1:\"h\";s:4:\"send\";s:4:\"Send\
> ";s:6:\"result\
> >";a:1:{s:8:\"validate\";a:2:{s:33:\"v686561646c696e652e2e2e2e
> 2e2e2e2e\";s:54
> >:\"
> >Error in Task (it must be filled) 
> >\";s:33:\"v746578742e2e2e2e2e2e2e2e2e2e2e32\";s:63:\"
> >Error in Received Date (it must be filled) 
> >\";}}s:13:\"oldcontent4id\";a:34:{s:16:\"headline........\";a
> :1:{i:0;a:2:{s:
> >5:\"value\";s:0:\"\";s:4:\"flag\";i:1;}}s:16:\"abstract......
> .1\";a:1:{i:0;a
> >:2:{s:5:\"value\";s:4:\"Mark\";s:4:\"flag\";i:0;}}s:16:\"full
_text.......\";
> >a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:1;}}s:16:
> \"category.....
> >...\";a:1:{i:0;a:2:{s:5:\"value\";s:11:\"In_Progress\";s:4:\"
flag\";i:0;}}s:
> >16:\"text...........2\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";
> s:4:\"flag\";i:
> >0;}}s:16:\"text...........1\";a:1:{i:0;a:2:{s:5:\"value\";s:0
> :\"\";s:4:\"fla
> >g\";i:0;}}s:16:\"end_date.......1\";a:1:{i:0;a:2:{s:5:\"value
> \";s:0:\"\";s:4
> >:\"flag\";i:0;}}s:16:\"abstract.......2\";a:1:{i:0;a:2:{s:5:\
> "value\";s:0:\"
> >\";s:4:\"flag\";i:1;}}s:16:\"highlight.......\";a:1:{i:0;a:2:
> {s:5:\"value\";
> >i:0;s:4:\"flag\";i:0;}}s:16:\"link_only.......\";a:1:{i:0;a:2
> :{s:5:\"value\"
> >;s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"hl_href.........\";a:1:{i
> :0;a:2:{s:5:\"v
> >alue\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"created_by......\";
> a:1:{i:0;a:2:{s
> >:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"e_posted_by..
> ...\";a:1:{i:0;
> >a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"source.
.........\";a:1
> >:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"s
ource_href.....
> >\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:
> 16:\"place.....
> >......\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:
> 0;}}s:16:\"expi
> >ry_date.....\";a:1:{i:0;a:2:{s:5:\"value\";i:1219042800;s:4:\
"flag\";i:0;}}s
> >:16:\"publish_date....\";a:1:{i:0;a:2:{s:5:\"value\";i:104628
7486;s:4:\"flag
> >\";i:0;}}s:16:\"lang_code.......\";a:1:{i:0;a:2:{s:5:\"value\
";s:2:\"EN\";s:
> >4:\"flag\";i:0;}}s:16:\"cp_code.........\";a:1:{i:0;a:2:{s:5:
> \"value\";s:9:\
> >"iso8859-1\";s:4:\"flag\";i:0;}}s:16:\"img_src.........\";a:1
> :{i:0;a:2:{s:5:
> >\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"img_width.......
> \";a:1:{i:0;a:2
> >:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"img_height
> ......\";a:1:{i
> >:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"edit
_note.......\";
> >a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:
> \"slice_id.....
> >...\";a:1:{i:0;a:2:{s:5:\"value\";s:1:\"1\";s:4:\"flag\";i:0;
> }}s:16:\"post_d
> >ate.......\";a:1:{i:0;a:2:{s:5:\"value\";i:1046287486;s:4:\"f
> lag\";i:0;}}s:1
> >6:\"status_code.....\";a:1:{i:0;a:2:{s:5:\"value\";s:1:\"1\";
> s:4:\"flag\";i:
> >0;}}s:16:\"edited_by.......\";a:1:{i:0;a:2:{s:5:\"value\";s:0
> :\"\";s:4:\"fla
> >g\";i:0;}}s:16:\"posted_by.......\";a:1:{i:0;a:2:{s:5:\"value
> \";s:0:\"\";s:4
> >:\"flag\";i:0;}}s:16:\"last_edit.......\";a:1:{i:0;a:2:{s:5:\
> "value\";i:1046
> >287486;s:4:\"flag\";i:0;}}s:16:\"display_count...\";a:1:{i:0;
a:2:{s:5:\"valu
> >e\";s:1:\"0\";s:4:\"flag\";i:0;}}s:16:\"disc_count......\";a:
> 1:{i:0;a:2:{s:5
> >:\"value\";s:1:\"0\";s:4:\"flag\";i:0;}}s:16:\"disc_app......
> ..\";a:1:{i:0;a
> >:2:{s:5:\"value\";s:1:\"0\";s:4:\"flag\";i:0;}}s:16:\"flags..
.........\";a:1
> >:{i:0;a:1:{s:5:\"value\";i:32;}}}}s:3:\"get\";a:0:{}s:5:\"fil
> es\";a:0:{}s:6:
> >\"cookie\";a:0:{}}', 1046287486)
> >MySQL Error: 1146 (Table 'aadb.post2shtml' doesn't exist) Please 
> >contact mi...@ea... and report the exact
> error message.
> >Session halted.
> 
> 
> --
> Mitra Technology Consulting -  www.mitra.biz - 
> mi...@mi... 02-6684-8096  or 0414-648-0722 
> 
> Life is a Mystery to be Lived, not a Problem to be Solved
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Scholarships for Techies!
> Can't afford IT training? All 2003 ictp students receive 
> scholarships. Get hands-on training in Microsoft, Cisco, Sun, 
> Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
> 

RE: [Apc-aa-coders] Re: anonymous form filling

ActionApps - easy and automated publishing and sharing for websites

RE: [Apc-aa-coders] Re: anonymous form filling