423
Hello!
I am inserting a record into a MySQL table called ticketdata that has one unique id field - TicketID (int auto increment)
After I insert it, I would like to automaticly insert another record into a different table called updatedata. This table has its own unique id field - UpdateID (int auto increment) but also has a field ParentTicketID to link it to Ticket record.
How can I insert a new Ticket record, and then immediatly insert an Update record, when I do not know the ParentTicketID?
Any help would be appreciated!
JMass
I am inserting a record into a MySQL table called ticketdata that has one unique id field - TicketID (int auto increment)
After I insert it, I would like to automaticly insert another record into a different table called updatedata. This table has its own unique id field - UpdateID (int auto increment) but also has a field ParentTicketID to link it to Ticket record.
How can I insert a new Ticket record, and then immediatly insert an Update record, when I do not know the ParentTicketID?
Any help would be appreciated!
JMass
424
I love CSS, but the big push to CSS LAYOUT kinda bothers me.
The last two static sites I built were table free. A good example of one is McTevia & Associates. It was the right thing to do for these sites, and helped to seperate the look and feel from content. Really I feel like CSS only sites are a kind of poor mans templating system. They help but are not nearly as powerful as a real templating system like Smarty
There has been so much effort to seperate model(content or data) from view(look and feel) via MVC and the like, that something else is often overlooked. The seperation of look and feel from layout (esentialy dividing the View component of MVC into seperate pieces). The HUGE advantage of a templating system like Smarty is the seperation of the View (look and feel from layout), as well as the Model from the View.
Smarty does not have to use tables. You could build Smarty templates only in CSS. This has some advantages, but also some disadvangates.
The bulk of code already coded with tables in Smarty for XOOPS indicates that is is not going total CSS any time soon. Nor should it. There is very little to be gained from doing so right now.
That being said, if you are designing a new module you could make all of you templates in CSS only(table free). There is nothing stoping you.
JMass
The last two static sites I built were table free. A good example of one is McTevia & Associates. It was the right thing to do for these sites, and helped to seperate the look and feel from content. Really I feel like CSS only sites are a kind of poor mans templating system. They help but are not nearly as powerful as a real templating system like Smarty
There has been so much effort to seperate model(content or data) from view(look and feel) via MVC and the like, that something else is often overlooked. The seperation of look and feel from layout (esentialy dividing the View component of MVC into seperate pieces). The HUGE advantage of a templating system like Smarty is the seperation of the View (look and feel from layout), as well as the Model from the View.
Smarty does not have to use tables. You could build Smarty templates only in CSS. This has some advantages, but also some disadvangates.
The bulk of code already coded with tables in Smarty for XOOPS indicates that is is not going total CSS any time soon. Nor should it. There is very little to be gained from doing so right now.
That being said, if you are designing a new module you could make all of you templates in CSS only(table free). There is nothing stoping you.
JMass
425
WooooooooHoooooooo!
Thanks again everyone!
The MySQL debug was just the trick. I had an error in my table creation. It works now.
Thanks again!!!!
JMass
Thanks again everyone!
The MySQL debug was just the trick. I had an error in my table creation. It works now.
Thanks again!!!!
JMass
426
Again thanks for the posts.
I do have global $xoopsDB; ( I know what you mean about forgetting the obvious)
I found the MySQL debug... I am trying ti out now.
Thanks,
JMass
I do have global $xoopsDB; ( I know what you mean about forgetting the obvious)
I found the MySQL debug... I am trying ti out now.
Thanks,
JMass
427
No Luck! Arghhhh!
This is my code:
$TicketID = '4';
$UID = $xoopsUser->getVar("uid");
$EntryDate = $_POST['entrydate'];
$ClientID = $_POST['clientid'];
$CategoryID = $_POST['categoryid'];
$PriorityID = $_POST['priorityid'];
$TicketSubject = $_POST['ticketsubject'];
$TicketDetails = $_POST['ticketdetails'];
echo $TicketID;
echo $UID;
echo $EntryDate;
echo $ClientID;
echo $CategoryID;
echo $PriorityID;
echo $TicketSubject;
echo $TicketDetails;
// SQL Assuming you took your _POST vars and assigned
$sql = "INSERT INTO ".$xoopsDB->prefix('obsclient_hd_ticketdata');
$sql .= " ( TicketID, UID, EntryDate, ClientID, CategoryID, PriorityID, TicketSubject, TicketDetails ) VALUES ";
$sql .= " ( '$TicketID', '$UID', '$EntryDate', '$ClientID', '$CategoryID', '$PriorityID', '$TicketSubject', '$TicketDetails' )";
echo $sql;
// run sql
if ( ! $xoopsDB->query($sql) )
{
echo( $xoopsDB->error." : ".$xoopsDB->errno );
}
All of the echo statement produce good results including to $sql - but still no insertion
the if statement produes a :
this indicates that the $xoopsDB->error and $xoopsDB->errno do not work either... Mabey I am missing a vital include?
JMass
This is my code:
$TicketID = '4';
$UID = $xoopsUser->getVar("uid");
$EntryDate = $_POST['entrydate'];
$ClientID = $_POST['clientid'];
$CategoryID = $_POST['categoryid'];
$PriorityID = $_POST['priorityid'];
$TicketSubject = $_POST['ticketsubject'];
$TicketDetails = $_POST['ticketdetails'];
echo $TicketID;
echo $UID;
echo $EntryDate;
echo $ClientID;
echo $CategoryID;
echo $PriorityID;
echo $TicketSubject;
echo $TicketDetails;
// SQL Assuming you took your _POST vars and assigned
$sql = "INSERT INTO ".$xoopsDB->prefix('obsclient_hd_ticketdata');
$sql .= " ( TicketID, UID, EntryDate, ClientID, CategoryID, PriorityID, TicketSubject, TicketDetails ) VALUES ";
$sql .= " ( '$TicketID', '$UID', '$EntryDate', '$ClientID', '$CategoryID', '$PriorityID', '$TicketSubject', '$TicketDetails' )";
echo $sql;
// run sql
if ( ! $xoopsDB->query($sql) )
{
echo( $xoopsDB->error." : ".$xoopsDB->errno );
}
All of the echo statement produce good results including to $sql - but still no insertion
the if statement produes a :
this indicates that the $xoopsDB->error and $xoopsDB->errno do not work either... Mabey I am missing a vital include?
JMass
428
Thanks for the post!
I had:
// SQL Assuming you took your _POST vars and assigned
// them to $value1, $value2 ect..
$sql = "INSERT INTO ".$xoopsDB->prefix('tablename');
$sql .= " ( field1, field2, field3 ) VALUES ";
$sql .= " ( '$value1', '$value2', '$value3' )";
But did not have this:
// run sql
if ( ! $xoopsDB->query($sql) )
{
echo( $xoopsDB->error." : ".$xoopsDB->errno );
}
I will give it a try and post results.
Thanks for the info. XOOPS has such a great community.
JMass
I had:
// SQL Assuming you took your _POST vars and assigned
// them to $value1, $value2 ect..
$sql = "INSERT INTO ".$xoopsDB->prefix('tablename');
$sql .= " ( field1, field2, field3 ) VALUES ";
$sql .= " ( '$value1', '$value2', '$value3' )";
But did not have this:
// run sql
if ( ! $xoopsDB->query($sql) )
{
echo( $xoopsDB->error." : ".$xoopsDB->errno );
}
I will give it a try and post results.
Thanks for the info. XOOPS has such a great community.
JMass
429
A MySQL Table.
It should be a very simple common thing to do... But I could not find the XOOPS way of doing it.
Thanks for replying.
JMass
It should be a very simple common thing to do... But I could not find the XOOPS way of doing it.
Thanks for replying.
JMass
430
I am having a very tough time inserting data into a table of my module.
I am passing vars from a form via post. I can get the vars and echo them, but can not seem to insert them into my table.
Can anyone show me some sample code that illustrates how to d othis right? I have looked at the class files for news and such, but can't seem to figure this out.
Thanks,
JMass
I am passing vars from a form via post. I can get the vars and echo them, but can not seem to insert them into my table.
Can anyone show me some sample code that illustrates how to d othis right? I have looked at the class files for news and such, but can't seem to figure this out.
Thanks,
JMass
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | May 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|