WebrequestSolved

Any information related to using the webrequest ?

I am working on documentation to help with this. It requires a remote host, website, SQL and some understanding of coding. I use PHP files to collect the data sent from the server and insert it into MySQL, then a page writen in PHP to show the results. I will have sample coding soon on pastebin to help with a basic page and setup

Merged post

Here are 4 files to get your started on the website side. It's just basic page to show the results. You still need to setup the SQL database, username, password, etc... and put that info in the config file.

https://pastebin.com/u/MACHIN3/1/XzpnqifK

Cool, something to play with. thanks @MACHIN3

Merged post

Do you have a sql file i could use by any chance ?

u9kdXmFTn7ktyWQ.png Deflaxz

Do you have a sql file i could use by any chance ?

Not sure exactly what you mean, If your asking if I have a file that will automatically create the database and table then no I do not. You'll have to create the database and table manually in your host cpanel. Usually done through phpMyAdmin or whatever software they have for viewing and editing SQL. The files I have on pastebin are just for recieving the data from your server and putting it into the database you make then showing the data from that database.

So far i got it slightly working. i'm struggling with the following Kill Data not saved to Database: Unknown column 'Name' in 'field list'

and is this correct in killrecordadd.php ? if ($serverkey == $configsecretkey){ on line 9
should it not been if ($secretKey == $configsecretkey){ ??

anyways thanks i'lll figure it out from here. keep up the good work.

// Update Fixed its working now:
Sql for quick start / i made all varchar 255 probably would change that to suitable needs.
https://pastebin.com/b0jevJJV

bbCIwRyurd4coGY.png Deflaxz

So far i got it slightly working. i'm struggling with the following Kill Data not saved to Database: Unknown column 'Name' in 'field list'

and is this correct in killrecordadd.php ? if ($serverkey == $configsecretkey){ on line 9
should it not been if ($secretKey == $configsecretkey){ ??

anyways thanks i'lll figure it out from here. keep up the good work.

you are correct

 if ($serverkey == $configsecretkey)

should in fact be

if ($secretKey == $configsecretkey)

as for the  Unknown column 'Name' in 'field list', I'm not sure who your using as a host but make sure you create the table colum names exactly how they are shown in the file, Name and not name. Also they must be in the order it's sending them. 

I will hopefully have the next update ready in the next day or so which will include a new feature for SQL support directly. Details will be listed once it's ready for release, I'm testing it thoroughly before i upload it for public use.

Great to read. thank you for your continued support.

Locked automatically