and determined that it isn't the code. it's the database.. or specifically a problem accessing the database.

it's a very simple code to insert a row into a table in my database.

it worked the first time i used it....
and nevermore.

i dissected the code and made sure EVERY part of it worked (i spent the last two weeks doing that) before i posted here.

is there some kind of quirk with the databases on zymic that restrict SQL database changes to occur from the webpage?

if so i can understand the security issue.

but the database loads so SLOW. it's much easier to update it from a webpage. i have the form set up and everything.

any help help on this situation would be appreciated. No code included.. becuz all the code works

Please post your code. I am sure we can assist you in connecting.

i don't think the code is the problem.

the code

relevant info:
I used it yesterday and it worked fine on my website. But only once. every other attempt to use this code has failed.

other pages on my site are suffering from the same problem. they all use the same connection to connect.

never one time have i used a close connection command. thats the only thing i can think of that may cause the problem.

the segment of code has been looked at by another zymic member earlier last week.

Where are the actual connection lines?

You're still using some messy syntax as well - interpolated variables take longer, also it doesn't like the [,] characters I find without {} around the variable. Then, your keys are actually constants. Have you defined these constants? I doubt it. You should be escaping them to be strings.

Can you please put var_dump($_SESSION); before the $ssq line, then run this page and paste the ENTIRE output. Also, can you not use include - it means we don't actually see the whole script. Also, including a txt file is risky - if someone finds out where it is, it'll be served as a text file, giving people your passwords.

Swordz

1) everyone has different coding styles. unless you can point me to a "proper" tutorial. im just going to have to learn as i go. And if your going to teach me to do it the right way.. please explain the terminology

granted some of it might be a little off. but i am working on a pretty big project by myself.

2) Because as i've been saying since the beginning of this post ALL my other connections work FINE.
And i did them the same exact way as this one.. actually i left some of the stuff you told me OUT and they still work completely fine. and have been for almost 4 months now. If the syntax was the cause.. wouldn't it be safe to assume that it would have manifested months ago when i first used it?

3)i chose to work from big to small. the website is not open to the public or even close to beta testing YET becuz i can't even insert into a database.
I stripped and escaped all my data, i tinkered and tested on my own for weeks before i even posted here. Me having to wait on replies slows down my work. i would rather work it out myself.. it's just that through trial and elimination i've realized it could possibly be the settings zymic has set up for php my admin.. which is what i asked and no one answered about. all i was told is to "post code"

I just had a simple question. Sure the code needs to be touched up. But my issue here is why isn't the database accepting a query that worked 2 minutes beforehand?
it only happens when i try to UPDATE or INSERT. aka.. change info in the database or add to DB from the webpage.



4)and i know about the text file. i'm going to change all that and fix all security issues before i get ready to beta test. And by the same token, that's why my connection information is IN a include file....security.

having said all that i will post the dump info u requested


oh and thanks for noticing the constants. i was in such a rush to get the code working that i didn't notice!