Support Forums - All Posts - XOOPS Web Application System

1

Re: Event Planning

2004/7/29 19:16
Casey
Just popping in
Posts: 14
Since: 2004/7/18

Currently I've got a list of guests that the admin can edit, add, delete, etc. It also includes RSVP status. I had thought about having the guests register themselves but then figured that most people wouldn't go to the trouble. I intend to have it dump out the data in a comma-delimited text file for easy use in generating address labels. When someone RSVPs then an admin would change the status. The idea of doing the whole invite/RSVP thing online is interesting however. I will have to think about whether or not I have time to do that much. I could probably do it so that the user wouldn't have to register (though at a slight cost to security, of course :-/).

2

Re: Event Planning

2004/7/23 19:50
Casey
Just popping in
Posts: 14
Since: 2004/7/18

I'm currently setting up the same XOOPS for the exact same situation and I've written one module (though its pre-release right now). If you can give specifics on what features you'd be like I could almost certainly help out. It helps even more if you divide them up by modules, and talk about how exactly they would work :).

3

Re: Wedding Information with evite.com like features module

2004/7/23 19:48
Casey
Just popping in
Posts: 14
Since: 2004/7/18

I'm currently working on programming some stuff for myself and my girlfriend's wedding. I've got a pre-release version of a guest list done. What other modules do y'all think would be good. I'm getting input from her too. Hopefully I can build a couple modules that will really help all of us out :).

4

Re: XOOPS/SQL Question

2004/7/23 19:46
Casey
Just popping in
Posts: 14
Since: 2004/7/18

Ahh! Thanks everyone for your help. I knew something odd must be happening when nothing I was trying was working. I'll have to remember that for next time :).

-- Casey

5

Re: XOOPS/SQL Question

2004/7/22 20:28
Casey
Just popping in
Posts: 14
Since: 2004/7/18

Sure, I can post as much code as you want. I intend to distribute this module free/open source when its done. At the moment I'm just trying to get something that works before I polish it. Its intended to allow admins to manage a guest list for an event (with RSVPs and such). At the moment inserting into the database with either my old method (above) or the given method (also above) both work with the offending lines commented out.
The table name is xoops_caseyguestlist
xoops_ will later be changed to be the prefix as in the documentation.

Here's the relevant function for (eventually) outputting a table of guests.


function OutputGuestList()

{

    print("<table> n");

    print("<tr><td>Name:</td><td>Street1:</td><td>Street2</td><td>City:</td><td>State:</td><td>Zip</td><td>Edit:</td><td>Delete</td>n");

    $result = $xoopsDB -> query("SELECT * FROM xoops_caseyguestlist LIMIT 0,30");

    while ($row = $xoopsDB->fetchArray($result)) 

    {

        print "ID:".$row{'id'}." Name:".$row{'name'}." ".$row{'zip'}."<br>";

    }



    print("</table>n");

}

If there is any other code that might be relevant let me know and I'll put it up here.

Edit: Up until a couple days ago I used C++/perl so its entirely possible I pulled off some little PHP no-no that I haven't realized.

6

Re: XOOPS/SQL Question

2004/7/22 18:24
Casey
Just popping in
Posts: 14
Since: 2004/7/18

Fatal error: Call to a member function on a non-object in /var/www/localhost/htdocs/modules/caseyguestlist/index.php on line 85

Same thing.

Is there some difference with me using XOOPS 2.0.7 between what y'all are saying and what I should be doing? I have read tons of PHP documentation for the past couple days and it seems that the stuff I've been doing should work - as well as y'alls suggestions, and yet nothing is working out.

7

Re: XOOPS/SQL Question

2004/7/22 16:27
Casey
Just popping in
Posts: 14
Since: 2004/7/18

Chad: That part works fine. I'm using result there just to make sure the operation was successful. Your method uses $eh. Is that error handler? That sounds more convenient. Presumably 0013 returns the MySQL error?

I'll have to try it without the quotes tonight and see how that works out.

8

Re: XOOPS/SQL Question

2004/7/22 12:00
Casey
Just popping in
Posts: 14
Since: 2004/7/18

Ok, its nice to know where the db class documentation is. That said, I've looked through it and what you're suggesting looks right to me, however, I'm still getting the same error.

This leaves me in the position that I can add records to the database using:


$result = $xoopsDB -> query("INSERT INTO `xoops_caseyguestlist` (name, street1, street2, city, state, zip) VALUES ('$name', '$street1', '$street2', '$city', '$state', '$zip')");

but can't get them out with any of the suggested code.

9

Re: XOOPS/SQL Question

2004/7/22 0:32
Casey
Just popping in
Posts: 14
Since: 2004/7/18


Fatal error: Call to a member function on a non-object in /var/www/localhost/htdocs/modules/caseyguestlist/index.php on line 85

That's the error I get returned, where line 85 is:


$result = $xoopsDB -> queryF('SELECT * FROM `thetesttable` LIMIT 0, 30');

If I comment that line out everything (except what deals with $result) works.

-- Casey

10

XOOPS/SQL Question

2004/7/21 21:00
Casey
Just popping in
Posts: 14
Since: 2004/7/18

$result = $xoopsDB -> query('SELECT * FROM `thetesttable` LIMIT 0, 30');

I want to select all data from (what i've named in this case thetesttable. The table exists and can be edited with PHP admin. I am able to add to it using:
$result = $xoopsDB -> query("INSERT INTO etc...")

Even when I attempt to select a single table, it fails. I've read the php and MySQL documentation and as far as I can figure out, this has something to do with the way XOOPS accesses the database?

For the moment I just want this:
$result = $xoopsDB -> query('SELECT * FROM `thetesttable`');
to work. If anyone could help me that would be great.

-- Casey

Stats
Goal:	$100.00
Due Date:	May 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: Event Planning

Re: Event Planning

Re: Wedding Information with evite.com like features module

Re: XOOPS/SQL Question

Re: XOOPS/SQL Question

Re: XOOPS/SQL Question

Re: XOOPS/SQL Question

Re: XOOPS/SQL Question

Re: XOOPS/SQL Question

XOOPS/SQL Question

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}