Ajax Autocomplete Php ,mysl

p id="ptselect"
input id="ptselect_c" name="ptselect" type="text" /
/p





scrip
$(function(){
setAutoComplete("ptselect_c", "results", "autocomplete.php?part=");
});


/script

autocomplete.php

include"dbcon.php";



$result = mysql_query("SELECT concat( FirstName,' ', LastName,' ',OfficerNo) as name
FROM `legalofficers` ORDER BY FirstName ASC");
while ($row = mysql_fetch_assoc($result)) {
$colors[]=$row['name'];
}
mysql_free_result($result);


// check the parameter
if(isset($_GET['part']) and $_GET['part'] != '')
{
// initialize the results array
$results1 = array();

// search colors
foreach($colors as $color)
{
// if it starts with 'part' add to results
if( strripos($color, $_GET['part']) === 0 ){
$results1[] = $color;
}
}

// return the array as json with PHP 5.2
echo json_encode($results1);
}

Ajax chained selection Php ,mysl

$(document).ready(function() {
$('#wait_1').hide();
$('#ptselect_v').change(function(){
$('#wait_1').show();
$('#result_1').hide();
$.get("func.php", {
func: "ptselect_v",
drop_var: $('#ptselect_v').val()
}, function(response){
$('#result_1').fadeOut();
setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
});
return false;
});
});

function finishAjax(id, response) {
$('#wait_1').hide();
$('#'+id).html(unescape(response));
$('#'+id).fadeIn();
}


link this javascript files and libraries inside header tag
jquery.js
dimensions.js
autocomplete.js"

func.php

// Page load dropdown results

function getTierOne()
{
/*$result = mysql_query("SELECT DISTINCT `district` FROM `tbldistrict` ORDER BY `tbldistrict`.`district` ASC ")
or die(mysql_error());

while($tier = mysql_fetch_array( $result ))

{
echo ''.$tier['district'].'';
}
*/


echo 'Legal Branch ';
echo 'DI ';
echo 'Secretary ';
echo 'Dg Observation ';

}


// First selection results

if($_GET['func'] == "ptselect_v" && isset($_GET['func'])) {
drop_1($_GET['drop_var']);
}

function drop_1($drop_var)
{
include"dbcon.php";
//$result1 = mysql_query("SELECT district_id FROM tbldistrict WHERE district='$drop_var' ") or die(mysql_error());
//$row=mysql_fetch_array($result1);
//$district_id=$row[0];
$result = mysql_query("SELECT id,name FROM `di_le` where Sec_no=$drop_var ORDER BY `di_le`.`name` ASC;") or die(mysql_error());

echo '


Select an Action';

while($drop_2 = mysql_fetch_array( $result ))
{
echo ''.$drop_2['name'].'';
}

echo ' ';

}

Google Map Mark Location (Html)

inside header tag

src="http://maps.google.com/maps?file=api&v=1&key=AIzaSyAJvxWX5t391UuFWVrLgOFG2lsB972eN00" type="text/javascript"


inside Body tag
onunload="GUnload()"


inside div tag in body
id="map" style="width: 1500px; height: 900px" align="center"

Google Map Mark Location (Javascript)

var map = new GMap(document.getElementById("map"));
map.addControl(new GSmallMapControl());
map.addControl(new GMapTypeControl());

var b=new Array;
var a=new Array;

var j=0;
var arSize=0;

function convertX(){
a= [];

}

function convertY(){
b= [];
}


convertX();
convertY();

arSize=a.length;

//alert(arSize);
//placeX=[6.9270786,6.3422291,5.949305,6.643322,6.033401];
//placeY=[79.861243,80.8267064,80.535347,80.701897,80.218384];


while(j var point = new GPoint(b[j],a[j]);
var address = 'Stollen places';

var mark = createInfoMarker(point, address);
map.addOverlay(mark);
j++;
}

function createInfoMarker(point, address) {
var marker = new GMarker(point);
map.centerAndZoom(point, 5);
GEvent.addListener(marker, "click",
function() {
marker.openInfoWindowHtml(address);
}
);
return marker;
}

// array a= echo implode(',', $x1)
// array b= echo implode(',', $y1)

Google Map Mark Location (PHP)

$name=array('Colombo','Embilipitiya','Matara','Balangoda','Galle','Dehiwala','Nugegoda','Nuwaraeliya');

$x1=array();

$y1=array();

$numberOfAddress=sizeof($name);

location($name);

function location($address){

global $x1;

global $y1;

$name2=$address;

for($i=0;$i

$geocode=file_get_contents('http://maps.google.com/maps/api/geocode/json?address='.$name2[$i].'+Sri+Lanka&sensor=false');

$output= json_decode($geocode);

$latitude = $output->results[0]->geometry->location->lat;

$longitude = $output->results[0]->geometry->location->lng;

$x1[]=$latitude;

$y1[]=$longitude;

}

}

?>

Singleton

require_once 'lib/MySQL.php';

/**

* Singleton

*/

class DB {

public static $conn = null;

/**

*

* @return type MQSQL connection

*/

public static function connect()

{

if (self::$conn == null) {

self::$conn = new MySQL();

}

return self::$conn;

}

}

OOP PHP

http://www.diffen.com/difference/Self_(PHP)_vs_this_(PHP)

Import and export mysql table data with csv file

Importing csv file data into mysql table

LOAD DATA LOCAL INFILE '/importfile.csv'

INTO TABLE test_table

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n'

(field1, filed2, field3);

Exporting mysql table data into csv file

SELECT Name

INTO OUTFILE 'C:/Documents and Settings/Administrator/Desktop/picks/fq.csv'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

ESCAPED BY '\\'

LINES TERMINATED BY '\n'

FROM users;

Zend pdf Genaration

this link may more important

http://devzone.zend.com/1776/creating-pdf-documents-with-zend-framework/

New Project with MySql workbench

Generate database using ER Diagram

step 1

step 2

step 3

step 4

step 5

step 6

step 7

step 8

step 9

step 10

Access wamp www directory and phpmyadmin from another machine

You can access www directory from outside machine after putting online your server(your machine)

Question:

I have installed wamp on machine A. When I am on the local server that I installed it on I can access PHPMyAdmin from http://127.0.0.1/phpmyadmin or http://localhost/phpmyadmin
But I want to be able to access it from my computer and when I type in IP address of the Server I can see the pages I have put in but when I type http://192.168.1.116/phpmyadmin, PHPMyAdmin comes up saying

Forbidden
You don’t have permission to access /mysql/ on this server.

Solution:
Go to C:\wamp\alias. Open the file phpmyadmin.conf and add

Options Indexes FollowSymLinks MultiViews
Allow Override all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
Allow from MACHINE_IP