accra

I have a gps sending data to mysql db, but am having hard time ploting the values on google map. My javascript skills are not very good, pls help... javascript code <?php $server = "localhost"; $username = "root"; $database = ""; $password = ""; $conn = mysql_connect($server,$username,$password); mysql_select_db($database) or die("Unable …

Hi, am interfacing gps tracker TK106 with our online platform. The data we get from gps device is in this format (06667778889-9BP05000066677788899140815A0533.8206N00009.7045W000.0165936157.6200000000-L0000F51C) Instractions form [this site](http://sourceforge.net/p/opengts/patches/1/) explains the variours data sets in the string above, for example the first 11 digits 06667778889 is the device's programmable ID ,used in placed …

Hi, i found this code [online](http://www.macrostash.com/2011/09/17/demo-use-a-php-mysql-database-to-load-markers-on-a-google-map/#comment-2675). After installing and running code on my website, the screen shows nothing back, though code is firmly in place. <script type='text/javascript' src='jquery-1.6.2.min.js'></script> <script type='text/javascript' src='jquery-ui-1.8.14.custom.min.js'></script> <style> BODY {font-family : Verdana,Arial,Helvetica,sans-serif; color: #000000; font-size : 13px ; } #map_canvas { width:100%; height: 100%; z-index: 0; …

Is there any software out there with GUI that i can use to install mysql and phpmyadmin on my vps account? Am new to vps,thx...

Is there another function for creating php sockets apart from this socket_create(AF_INET, SOCK_STREAM, SOL_TCP); ? Really need to know, thanks.

Hey guys, i found this piece of code that is suppose to read a port on my server and write to a .txt file the gps data it get gets. am receiving nothing, am not not sure what the problem is, also am new to gps and php socket programming... …

Hi every one. i have built an online fleet management app in php/mysqli successfully. I now have to add a gps device to send lon,lat, speed and so on to online app. I did some reading on php tcp socket listener, but am not very clear. Do any one have …

Hello, i want to allow my users to reset their passwords if they forget it. My problem is that i lose the code sent to user via email, if this is the link sent to user via email http://localhost/citi/forgot.php?code=8b15388bc5ca7e2821ab6ce59b465f684942dd7901f4e31439575ab72028f84f , when the user get to forgot.php and type in the …

Diafol, anybody pls help. i have this javascript code <script> FB.init({ appId : '00000000000000', frictionlessRequests: true, }); function sendRequestToRecipients() { var user_ids = document.getElementsByName("user_ids")[0].value; FB.ui({method: 'apprequests', message: 'Great App', to: user_ids, }, requestCallback); } function sendRequestViaMultiFriendSelector() { FB.ui({method: 'apprequests', message: 'My Great Request' }, requestCallback); } function requestCallback(response) { console.log(response); …

i just dowloaded a fiverr clone from http://phpvalley.com/phpvalley-micro-jobs-site-script/ but am unable to install it on my localhost.am told to change 644 to 777, but i dont know where or how. I rigth click on connect.php and tryed changing its propaties, but it too did'nt work...

I'm retriving a youtube link from mysql db with this code <?php //echo $embed; $yt_url=$embed; function get_youtube_id_from_url($url) { if (stristr($url,'youtu.be/')) { preg_match('/(https|http):\/\/(.*?)\/([a-zA-Z0-9_]{11})/i', $url, $final_ID);return $final_ID[3]; } else { preg_match('/(https|http):\/\/(.*?)\/(embed\/|watch\?v=|(.*?)&v=|v\/|e\/|.+\/|watch.*v=|)([a-zA-Z0-9_]{11})/i', $url, $IDD); return $IDD[5]; } } $variable= get_youtube_id_from_url($yt_url); ?> and extracting the id part of the link and placing it in …

i have this ajax script <script type="text/javascript"> var url = "GetAutoData.php?svreg="; // The server-side script function handleHttpResponse() { if (http.readyState == 4) { if(http.status==200) { var results=http.responseText; document.getElementById('divAutoInfo').innerHTML = results; } } } function requestAutoInfo() { var svreg = document.getElementById("getautomobile").value; http.open("GET", url + escape(svreg), true); http.onreadystatechange = handleHttpResponse; http.send(null); } …

am trying to export data from mysql db to excel format, but the excel file i get is damaged. i get two varibles by $_GET, and run a search, and then creates the excel file based on the results... `$p_na = $_GET['p_na']; $svreg = $_GET['svreg']; include_once("classes/PHPExcel.php"); $result = mysql_query("SELECT * …

$query="SELECT * FROM history WHERE p_na LIKE '$p_na%' AND svreg LIKE '$svreg%' IN (SELECT * FROM history WHERE cdate BETWEEN '2013-09-12' AND '2013-12-12')"; $sql=mysql_query("$query"); am searching for data LIKE a and LIKE b that falls between to dates. I thought a sub query will be the best method, but its …

Hi all, I have this ajax script that accepts only one value at a time. I want to send more than one value to mysql for processing... but am not so good with javascript, pls point me in the right way....thanks // auto select vehicle # and fleet # <script> …

Am creating a registration form for my app. Am bit confused an to if i should use Phpmailer or Swiftmailer to send activation link to user email. What about the delivery time of emails? Also are there any examples of the two...

Am using ajax to populate a drop down list, and it works fine, but i just can't find a way to make choosen.proto to work. It works on other drop-down, but not the one populated with ajax. In short, the form must allow the user to select multiple items Here …

Hi all, am trying to add an html form to a lightbox with no success. Here is my code: <a href="service_form.php" rel="lightbox"> <input name='input' type='' class='btn-primary' value='Add a Service Tag' rel='lightbox'> </a> Note: I have been able to add an image with the same code and it works fine,so the …

Hi all, i manage to write this query to select data from 2 different tables, here is it $query ="SELECT * FROM illness,symptoms WHERE symptoms.sympId = illness.illId"; am trying to echo the result of the query, here is my script if($med == !'') { $query ="SELECT * FROM symptoms,illness WHERE …

This is the error i get form my error_log on my server online PHP Warning: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in /home1/zxx/public_html/admin/userindex/sms/sms.php on line 127 i looked in all of the code but can't find why that error. Here is the code, it's an sms app writing in php. …

hi, i get this error when i run my script [CODE]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\xampp\htdocs\autogh\admin\userindex\scripts\banner.php on line 13[/CODE] this is my mysql statement [CODE]$banners_num = "select * FROM banners WHERE DATE_ADD(todate, INTERVAL numDay DAY) > NOW() AND position='top_banner'"; [/CODE] Am trying to …

How can I show data from table which have for example certain place, I need to make like dropdown menu with places and when I choice one I need statistic from that one, I have already made base here is page [url]www.anketa.comli.com[/url] At the end of page is dropdown that …

Am trying to validate these variables with an if statement,but it not working,any help will do. [CODE] if($navtype == "xxxx") { $com_name = $_POST['com_name']; $loc = $_POST['loc']; $name_mech = $_POST['name_mech']; $vtype = $_POST['vtype']; $s_veration = $_POST['s_veration']; $remnder_ver = $_POST['remnder_ver']; $vreg = $_POST['vreg']; $last_startdate = $_POST['dy']."-".$_POST['dm']."-".$_POST['dd']; $mileage = $_POST['mileage']; $current_mileage = …

[CODE]<?php // connect to the database include('connect-db.php'); // check if the form has been submitted. If it has, start to process the form and save it to the database if (isset($_POST['submit'])) { // get form data, making sure it is valid $employeeno = mysql_real_escape_string(htmlspecialchars($_POST['txtempno'])); $employeename = mysql_real_escape_string(htmlspecialchars($_POST['txtempname'])); $position = mysql_real_escape_string(htmlspecialchars($_POST['txtpos'])); …

Hi everyone forgive me I am a little new to php but I can get by.... I am trying to implement a pagination script into my sub cat page in a shop however I ahve most of it done but cannot seem to get the pageination to show can someone …

I have time [CODE]timestamp[/CODE] in my db,when i insert/update records it do not change. for Attributes i have [CODE]ON UPDATE CURRENT_TIMESTAMP[/CODE] and for Default its [CODE]CURRENT_TIMESTAMP[/CODE]. any help pls.

[ICODE] Why would an update script do an insert, and not update?[/ICODE] [CODE] $navtype = $_GET['nav']; if($navtype == "zjxpmovdtzjd") { $mileage_out = $_POST['mileage_out']; $mileage_in = $_POST['mileage_in']; $famount = $_POST['famount']; $vreg = $_POST['vreg']; $driver = $_POST['driver']; $vtype = $_POST['vtype']; $desti = $_POST['desti']; $date_out = $_POST['dy']."-".$_POST['dm']."-".$_POST['dd']; $date_in = $_POST['ay']."-".$_POST['am']."-".$_POST['ad']; $cur_date = date("d-m-y …

Am having a hard time printing all record percent in my db my sql statement [CODE]$query="SELECT *, duedate,(TO_DAYS(duedate) - TO_DAYS(CurDate())) as difference FROM vehicle_info ORDER by svreg"; //$query="SELECT * FROM vehicle_info WHERE id='$id' ORDER by vreg"; $pager = new PS_Pagination($conn,$query,10,10); $accra = $pager->paginate(); while($row = mysql_fetch_assoc($accra)) { $id = $row['id']; …

[ICODE]Is there a way to expand and collapse included PHP content? Any code examples pls. [/ICODE]

I have my hidden id [code]<input type="hidden" name="id" value="<?php echo "$id" ?>" />[/code] in my form I have my [code]$id = $_REQUEST['id'];[/code] to get the id from the url And on the update script i have [code]$navtype = $_GET['nav'];[/code] And i have [code]WHERE id=$id[/code], but it keep updating just one …