Please help me with my code

[daxmick]

Originally Posted by WraithX

A couple of things to check would be, print out the value of both NumberToTest and Prime (perhaps both the value and the resource id) to see if one or both are having problems. Also, an example on the php website shows an extra check for empty rows before using the result of fetchArray. You can see that here:
http://www.php.net/manual/en/sqlite3...fetcharray.php

Maybe your query is returning empty rows. To that point, maybe there are empty rows in your db? Try to look in your db to see if this may be the case. Or, maybe you should use fetchArray(SQLITE3_ASSOC) to guarantee you can call into the resultant array by string name 'thenumber'.

Also, can your gmp_cmp use the integer 0 as a value? Or should you be comparing against the string '0'? And, maybe the same thing for your gmp_add. Can you use the integer 1 as a value, or should that be the string value '1'?

I haven't programmed too much in PHP, but hopefully this will give you some things to look into to see if you can narrow down where the problem is coming from.

Thanks WraithX! I'll look into this more and see. I'm pretty sure I don't have any empty entries in my database since I set "thenumber" to be UNIQUE and NOT NULL but it is worth double checking.

Also, I was mistaken when I said it selects a resource id randomly. It assigns them incrementally. So it appears that eventually I run out of resource ids. I guess I need to figure out how to reset the resource id allocation back to "#1".

I do like your suggestion on the gmp_cmp! Good catch!

[retina]

So is any of the following wrong?

• GMP produces resources for PHP to reference.
• The numbers held in those resources could be any size or value (32-bits, 64-bits, 2000-bits, whatever).
• Resource numbers produced by GMP are just integers (a sequential number used to reference the next resource).
• Once you have called GMP 2^31 times (for anything) the resource reference number is also going to be 2^31
• PHP reads in the resource number and blows-up when it reads 2^31 because of some 32-bit limitation wrapping around.

Assuming all of the above if correct then There are two ways to fix it:

1. Run 64-bit PHP.
2. Occasionally restart GMP so that the resource numbering is reset back to 0.

[retina]

Originally Posted by retina

• PHP reads in the resource number and blows-up when it reads 2^31 because of some 32-bit limitation wrapping around.

Hmm, a bad assumption on my part because it could also be a problem in GMP producing an invalid resource number when it reaches 2^31. Anyhow, whatever the reason for it the second solution would solve it: restart GMP after 2giga-calls to reset the numbering back to zero.

[LaurV]

For the OP: (original poster)

I have the perfect link that will solve your problem.
(I am with chalsall here, he might be rude, but he is right - you are very fast in pointing bugs in tools people use for ages, and you have no idea what you are talking about, I am not talking about 'collecting all primes' stuff - I let RDS to deal with it , but about messing types, having no understandings how gmp nor php works, etc - we all have better things to do than teaching manners, additionally, we are missing some manners ourselves, so we can't teach things we don't know...).

[daxmick]

Originally Posted by LaurV

For the OP: (original poster)

I have the perfect link that will solve your problem.
(I am with chalsall here, he might be rude, but he is right - you are very fast in pointing bugs in tools people use for ages, and you have no idea what you are talking about, I am not talking about 'collecting all primes' stuff - I let RDS to deal with it , but about messing types, having no understandings how gmp nor php works, etc - we all have better things to do than teaching manners, additionally, we are missing some manners ourselves, so we can't teach things we don't know...).

Interesting. First, this isn't a homework lesson as I've been out of school for a few decades now. :-)

My apologies to all. I thought this was a forum to ask for help with, what I think, is an interesting issue. I find it odd how GMP resource allocation is doing what it is in this particular program as it doesn't behave this way in other programs and thought you all might find it of interest too. (Or find an obvious issue with my code.)

So, with that, I wish to thank those who tried to help. I really have tried to figure out what is the problem with what should be a rather easy program and some of you have at least tried to assist productively. For others, well, I'm sorry my quest for a solution has rubbed you the wrong way so terribly. Good bye.