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 …

I think you need to use some JavaScript to write the location some thing like this [CODE]<head> <script language="JavaScript"> function goPage (newURL) { // This function is called from the pop-up menus to transfer to // a different page. Ignore the value returned is a null string if (newURL != …

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 = …

just add [CODE]<?php } ?> or <?php { ?> [/CODE] to the end (almost the end) of your page, one at a time.this should solve it.

Pls. make it more clear

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 …

[ICODE]I have a script that checks usernames and passwords and it works fine when i put in a username and password ,but when the form is empty and i submit it ,it still login the person. I made some changes to the script,its still not working.Any help. [/ICODE] [CODE]<? session_start(); …

[ICODE]Hi, am wounding where i can find a script that can do something similar to this [url]www.avis.com[/url] Pls look at the right low side. This is just javascript, want something similar, but using php/mysql.[/ICODE]

Hi, Am building a car sale site.I want to automatically take of listings that are more than, say 14 day old. Any php/mysql scripts or an idea as to how to do this?

Am trying to insert in to the same table two values from the same form. if counter equals to 1, do an update , else do an insert. only the insert part is working, it looks like my counter script is not working,any help? [CODE] $counter=0; $sre_log_num = 0; $sre_log_result …

You need to explain further.Or do you want each user to see something different when they log in ? If so use this: [CODE] <? session_start(); ob_start(); $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="ping"; // Database name $tbl_name="signeup"; // Table name // Connect to …

[ICODE]am trying to create a filter,but am geting no result with this,my data type in mysql is date.Any help pls?[/ICODE] [CODE] <?php $date = ""; $driver = ""; $vreg = ""; $desti = ""; $radiotype = $_REQUEST['find']; if ($radiotype == "") { echo"<p class='bodytxt'>N.B: You can filter by selecting any …

it means [CODE]$this[/CODE] less than or equal to [CODE]total_pages[/CODE]

[ICODE]Hi there, Am trying to filter results from my db, when i select a value i get no result and no error.I feel its my sql query, this is my code and form. Or if any one have a simple script that can do the same,i will be grateful, thanks. …

Try this: [CODE]$SQL = ("SELECT * FROM users WHERE Username = '$username' AND Password = '$password'"); echo(SQL);[/CODE] you seems to have too many " and ' Or echo this out [CODE]echo(SQL)[/CODE] copy it the result from your browser, go to phpmyadim ,open sql and past the result in there and …

[ICODE]Can any one help with a simple php code to get time difference this is what i did, don't be mad at my effort, i tryed other ways and failed.[/ICODE] [CODE]$tf_con =time(st$_POST['time_out'] - $_POST['time_in']);[/CODE]

[ICODE]I have two date fields in my db, one is a CURRENT_TIMESTAMP and the other Date. I use a date picker to input the date into the date fields in my form. All other date in the form is input into my db, except the two date fields. But when …

[CODE]<?php $current_date = strtotime('now'); $due_end_date = 60*60*24*7; // Number of seconds for 7 days $sql = "SELECT * FROM sre_log WHERE current_date >== '$due_end_date-$current_date' ORDER by vtype"; $due_end_date = mysql_query($sql); //echo "$current_date"; while($a < $sre_log_num) { $id = mysql_result($sre_log_result,$a,"id"); $vtype = mysql_result($sre_log_result,$a,"vtype"); $due_end_date = mysql_result($sre_log_result,$a,"due_end_date"); $current_date = mysql_result($sre_log_result,$a,"current_date"); } echo …

Hi, am currently using this script to protect/encrpty info in the address bar,but i thnk its not very strong. cn any one help me make/find a more secure one, thanks. [CODE]<a href='articlesdetails.php?pif=ixhsuwu9xyysysjj300&yisu=uuwuwuwzuab&jsn=733888559jdjdjdeyey&tsyi=378hyxbh738hssh272sh&zy9stxyw=w&shy272bs2637shuw727hhshs377ywwwyw&id=$id'>[/CODE]

[CODE] Pls, can any one tell me what is worng with this code? when i run it , this is what i get [There was an error with the database. It has been logged.] any help? Thanks. <?php session_start(); $navtype = $_GET["nav"]; include "config.php"; ?> <?php if($navtype == "mail") { …

Hi to all, am having problem doing this. i want to show a link and not a button.when the link is clicked,then the <form></form> content is echoed for the user to make a choice,this should not open a new window,all this should take place on the same page.another problem i …