Posts by MagisterMundus • 465 points
18 posts
-
0
votes1
answer155
viewsQ: Query that selects last line of each device?
I have 3 tables in my DB: CREATE TABLE IF NOT EXISTS `local` ( `codigo` int(11) NOT NULL AUTO_INCREMENT, `IMEI` varchar(15) NOT NULL, `latitude` decimal(10,6) NOT NULL, `longitude` decimal(10,6) NOT…
-
1
votes1
answer158
viewsQ: How to record what is received on an Apache port directly in mysql?
Hello. I have a server Apache (XAMPP) and need to receive messages from a device that sends messages to a specific IP and port. I would like to configure the Apache to listen to a door (443, for…
-
-1
votes1
answer320
viewsQ: How to load or download points on Google Maps when clicking a div?
I have a page that shows the paths a vehicle has traveled. Routes will be shown in an ordered list arranged horizontally in the style of the Timestack Timeline (http://isaaccambron.com/timestack/),…
-
2
votes1
answer1183
viewsQ: How to compare the value of numbers saved as VARCHAR in mysql?
I have a table called coordenadas_cache, with 6 fields: codigo (int, auto increment), latitude_sul (VARCHAR(10)), latitude_norte (VARCHAR(10)), longitude_oeste (VARCHAR(11)), longitude_leste…
-
2
votes1
answer1026
viewsA: How to exchange a charset from a table to utf8 in a latin1 database?
Well, I managed to solve it. How I use mysqli_connect() to connect to the BD, I happened to discover that it has a command that arrow the charset (for sending, I suppose) of the insertion query. The…
-
1
votes1
answer1026
viewsQ: How to exchange a charset from a table to utf8 in a latin1 database?
I am trying to change the charset of a table to utf8 in a BD that contains all other tables like latin1swedish. I ran several commands and says it changed, it shows that that table is the only one…
-
3
votes3
answers60168
viewsQ: Horizontal line in the middle of an unordered HTML list
I have an unordered list that has some list items and would like to place a horizontal line (horizontal Rule < hr >) on it, right in the middle, with height of 2px. I tried to put…
-
6
votes3
answers4703
viewsQ: How do a select pick up 8 lines in a row or more where there are common values?
I have a table coordenada that has the columns codigo, latitude, longitude, data and would like to give a select which selected only if it had 8 lines in a row or more where latitude and longitude…
-
2
votes2
answers515
viewsQ: Which jquery plugin allows you to select days and events each day in a horizontal Timeline?
I have events that I keep in the database and I want to create a Timeline that shows the events of the day in order of event and allow the user to move forward or backtrack the day and select the…
-
0
votes1
answer182
viewsQ: How to release socket on the MAC OS X terminal after cancelling php code execution?
I have a PHP executable with the code below: <?php require_once("SocketServer.class.php"); // Include the File $server = new SocketServer("172.17.0.243",20490); // Create a Server binding to the…
-
0
votes4
answers1002
viewsA: How to reset the hour and decrease a day of a DATETIME?
I ended up doing so: //Gerando um datetime $data novo para nao ter que colocar a parte do SQL $data = new DateTime('2014-03-21 23:50:10'); $dia_anterior_hora_zerada = new DateTime();…
-
5
votes4
answers1002
viewsQ: How to reset the hour and decrease a day of a DATETIME?
I have a field DATETIME I take from SQL, format YYYY-mm-dd H-m-s and I need to reset the hour and shorten a day. I’m managing to decrease a day using date_modify($date, '-1 day');, but how to reset…
-
2
votes2
answers1304
viewsQ: How to hold the value of a POST between paging in Codeigniter?
I have an element form with a select and a submit (filter). The data is filtered, the page is reloaded and the data is presented in a table. To see all the data, you pass through more than one page…
-
0
votes1
answer611
viewsQ: Connect external php script to mysql from a codeigniter server?
I have a XAMPP server on an iMac OSX with a portal developed in codeigniter and would like to integrate into the mysql database an external script that is currently running via terminal and is not…
-
2
votes2
answers1435
viewsA: How do I receive messages from a GPS that uses GPRS via PHP?
I found the answer in this Stack Overflow question: How to Listen to a TCP port using PHP? I configured the GPS using the command (no quotes): *IP#senha_padrao#IP_Externo#Porta# I put my internal…
-
3
votes2
answers1435
viewsQ: How do I receive messages from a GPS that uses GPRS via PHP?
I have a Gosafe G91i device, a GPS device that sends your location from time to time to an IP and a port that I can set up. At the moment, are set IP and port of an online server (Orange gps-trace)…
-
3
votes2
answers3089
viewsQ: How to filter results and reload the/view page in Codeigniter?
I have a code in Codeigniter that takes a value of a select dropbox in a view and leads to a second view showing the results in a table. In this second view, I kept the dropbox and the button of…
-
1
votes1
answer497
viewsQ: How to receive a SMS via Codeigniter?
I have a system that uses the framework PHP Codeigniter and I need to receive SMS from a GPS of these car, which will give me the coordinates of the car in the style of Google Maps and then I keep…