KISSQ: PPrice, NShares and PDate not writing to DB

krissto · 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

Raven · Posted: Mon Feb 09, 2004 3:00 pm

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

krissto · New Member Joined: Feb 09, 2004 Posts: 4

Hi Raven,

Only registered users can see links on this board!
Get registered or login to the forums!

Thanks for your help...
krissto

krissto · New Member Joined: Feb 09, 2004 Posts: 4

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

Raven · 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.

krissto · New Member Joined: Feb 09, 2004 Posts: 4

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)) {

Raven · 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.

upennballer · 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...

Raven · 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.