KISSQ: PPrice, NShares and PDate not writing to DB

New Member Joined: Feb 09, 2004 Posts: 4

Hello Everyone,

I just downloaded KISSQ and installation was a breeze...great script.
Becasue I am not yet an advanced user of PHP, I may be missing something simple, but the info for pPrice, nShares and pDate are not writng to my portfolio db...and so I am getting zero's all the way across.

Any suggestions, tips etc.?

Thanks,
krissto

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Post a link to your site and let me take a look.

Posted: Mon Feb 09, 2004 3:20 pm

Hi Raven,

http://www.defgllc.com...

Thanks for your help...
krissto

Posted: Mon Feb 09, 2004 3:22 pm

The index for you script is here...http://www.defgllc.com/Stock_Quote/

Posted: Mon Feb 09, 2004 3:25 pm

How have you integrated it into the database? From the comments in the index.php file

Quote:

Also, this system does not allow the assigning of usernames and/or passwords.
It is assumed that you handle that some other way. YOU MUST MAKE AVAILABLE A
SETTING CALLED $username TO THIS APPLICATION, IF YOU WANT THE STOCK SYMBOLS
STORED IN MYSQL. Otherwise, the user will only have retrieval access.
The reason for this is that I have no way of knowing your login system if it
is not something standard like Nuke or Postnuke.

Posted: Mon Feb 09, 2004 3:37 pm

By integrate, do you mean turning off the comments in the index file? like this one...

// for ($i=0;$i<count($symbols);$i++) {
// if ($symbols[$i]==$Symbol) unset($symbols[$i]);
// }
// if (!in_array($Symbol,$symbols)) {

Posted: Mon Feb 09, 2004 3:45 pm

You don't turn comments off and on. If I have commented something out - leave it out.

If you don't have a user database that you integrate with kissq, then it can't save the data anywhere. How would it know who to save it under? That's what that instruction is talking about.

New Member Joined: Jun 10, 2004 Posts: 16

It is writing to the database but i dont think it is getting read correctly

Try this:

Fix for standalone maybe.

I am not much of a coder. but i was trying to implement this standalone version and it wouldnt read the shares or price. I found that it isnt even searching for that when it goes to read the sql so i added

$uArray[] = $row->Symbol.':'.$row->pDate.':'.$row->nShares.':'.$row->pPrice.':'.$row->fees.':'.$row->uniqueid.":~";

after

$symbols[] = $row->Symbol;

Should now look like

elseif ($isStd) {
$dbi = mysql_connect($stdHost, $stdUser, $stdPasswd) or die($err_msg);
mysql_select_db($stdDB, $dbi);
$result = mysql_query($query, $dbi) or die($err_msg);;
if ($result && (mysql_num_rows($result) > 0)) {
while ($row=mysql_fetch_object($result,1)) {
if (empty($row->Symbol)) continue;
$symbols[] = $row->Symbol;
$uArray[] = $row->Symbol.':'.$row->pDate.':'.$row->nShares.':'.$row->pPrice.':'.$row->fees.':'.$row->uniqueid.":~";

}
}
}

or something like that...

Posted: Wed Jul 14, 2004 7:02 am

You are exactly correct! It appears that not too many are using KISSQ as a standalone, membership, application, so this part had never been tested [thoroughly at least]. Thanks so much for the head's up and I will get an update out ASAP.