Tagged Questions

2
votes
0answers
166 views

Send Base64 image from Android with JSON to php webservice, decode, save to SQL

Like the description says, I am taking a photo in Android. It is compressed and added to a byte[] then base64encoded. It sends with JSON to my webservice where it is "supposed" to be decoded and saved ...
2
votes
0answers
192 views

How to integrate sqlite extensions in XAMPP?

There's an extension on the http://www.sqlite.org/contrib?orderby=date, extension-functions.c, which integrates the SQRT command in sqlite. How can I integrate this and use it in my Windows-XAMPP ...
2
votes
0answers
128 views

Unable to perform mySQL query using Paypal PDT data

So here is the issue, I am trying to do a PDT and grab the basic info and post to sql, more importantly a custom variable aswell. Its an integer, called "lvel" also "apv" into users under "user_level" ...
2
votes
0answers
121 views

Calling SQL procedure from Zend PHP gives @@@@@ as result

I have recently loaded Zend Server on my iSeries and am trying to run an SQL stored procedure. When I run a regular SQL query everything works. When I change the query to the SQL stored procedure ...
2
votes
0answers
403 views

SQL Query optimization in Prestashop solution

I'm working on the layered navigation module with Prestashop solution, I'm trying to optimize a Sql query which create a tmp table to execute it and by this way create a bottleneck in mysql. This is ...
2
votes
0answers
184 views

Customize Infobox Map Sql php

I would appreciate a hand hecharais I am trying to create a map connected with php and sql. My intention is to customize the "infobox" but I can not find the solution. This is in .js I wish you could ...
2
votes
0answers
102 views

application/octet contains an image file from android phone to php, how to convert it into a blob?

My app sends a jpeg to php service which recieves the file as application/octet. Does anyone know what I can do with this file and how I can insert it as blob in my sql as an Image file?
2
votes
0answers
293 views

Can't read CLOB into string… sometimes

I have an array of CLOB datatypes. In my sample data, there are two items in the array. The array is embedded in a FOR loop that will loop until all of the data is read from the array (in this case, ...
1
vote
0answers
35 views

multiple update record using checkbox in PHP

any idea about multiple update record using checkbox in PHP? I'm trying to make a multiple choice using multiple update,but i can't reach the main logic to create it. the correct answer will insert to ...
1
vote
0answers
12 views

Zend\Sql\TableGateway|Where|Predicate does not replace the string in the where condition - Is this a bug?

I put together a small application using Zf2 based on the tutorial and where I would like to get data from the database I had to face a strange issue. I have this method in my TableGateway class: ...
1
vote
0answers
29 views

Query through database and pullout user by user id

I have table of cities, birthday, and users. Now, what I am trying to do is to query through database and filter range of ages and city of living (out of a list of cities in the selected region - that ...
1
vote
0answers
15 views

PHP connect SQL server 2008 - How set utf-8 using odbc_connect

I using ODBC to connect sql server 2008 like $virtual_dsn = 'DRIVER={SQL Server};SERVER=MyServerName;DATABASE=myDatabase'; $conn = odbc_connect($virtual_dsn,'sa','mypass') or die('ODBC Error:: ...
1
vote
0answers
33 views

Fixing messed up char encoding in MySQL

There is server 1 and a database 1 where data is stored and queried not having MySQL connection encoding set. Everything works of course until it comes to integration. There is another server and ...
1
vote
0answers
43 views

Executing a stored procedure with a table variable via pdo

I have a stored procedure with two seperate select statements. The results are saved in a table variable. In the end of the SP the table variable is outputted. So, if I execute the SP on the server ...
1
vote
0answers
28 views

SQL Query PHP website from Win7 to MAMP

I've created a PHP login system running on a Macbook using MAMP. When I create a new user account from a networked Win7 machine I can create the account (new account details appear in the database) ...

1 2 3 4 5 … 138
15 30 50 per page