StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POIntegrating legacy Ajax script in CakePHP
primarykey
Id
2588400
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-04-06T21:16:24.240
FavoriteCount
0
LastActivityDate
2010-04-07T04:09:17.193
LastEditDate
LastEditorUserId
0
OwnerUserId
143553
ParentId
0
PostTypeId
1
Score
1
ViewCount
317
LastEditorDisplayName
text
Body
I have a legacy script that I would like to integrate in a cakephp app. The script makes use of $_POST and such and since I'm quite a noob I would need some help for the integration. Here is how the script looks like: THE JAVASCRIPT: <ul> <li>prototype.js</li> <li>builder.js (these two are from the prototype fw)</li> <li>lib.js (makes a ajax requests to remote.php)</li> </ul> THE PHP <ul> <li>remote.php (contains FastJSON class and $_POST vars) <pre><code>if ($_POST['cmd'] == 'SAVETEAM' && $_POST['info']) { $INFO = json_decode(str_replace('\"', '"', $_POST['info'])); $nr = 1; $SORT = array($INFO->GK, $INFO->DEF, $INFO->MID, $INFO->FOR, $INFO->RZ); foreach ($SORT as $STD) foreach ($STD as $v) mysql_query("UPDATE players_teams SET fieldposition = ".$nr++." WHERE player_id = {$v->player_id} AND team_id = {$v->team_id}") or die(mysql_error()); // CAPTAION mysql_query("UPDATE `teams` SET captain = '{$_POST['captain']}' WHERE `user_id` = {$_POST['userid']}") or die(mysql_error()); </code></pre> }</li> <li>transfers.php (containts the form that uses the javascript and link to the JS)</li> </ul> I have really no idea how to structure the files and calls in cakephp. Currently I have "Undefined index: cmd [APP/vendors/remote.php, line 230]" errors since I use $_POST['cmd'] (I placed remote.php in Vendors and included it, the JS was just included old fashion way, as a link and appears in the source code). How can I make this work? I'm sorry but I'm not familiar with AJAX and Cake... If you want a full look at the code, here it is: <a href="http://octavian.be/thecode.zip" rel="nofollow noreferrer">http://octavian.be/thecode.zip</a> Thank you for reading and helping me out.
Tags
<php><javascript><ajax><cakephp>
Title
Integrating legacy Ajax script in CakePHP
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USoctavian
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POIntegrating legacy Ajax script in CakePHP
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COthats some pretty horrific sql statements.
 singulars
 PostPostId
 POIntegrating legacy Ajax script in CakePHP
 UserUserId
 USFunky Dude

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.