Posts by vibhaJ Page 11

vibhaJ 126 Master Poster

14 Years Ago

With form ...

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?
	/* CREATE TABLE `tbl_hindi` (
	  `data` varchar(1000) character set utf8 collate utf8_bin default NULL
	) ENGINE=InnoDB DEFAULT CHARSET=latin1;
	
	INSERT INTO `tbl_hindi` VALUES ('कंप्यूटर'); */
	
	mysql_connect('localhost','root','');
	mysql_select_db('test');	
	
	mysql_query('SET character_set_results=utf8');
	mysql_query('SET names=utf8');
	mysql_query('SET character_set_client=utf8');
	mysql_query('SET character_set_connection=utf8');
	mysql_query('SET character_set_results=utf8');
	mysql_query('SET collation_connection=utf8_general_ci');
	
	if(isset($_POST['save']))
	{
		$sql = "insert into tbl_hindi values ('".$_POST['data']."')";
		mysql_query($sql);
	}
	
	$sql = "select * from tbl_hindi";
	$res = mysql_query($sql);		
		
?>
<form  method="post">
<table width="900%" border="0">
  <tr>
    <td>Add New : <input type="text" name="data" size="20" />
<input type="submit" name="save" value="Save" /></td>
  </tr>
  <tr>
    <td>-----------------------------</td>
  </tr>
  <tr>
    <td><strong>Hindi Data</strong></td>
  </tr>
  <? while($sar = mysql_fetch_assoc($res)) { ?>
  <tr>
    <td><?=$sar['data'];?></td>
  </tr>
  <? } ?>
</table>
</form>
</body>
</html>

Web Development php sql

diafol commented: nice one - like it +13

vibhaJ 126 Master Poster

14 Years Ago

Re: Problems sending email within a loop

Post complete loop code.
There should be something wrong in loop only.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Cmparing mysql tables

Okay dude..
This is with form code.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?
	mysql_connect('localhost','root','');
	mysql_select_db('test');	
	
	mysql_query('SET character_set_results=utf8');
	mysql_query('SET names=utf8');
	mysql_query('SET character_set_client=utf8');
	mysql_query('SET character_set_connection=utf8');
	mysql_query('SET character_set_results=utf8');
	mysql_query('SET collation_connection=utf8_general_ci');
	
	if(isset($_POST['save']))
	{
		$sql = "insert into tbl_hindi values ('".$_POST['data']."')";
		mysql_query($sql);
	}
	
	$sql = "select * from tbl_hindi";
	$res = mysql_query($sql);		
		
?>
<form  method="post">
<table width="900%" border="0">
  <tr>
    <td>Add New : <input type="text" name="data" size="20" />
<input type="submit" name="save" value="Save" /></td>
  </tr>
  <tr>
    <td>-----------------------------</td>
  </tr>
  <tr>
    <td><strong>Hindi Data</strong></td>
  </tr>
  <? while($sar = mysql_fetch_assoc($res)) { ?>
  <tr>
    <td><?=$sar['data'];?></td>
  </tr>
  <? } ?>
</table>
</form>
</body>
</html>

Web Development mysql php

dalip_007 commented: fabulous , awsome , thanks +3

vibhaJ 126 Master Poster

14 Years Ago

Re: Hindi Data in SQL

I have tried with following php code to insert hindi data.
And also using phpmyadmin tab.

<?
	mysql_connect('localhost','root','');
	mysql_select_db('test');
	
	mysql_query('SET character_set_results=utf8');
	mysql_query('SET names=utf8');
	mysql_query('SET character_set_client=utf8');
	mysql_query('SET character_set_connection=utf8');
	mysql_query('SET character_set_results=utf8');
	mysql_query('SET collation_connection=utf8_general_ci');
	
	$sql = "insert into tbl_hindi values ('कंप्यूटर कंप्यूटर ')";
	mysql_query($sql);
	
	$sql = "select * from tbl_hindi";
	$res = mysql_query($sql);
	while($sar = mysql_fetch_assoc($res))
	{		
		print_r($sar);
	}
?>

Web Development php sql

vibhaJ 126 Master Poster

14 Years Ago

Re: Hindi Data in SQL

Below is mysql code.

CREATE TABLE `tbl_hindi` (
  `data` varchar(1000) character set utf8 collate utf8_bin default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `tbl_hindi` VALUES ('कंप्यूटर');

Below is PHP code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?
	mysql_connect('localhost','root','');
	mysql_select_db('test');
	mysql_query("SET NAMES utf8"); 
	
	$sql = "select * from tbl_hindi";
	$res = mysql_query($sql);
	$sar = mysql_fetch_assoc($res);
	echo $sar['data'];
?>
</body>
</html>

I didnt get why this is not working for you.
See attached image, it works for me.

Web Development php sql

vibhaJ 126 Master Poster

14 Years Ago

Re: Help with functioning Javascript

thank-you.html is in form action so page is redirecting to there.

Web Development javascript

vibhaJ 126 Master Poster

14 Years Ago

Re: Help with spacing of dynamically generated tables

Your loop is messy.
This code shows simple looping for showing data in tabular form.

<?php
 $username="root";
 $password="";
 $database="";

 mysql_connect('localhost',$username,$password);
 @mysql_select_db($database) or die( "Unable to select database");
 $query="SELECT * FROM jokes";
 $result=mysql_query($query);

 echo '<table width="900%" border="0">';
 while($sar = mysql_fetch_assoc($result))
 {
 	echo '<tr>
    <td>'.$sar['name'].'</td>
    <td>'.$sar['content'].'</td>
  </tr>';
 }
 echo '</table>';
 mysql_close();
 ?>

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Validation before submitting the form in PHP

There are so many jquery form validations available, Check this both if anyone match your needs.
http://www.raymondselda.com/php-contact-form-with-jquery-validation/
http://webcloud.se/log/Form-validation-with-jQuery-from-scratch/#demo-form

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Cmparing mysql tables

Firstly you need to log some table data to compare in future.
Lets say primary key of table.
Create one table table_log which will have all primary key.

tbl_log:
id primary_key datetime
1 12,13,14,16,19,20,21 timestamp
2 12,13,14,19,20,21,22,23 timestamp

Now make one php script which will be set in cron job.
Task of php script is as below:
It takes last entry from table_log and export primary_key by ','
Then make a loop to compare with existing table primary_key.
Based on that you can check whether record is deleted or added and you can make an email for that.
Lastly take all primary key from you table and implode it and insert into table table_log for next compare.

Web Development mysql php

vibhaJ 126 Master Poster

14 Years Ago

Re: Php syntax error?

Can you try this code?

echo 'Query:'.$sql = "SELECT * FROM Products";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
	echo $row['Description'] . " " . $row['Price'] . " " . $row['Quantity'];
	echo "<br />";
}

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: How to export the data as csv file from mysql in php?

You can make changes according to your database.

<?
	mysql_connect('localhost','root','');
	mysql_select_db('test');
	
	$sql = "select student_name,student_sirname from student";

	// Query Database	
	$filename = 'file.csv';		
	$rsSearchResults = mysql_query($sql) or die(mysql_error());
	
	$out = '';
	
	// fiels to export
	$out .='Student Name,Sirname';
	$out .="\n";
	
	// Add all values in the table
	while ($l = mysql_fetch_array($rsSearchResults)) {
	for ($i = 0; $i < 2; $i++) {
	$out .=''.$l["$i"].',';
	}
	$out .="\n";
	}
	// Output to browser with appropriate mime type
	header("Content-type: text/x-csv");	
	header("Content-Disposition: attachment; filename=$filename");
	echo $out;
	exit;	
?>

Web Development mysql php

vibhaJ 126 Master Poster

14 Years Ago

Re: Custom Marker on map

Sorry last attachment was incorrect.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Custom Marker on map

Try this demo code.
See attached output image.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <title>Google Maps JavaScript API Example</title>    
    <script src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=ABQIAAAAwoZubRYDwEsxPfeOl798iRS9zaDN-rzK-R-PNcf5yAaJ9r7Z4BTy9LU9DUBfJ7r-F6C7tX-2AidMHQ&sensor=true"
            type="text/javascript"></script>
    <script type="text/javascript">

    function initialize() 
	{
      if (GBrowserIsCompatible()) {
        var map = new GMap2(document.getElementById("map_canvas"));
        map.setCenter(new GLatLng(23.005, 72.5959), 15);
        map.setUIToDefault(); // will add top menu,left menu etc	
		
		var new_icon = new GIcon();  
		new_icon.image = "images/car_blue.png" ;
		new_icon.size = new GSize(16,16) ; 
		new_icon.iconAnchor = new GPoint(6, 20);
		new_icon.infoWindowAnchor = new GPoint(5,1)  ;		
		var marker = new GMarker(new GLatLng(23.005, 72.5959), new_icon);
		map.addOverlay(marker);
		}		
	}
	 </script>
  </head>
  <body onload="initialize()" onunload="GUnload()">
    <div id="map_canvas" style="width: 700px; height: 500px"></div>
  </body>
</html>

Web Development php

karthik_ppts commented: helpful post +3

vibhaJ 126 Master Poster

14 Years Ago

Re: Custom Marker on map

Can you give live link if possible?

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Custom Marker on map

Can you replace your code with this.
Also make sure image exists in given path.

var new_icon = new GIcon();  
new_icon.image = "images/car_blue.png" ;
new_icon.size = new GSize(16,16) ; 
new_icon.iconAnchor = new GPoint(6, 20);
new_icon.infoWindowAnchor = new GPoint(5,1)  ;

var marker = new GMarker(point, new_icon);
map.addOverlay(marker);

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: comparing table id to $_POST value(s)

Your question is pretty unclear.
Do you have problem with matching posted id with table OR dou you want to parse html ?

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Php syntax error?

you need to replace this line.

mysql_query("SELECT*FROM Products='"$result"'");

$result = mysql_query("SELECT * FROM Products");

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: login credentials not correct

Replace this much code and check whether all three values are coming correct or not.
If its correct that means code is right and problem is in mysql credentials.

function DBLogin()
{
echo '--host--'.$this->db_host.'--username--'.$this->username.'--pwd--'.$this->pwd;
$this->connection = mysql_connect($this->db_host,$this->username,$this->pwd);

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: problem

Can you post your whatsoever code for review.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: how many days late?

Here is a code for date difference you can use $days and save it in your database.

<?
	$duedate = '2011-04-29';
	$currdate = date('Y-m-d');
	
	$date1 = $duedate;
	$date2 = $currdate;
	
	$diff = abs(strtotime($date2) - strtotime($date1));
	
	$years = floor($diff / (365*60*60*24));
	$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
	$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
	
	echo "Difference is $years years, $months months, $days days.";
?>

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: get the search results in iframe after press "refresh" button?

What is the code to save the last url? Thanks!

This is the simplest way to save current page url.
<?
	$_SESSION['sess_currPageName'] = basename($_SERVER['PHP_SELF']).'?'.$_SERVER['QUERY_STRING'];
?>

Agree to ardav, i also prefer ajax than iframe.
As in ajax all controls are in your hand.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: get the search results in iframe after press "refresh" button?

If iframe's search page is your php code then you can make a session and save last url in that session.
When page is loaded or refreshed you can use session's remembered url as a src of iframe.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: how read ics?

ics file is sort of xml structure.
You can find xml php parser or xmltoarray function like this and then can save its value in mysql database.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Need help in DAta Type of SQL Version 5.1.36

You can use mysql_real_escape_string function for filtration.
Refer this link.http://in2.php.net/manual/en/function.mysql-real-escape-string.php

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: PHP Job portal

You can not get it in urgency.
First you have to refer 2 or 3 matching sites like naukri, monster.
Then you can discuss with your client and decide your required modules.
You can simultaneously design database and can start working on admin panel.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: not getting value from table

Change your update query to below code:

$sql = "UPDATE oocust SET
 tax = '" . mysql_real_escape_string($tax) . "',
 amtdue = '" . mysql_real_escape_string($amtdue) . "',
dayslate = '" . mysql_real_escape_string($dayslate) . "'
 WHERE id='".$id."'";

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: not getting value from table

1) Why there is two time mysql_connect
2) what is $data, it is nevwe defined above code.

$taxrate = $_POST['taxrate'];
  echo "taxrate " . $data['taxrate'];

3)there should be some variable which hold mysql_fetch_assoc result.

mysql_fetch_assoc(mysql_query($query));

4) so finaly

<?php
  mysql_connect("localhost", "root", "");
  mysql_select_db(numbersdb) or die("Unable to select database");
  
  $query = "SELECT taxrate FROM numbdata ";
  $result = mysql_fetch_assoc(mysql_query($query)); 
  $taxrate = $result['taxrate'];
  echo "taxrate " . $taxrate;  
 
  $query = "SELECT id, tax,charges,datediff(curdate(),duedate) AS dayslate FROM oocust WHERE pd = ' '"; 
  $result = mysql_query($query);
  while ($row = mysql_fetch_array($result))
  {
      $id = $row['id'];
      $amtdue = $row['amtdue'];
      $shipamt = $row['shipamt'];
      $charges = $row['charges'];
      $tax = $charges * $taxrate;
      $amtdue = $charges + $tax + $shipamt;
      echo "tax is $tax <br /><br />";
      $days_late = ($row['dayslate'] > 0) ? $row['dayslate'] : 0;
      $sql = "UPDATE oocust SET tax = " . $tax . ", amtdue = " . $amtdue . ", dayslate = " . $days_late . " WHERE 
id='$id'";
      mysql_query($sql);
      $err = mysql_error();
      if ($err != "")
      {
          echo "Error in $sql: $err\n";
      }
  }
  echo "Invoice Prep completed";
?>

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Export mysql results to CSV from PHP website

Export your table structure and post it here.
I will give you code.

Web Development mysql php

vibhaJ 126 Master Poster

14 Years Ago

Re: Export mysql results to CSV from PHP website

This is because you may have incorrect data in query output.
comment all header lines and check mysql_fetch_row is returning proper output or not?
Also check all list function arguments.

while(list($name,$sirname)=mysql_fetch_row($result))

Web Development mysql php

vibhaJ 126 Master Poster

14 Years Ago

Re: inserting multiple checkbox data to the database

Use array [] in check box name in form as shown below.

Orders
    <input name="orders[]" type="checkbox" value="One" /> One
    <input name="orders[]" type="checkbox" value="Two" /> Two
    <input name="orders[]" type="checkbox" value="Three" /> Three

Then you need to change php code:

<?php
$name = $_POST['name'];
$address = $_POST['address'];
$phone = $_POST['phone'];
$orders = $_POST['orders'];

mysql_connect("localhost", "root","") or die ('Error: '. mysql_error());
mysql_select_db("store");

if(count($orders)>0)
{
	foreach($orders as $key=>$order)
	{
		$query="INSERT INTO orders (id, name, address, phone, custorder) VALUES ('NULL','".$name."','".$address."','".$phone."','".$order."' )";
		mysql_query($query) or die ('Error Updating the Database' . mysql_errno());		
	}
	echo "Order Successfully Placed";
}
else
	echo "No Orders";
?>

Web Development php sql

vibhaJ 126 Master Poster

14 Years Ago

Re: CURRENT_TIMESTAMP and date() are not the same.

This is because default timezone for mysql and php is different.
Check here for mysql timezone and here for php timezone.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Export mysql results to CSV from PHP website

This is simple code for exporting student table to excel.
Hope this helps you.

<?
	mysql_connect('localhost','root','');
	mysql_select_db('test');
	
	$sql = "select name,sirname from student";

	// Query Database
	$result=mysql_query($sql);
	$filename = 'file.xls';
		
	// Send Header
	header("Pragma: public");
	header("Expires: 0");
	header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
	header("Content-Type: application/force-download");
	header("Content-Type: application/octet-stream");
	header("Content-Type: application/download");;
	header("Content-Disposition: attachment;filename=$filename");
	header("Content-Transfer-Encoding: binary ");
	
	// XLS Data Cell
	
	xlsBOF();	  
	xlsWriteLabel(0,0,"Name : ");
	xlsWriteLabel(0,1,"Sirname :");
   
	$xlsRow = 1;
	while(list($name,$sirname)=mysql_fetch_row($result)) 
	{		
		++$i;
		xlsWriteLabel($xlsRow,0,"$name");
		xlsWriteLabel($xlsRow,1,"$sirname");                         
		$xlsRow++;
	}
	xlsEOF();
	exit();

function xlsBOF() {
    echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);  
    return;
}

function xlsEOF() {
    echo pack("ss", 0x0A, 0x00);
    return;
}

function xlsWriteNumber($Row, $Col, $Value) {
    echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
    echo pack("d", $Value);
    return;
}

function xlsWriteLabel($Row, $Col, $Value ) {
    $L = strlen($Value);
    echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
    echo $Value;
return;
} 

?>

Web Development mysql php

vibhaJ 126 Master Poster

14 Years Ago

Re: Hindi Data in SQL

Below is mysql code.

CREATE TABLE `tbl_hindi` (
  `data` varchar(1000) character set utf8 collate utf8_bin default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `tbl_hindi` VALUES ('कंप्यूटर');

Below is PHP code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?
	mysql_connect('localhost','root','');
	mysql_select_db('test');
	mysql_query("SET NAMES utf8"); 
	
	$sql = "select * from tbl_hindi";
	$res = mysql_query($sql);
	$sar = mysql_fetch_assoc($res);
	echo $sar['data'];
?>
</body>
</html>

Web Development php sql

vibhaJ 126 Master Poster

14 Years Ago

Re: php rich text editor

ckeditor is one of the mostly used editor.
check here demo
And see fourth tab (Custom toolbar)
All editor icons are customized, you can change configuration based on requirement.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Yahoo Search API

I am using that on http://www.pdfsearchmachine.com

Hey it is working on this link now.
What was issue?

Web Development api php seo

vibhaJ 126 Master Poster

14 Years Ago

Re: Yahoo Search API

Hey.. m not bro.. m sis :)

ok,bro ,Thanks doing that

Web Development api php seo

vibhaJ 126 Master Poster

14 Years Ago

Re: Yahoo Search API

Hope you are using proper Application id.
It is different for individual sites.
http://developer.yahoo.com/faq/#appid

Web Development api php seo

vibhaJ 126 Master Poster

14 Years Ago

Re: Yahoo Search API

I wonder the other website http://pdf-download-engine.com uses same query and it works

You have to debug it and find the reason.
There is no rocket science.
So i told you to upload my last code on live so that i can debug.

Web Development api php seo

vibhaJ 126 Master Poster

14 Years Ago

Re: Yahoo Search API

Place this code and upload it on live.
I want to see result on live.

$search = urlencode($_GET["search"]);
$rs = $rss->get("http://search.yahooapis.com/WebSearchService/V1/webSearch?appid=YahooDemo&query=$search");
echo '$rs IS ==><br />'; 
print_r($rs);
exit;

Web Development api php seo

vibhaJ 126 Master Poster

14 Years Ago

Re: Yahoo Search API

Okay.. replace this line..

if ($rs = $rss->get("http://search.yahooapis.com/WebSearchService/V1/webSearch?appid=YahooDemo&format=pdf&query=$search"))

Web Development api php seo

vibhaJ 126 Master Poster

14 Years Ago

Re: Yahoo Search API

Try this

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">    
<?

$search = urlencode($_GET["search"]);
 
if ($rs = $rss->get("http://search.yahooapis.com/WebSearchService/V1/webSearch?appid=YahooDemo&query=$search")) 
{  
	// Go through the list powered by the search engine listed and get the data from each <item>
	$colorCount="0"; 
	if(count($rs['items']) >0)
	{
		foreach($rs['items'] as $item) 
		{  
			// Get the title of result 
			$title = $item['title']; 
			// Get the description of the result 
			$description = $item['description']; 
			// Get the link eg amazon.com 
			$urllink = $item['guid']; 
			if($colorCount%2==0)
			{
				$color = ROW1_COLOR;
			}
			else
			{
				$color = ROW2_COLOR;
			}		
			include "resulttemplate.php";
			$colorCount++;
			echo "\n"; 
	 
		}  
	}
	else
	{
		echo "No items in result";exit;
	}
}
else
{
	echo "No result in RSS parser";exit;
}
?>

M considering you have proper RSS reader class.

Web Development api php seo

vibhaJ 126 Master Poster

14 Years Ago

Re: Yahoo Search API

Previously i have explained you reason for foreach error.
Also as i said your given API string is not working for me.

Here is API link i found for yahoo.
http://search.yahooapis.com/WebSearchService/V1/webSearch?appid=YahooDemo&query=yahoo

You can find more parameter options here.
http://developer.yahoo.com/search/web/V1/webSearch.html

Web Development api php seo

vibhaJ 126 Master Poster

14 Years Ago

Re: delete rows in all table in database with specific id

$myQueryVar1 = mysql_query("DELETE FROM mytable1 WHERE id='$idExecuted'");
$myQueryVar2 = mysql_query("DELETE FROM mytable2 WHERE id='$idExecuted'");
$myQueryVar3 = mysql_query("DELETE FROM mytable3 WHERE id='$idExecuted'");
$myQueryVar4 = mysql_query("DELETE FROM mytable4 WHERE id='$idExecuted'");
$myQueryVar5 = mysql_query("DELETE FROM mytable5 WHERE id='$idExecuted'");

The above code is right and should work.
What is problem you are facing.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: PHP & Foreign Keys ?

Yup..
Your logic is absolutely right. :)

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given

tomato is right.
If field is integer then you can direct use php variable but here you have to use single quote.

Web Development mysql php

vibhaJ 126 Master Poster

14 Years Ago

Re: autopopulate another form once submit

I think you need ajax.Reason is below.
let you have a result in frame-1.
Once you submit form page is refreshed.
So even your next target is frame2, your frame1 data will be cleared because of second form submit.

Web Development html-css javascript

vibhaJ 126 Master Poster

14 Years Ago

Re: php tree view type code

Check this...

http://www.mekya.com/blog/lang/eng/2010/03/demo-of-editable-jquery-tree-with-php-codes-duzenlenebilir-jquery-agac-yapisinin-demosu/

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: set authentication for master user and slave user in a network

If you dont want to use database then you can use one simple txt file for lock and unlock.
If master login add text in txt file as 'ON'. Make it 'OFF' when logout.
If slave login then read txt file, if it is 'ON' then only slave can login.

Web Development php

vibhaJ 126 Master Poster

14 Years Ago

Re: Getting this error:Warning: Invalid argument supplied for foreach() in /home4/thesist

For php error,
Always put foreach in if condition.

if(count($rs['items'])>0)
{
	foreach($rs['items'] as $item) 
	{ 
		//--- code---
	}
}
else
{
	echo 'There is no items...';
}

And for URL there are some php variables in url like $search.
Check the string generated (output of php code) in the one you have used in another site.

Web Development php xml

vibhaJ 126 Master Poster

14 Years Ago

Re: my updated page has problem,please help me!

svilla is right.
Can you please use CODE tags now onwards...

Web Development php