gorgon2k

HI guys have a bit of a logic question. I have a client that does event registration on sites A. B. and C. and they would like to start taking payments for the registrations. Now it would be a bit outlandish to create a payment platform on each site so I'm thinking of handling all the payments on an external source say, site D. now, what i'd need to do is create some sort of API that will receive payment data and handle it accordingly (I.E. process, reject, return messages etc.). My biggest concern is A. the security of this (PCI Compliancy) and B. really differentiating between clients (site A. B. and C.) and the possibility to vastly expand in the future. My understanding is that there needs to be some sort of handshake(TLS handshake?) from one server to another. I think most importantly it's getting the information from the servers of site A. B. and C. to the server of site D. securely. On site D. I would use a payment library and framework to manage/handle the payments and return a payment status. Am I understanding this correctly? Am I missing anything? Am I completely off base and risking alot? Thanks guys... P.S. if there's any consultants out there that are very good and have experience in this field, and are from the U.S. feel free to get in touch, I do pay.

Ok guys I was approached by a client to create a web service that will allow users to sort through a bunch of proprietary data. This is all fine and dandy but the catch is, all of this data comes from software they have installed on local servers at their location. I'm thinking of writing a cron job to receive and parse the data at a set interval. The data can be accessed by way of an ODBC protocol but what I need to figure out is how the hell I'm going to get the data from the local server to a remote server. My initial thinking is, is it possible to straight connect to the local server, from PHP using the odbc_connect feature but I guess some how I'd need to have an address for the local server that is public facing? If this isn't an option would the next best thing be something that can parse the data and server it up, online, to be accessed via the remote server? I'm not much of an "I.T." guy so I'm not sure how I'd even go about making this local server accesible from the internet. Does any of this seem possible or do you guys know of any better options? Thanks!

Yes. I have no idea what you mean by this. Sorry I should have clarified. When presented with the front end you have the option to vote on A or B. When you select say B, and you add one to B's rank, would you remove 1 from A's rank? or leave it at 0? I'd image that for this type of system you'd have to have one up one down for every vote.

Yes. But to make the querying easier you can add a votes colum to the images table and increment it everytime it receives a vote. The voting table then keeps a record of which user's voted for the image. To select two random images from your table I would suggest you read: http://jan.kneschke.de/projects/mysql/order-by-rand/ So you say store votes in one table but increment the photo table to prevent the need to join for some queries? Also, do you think it should be +1 -1 or just +1?

I'm working on a project that will use a comparison voting logic to sort the highest rated to the top and lowest to the bottom(Similar to a "hot or not" or "Hotstagram"). Basically what I need to do is take 2 random pictures that are directly next to each other in the database and have users vote, adding one point to the winner and subtracting on point from the loser essentially filtering the highest to the top. My question is two fold, How can I get a random item in a MySql database then get a random item directly next to it. and secondly (if anyone has prior experience with this) how would you structure your DB? I'm thinking One table for images and a second that will hold the votes(then compile the results on page load). I guess what my concern is here, for the ranking, ever new entered photo will start at zero, so you could have X amount of photos with the same rank? I'm just throwing some thoughts out there and I need another mind to toss this around. There's probably a term for this type of ranking, something similar to bubble sorting but I'm not quite sure what you could call it. Also, just thought of this: If you have say the 45th ranked photo vs the 44th ranked photo would you +1 the winner and -1 the loser or just +1 the winner? I'd image that this sort of logic needs to have a negative effect on the loser of the vote to truly filter the results.

Hi guys, I'm at a logical roadblock on how to implement something I'm doing. I'm working with the Instagram API(not important to this question) and in their JSON response they give you 20 results and a link to the next 20 results. I'm trying to build an OOP library that can get the response from the initial API call, search if it has a "next_url" value, and if it does, get the next 20 responses and so un until there's no longer an next URL. I can't quite gather the logic on how to do this... currently here's the code to get the the first 20... function __apiCall($url, $post_parameters = FALSE) { $curl_session = curl_init(); curl_setopt($curl_session, CURLOPT_URL, $url); if($post_parameters !== FALSE) { curl_setopt ($curl_session, CURLOPT_POSTFIELDS, $post_parameters); } // Return the curl results to a variable curl_setopt($curl_session, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curl_session, CURLOPT_SSL_VERIFYPEER, $this->codeigniter_instance->config->item('instagram_ssl_verify')); $contents = curl_exec ($curl_session); curl_close ($curl_session); $return = json_decode($contents); return $return; } and here's a snippet from the JSON response.... stdClass Object ( [pagination] => stdClass Object ( [next_url] => https://api.instagram.com/v1/locations/3937885/media/recent?min_timestamp=&min_id=&max_timestamp=&access_token=xxxxxxxxxxxx49414762bea69258210d8872&max_id=133226850290424667_21341717 [next_max_id] => 133226850290424667_21341717 ) [meta] => stdClass Object ( [code] => 200 ) [data] => Array ( [0] => stdClass Object ( [tags] => Array ( ) [type] => image [location] => stdClass Object ( [latitude] => 39.95022 [name] => Neiman Group [longitude] => -75.168322 [id] => 3937885 ) [comments] => stdClass Object ( [count] => 0 [data] => Array ( ) )

Hi guys, got some questions about the Instagram real-time api. first let me tell you what I want to do. I'd like to run a daemon process with a socket connection or something of the like to the Instagram API to get a constant feed of photos with a certain tag. We estimate it to be a large amount of data at a particular time (thus why we want to go Real-time). This process will parse the feed and store it into a mongodb database. Secondly, for the front end, I'd like to display all new, live photos in real-time, possible with ajax or some form of checking on a set interval. Problem being, I can't find anyone doing this with php. All of the resources I have seen use Node.js and Tornado. Has anyone done this with PHP or know of a good Real-time API demonstration/tutorial to get me started? Here's the documentation... http://instagr.am/developer/realtime/ any help would be greatly appreciated! thanks!

Hey guys I'm really in need of a solution for a client of mine who runs a print shop. I just found out about it and it's a 'hot' job. I need to setup a server/application that will manage ftp files from clients, to clients etc. The absolute musts are that a client can login and upload desired files (potentially over 100mb). They can create client specific locations, so client A doesn't see client B's files. They can also offer clients a link to access files they they want to share. I'm pretty sure dropbox offers this type of service but do you guys know of any others? I can build this with PHP and SQL but I'd imagine this already exists. It doesn't have to be free but it has to be easy. If you guys have any recommends, let me know. Thanks guys!

Ok guys so here's my predicament. I'm working with a designer who has a very unique layout for his ecommerce site. It's kinda like a table/tier based system where you buy a certain amount of points. I need the ability to have user accounts etc and it will all be in joomla. There's many options such as magento, virtuamart etc. but basically what I'm saying is... will it be possible with any particular platform to transform the products so much so that can still use the platform? here's a screen shot... Any suggestions or Ideas? basically It needs to some way integrate into joomla, allow for user profiles etc, and I guess be so customizable that it can be transformed into that look...

Ok so I know this isn't the specialty of many here but I figured you guys are all very knowledgeable. I'm a developer most comfortable with web languages (PHP, Javascript etc.). Now, My company wants to start making Ipad apps for pharma sales reps that basically gives a nice introduction to drugs. We used to sub contract it but we want to bring it in house. It's a very big plus for me financially if I can take on the jobs and do them right. Now doing my research, these apps arent crazy they just kinda need to act like a powerpoint slideshow with a little animation and interaction. I DONT KNOW COCOA. I know there will also be a learning curve with it aswell. so I know sencha slightly. Does anyone here have any experience with either of these platforms and do you think it's a "might as well learn cocoa" type of thing? The only reason I like sencha is becuase you program in Web languages and can port it to app stores. any ideas? suggestions?

I guess logically I was thinking to do it all on one page and have variables that will populate if filters are active and will then go into the loop. It seems easy logically but I'm sure it'll get harder when I try it, haha

OK guys so I have my final project for school due next quarter and Its a database management application. I'm dont the upload edit delete scripting but now I need to do the search feature on the front end. I have a basic understanding of the search abilities in PHP but what i'd love to do is create something like Istockphoto.com and many other inventory sites that allow for a "search" field and also a filter. I'd assume there needs to be global variables that will set and adjust the query as things are checked or filled out. does anyone know of any examples/tutorials/demos that I can browse to start figuring this out? Thanks

awesome thanks!

Ok so I got a hold of some script that I need to make some changes to but seeing it I'm slightly confused. The script below is pulling info from another location and loading it into this page. I'm just trying to figure out what is going on with it. Can anyone explain it? $client = ($_GET["client"] != "") ? $_GET["client"] : "default"; include ($_SERVER["DOCUMENT_ROOT"]. "/includes/work/". $client . ".html")

OK guys, I'm working on a project that involves a SOAP api. I only have reference to the method list here - http://www.ilinc.com/pdf/documentation/ilinc-web-services.pdf . basically, I got it so that I assume it's connecting fine but no matter what I do I can't get a response. I'm assuming I'm having an Issue traversing the response XML but I don't even know how to test that. here's my code... $wsdl_url = 'http://webservice.ilinc.com/perl/ilinc/api/webservice/ilinc-api.pl?WSDL'; $client = new SOAPClient($wsdl_url); $options = array('APIVersion'=>'10.0','ClientID'=>'132449','AuthorizedUserName'=>'lwilliams@biosoteria.com','AuthorizedPassword'=>'*******'); $var = array('UserID'=>'lwilliams@biosoteria.com'); $testUser = $client->GetUserID($options,array('parameters'=>$var)); print $testUser; print $testUser->return->ErrorStr; print $testUser->return->ErrorID; Now in the above code, if I do print $testUser i get this response "Catchable fatal error: Object of class stdClass could not be converted to string in /home/content/12/5907812/html/SOAP_test2.php on line 7". the other two prints return nothing. here's a snippet of the example resonse for the GetUserID method <?xml version="1.0" ?> <iLinc:Response version="10.0" xmlns:iLinc="http://www.ilinc.com"> <iLinc:GetUserIDResponse Reference="reference"> <ErrorID>error-id</ErrorID> <ErrorStr>error-str</ErrorStr> <UserID>user-id</UserID> <EncryptedUserID>encrypted-user-id</EncryptedUserID> </iLinc:GetUserIDResponse> </iLinc:Response> Can anyone tell me what I'm doing wrong?

dan, thanks for the help. It seems that you have two seperate tables in your query.. all this info is contained in one... it's structured like Name Ticket Id Bob D 98678 Bob D 43256 Bob D 534534 Jim B 098098 Jim B 654675465 Mike T 5345gfd So basically i'd need to get an output like Bob D 3 Jim B 2 Mike T 1

OK here's what i need to do. I have a table of tickets for a tech company. they want a report that shows how many ticket each tech has in order of most to least. so say there's 12 tech. the query(s) need to be able to take each individual tech, output their amount of tickets and sort them in order of most tickets. how would I go about this. Any idea?

bump, any ideas?

$_SESSION['bar'] = $foo;

Ok so I have this script which will take a propery formated .csv file and upload to my database. here's the part i need to know if it's possible. basically it puts a group of codes into the database but i need a field that will specify which user the code pertains to from another table. The most logical way to reference the user is with an id code; but short of having the user reference an id code to put in the csv file, is there anyway I can make a query that will INSERT INTO and upload the csv? here's my current code... <?php $tmpName = $_FILES['song_codes']['tmp_name']; include('database.php'); if($sc != ""){ mysql_query('LOAD DATA LOCAL INFILE \''.$tmpName.'\' INTO TABLE music_codes FIELDS ENCLOSED BY "\"" TERMINATED BY "," LINES TERMINATED BY "\n" ;') or die('Error loading data file.<br>' . mysql_error());

OK Guys, thanks, with the usual fooling I GOT IT! here's what i did. I set all the variable to check if they exist or not then plugged them into a query which used the variables. <?PHP $bst = $_GET['bst']; $mak = $_GET['mak']; $mod = $_GET['mod']; $year = $_GET['year']; $check1 = null; if($bst ==""){ $check1 = " body_style LIKE '%'"; } else{ $check1 = " body_style = '".$bst."'"; } $check2 = null; if($mak ==""){ $check2 = " make LIKE '%'"; } else{ $check2 = " make = '".$mak."'"; } $check3 = null; if($mod ==""){ $check3 = " model LIKE '%'"; } else{ $check3 = " model = '".$mod."'"; } $check4 = null; if($year ==""){ $check4 = " model_year LIKE '%'"; } else{ $check4 = " model_year = '".$year."'"; } include('database.php'); ?> <?PHP $fullresult = mysql_query("SELECT * FROM automobile_stat WHERE $check1 and $check2 and $check3 and $check3" ); while($fullrow = mysql_fetch_array($fullresult)){

I have all the variable pulled from the forms, I just need a way to query the database to pull the needed info. if I could have a query like this(in basic terms): SELECT * FROM database WHERE make = (if variable has info, use, if not, select all makes) AND model = (if variable has info, use, if not, select all models) AND body_style = = (if variable has info, use, if not, select all body styles)

well i could do that from my script but the thing was, I tested this query SELECT * FROM `automobile_stat` WHERE make = 'Ford' and model = '*' and it doesnt work, I also tried to do * with and without quotes.

well i dont want to make it required, I want to make it so theres 4 drop down menus across the top and each time you click one it regenerates the data.

Ok, for school i'm trying to write a script that will give 4 dynamically generated drop down boxes that will allow you to sort through a vehicle database. Now i'm hung up on the part that will allow me to determine which ones are selected and throw them into a query. I was thinking if I wrote something like <?PHP $mak = $_GET['mak']; $mod = $_GET['mod']; $bst = $_GET['bst']; $year = $_GET['year']; $result = mysql_query("SELECT FROM automobile_stat WHERE body_style = $bst and make = $mak and model = $mod and year = $year" ) but what my issue is, what if one or some of the drop downs aren't selected, is there something I can put in as a default value for the variables that will return everything in that query? Say the user selects a Body style then selects a make, is there a way that all the models and years under those parameters would show using that query?