DaniWeb IT Discussion Community - PHP

Problem with innerHTML in php page

Narayan15 — Wed, 25 Nov 2009 04:17:08 GMT

hi experts,

Here i have a problem with innerHTML in php page.

it doesn't give any result.

Please help me.

How to split results into multiple pages?

futhonguy — Wed, 25 Nov 2009 02:26:40 GMT

Hi,

I had developed a viewing table from mysql database using php and it is showing me the whole list of contents in a single webpage. I would like to know if there anyway i can actually split the contents into multiple pages for easy viewing??

Your help is greatly appreciated.

Cheers :)

Problems With Displaying columns

xGxTxEx — Tue, 24 Nov 2009 18:57:32 GMT

i am having trouble displaying my database table...i am new to php and mysql (just started last week)... this is the code iam using:




//connect

mysql_connect("","","") or die(mysql_error());

mysql_select_db("") or die(mysql_error());



//query the db

$getnews = mysql_query("SELECT * FROM shows ORDER BY id DESC") or die(mysql_error());



while ($row = mysql_fetch_assoc($getnews))

{





 //get data

$id = $row['id'];

$venue = $row['venue'];

$date = date("m/d/Y", strtotime($row[date]));

$city = $row['city'];

$state = $row['state'];

$exceptions = $row['exceptions'];

$countries = $row['countries'];





echo "&theDates=$date|&theStates=$state|&theCities=$city|&theExceptions=$exceptions|&theClubs=$venue|&theIDs=$id|&theCountries=$countries|


";









                                 

}

?>

editing xml file using php

dalip_007 — Tue, 24 Nov 2009 18:38:27 GMT

Hi
Can anybody please tell me how to edit an xml file with the help of another php file. i am using this xml file in flash

Thanks

mulit-d array intersect question...

cro_php — Tue, 24 Nov 2009 18:27:51 GMT

Hi all:

I am having a heck of a time here... and can't seem to get this to work. I want to intersect arrays that are subset within a multi-dimensional array.

For example, Take the following array:

Array ( [0] => Array ( [0] => 2014 [1] => 2035 [2]=>1999 [3]=>1942 ) [1] => Array ( [0] => 1894 [1] => 1957 [2] => 1963 [3] => 2035 [4]=>1942) )

The intersection of the arrays within the above array should be this array:
Array([0] => 2035 [1] => 1942)

The keys of the subset arrays are irrelevant.

Problem is, I can't figure out the code to help me do this.

----

I've tried to use this user defined function >>

function array_intersect_m($m_array) {
$intersection = $m_array[0];
for ($i=1; $i < count($m_array); $i++) {
$intersection = array_intersect($m_array[$i], $intersection);
}
return $intersection;
}

And sent the above array example into it, but I am getting no result?!?

Any ideas... help?

Thanks,
Chris in DC

cURL and xmlrpc

veledrom — Tue, 24 Nov 2009 17:08:07 GMT

Hi,

I read a bit about both but I need to see your opinions about this.

Are cURL and xmlrpc used for same purposes, are they same thing?

Thanks

HTML in arrays?

whitestream6 — Tue, 24 Nov 2009 16:59:36 GMT

How do you get this to work? - well, for more than simple and tags - I'm trying to get a HTML table in as an array, if this is possible!

Any advice is appreciated!

need php code to send sms to mobile

rohoni — Tue, 24 Nov 2009 15:39:49 GMT

Hi i am developing a new website for mobile shop in php, I need to implement to send sms for the login users, please help me with code in php

Browser won't show php pages

duka96 — Tue, 24 Nov 2009 12:34:59 GMT

I'm having problem with opening php pages in browser. I'm using apache web server and the problem is that instead of a page browser shows php code that i wrote in text editor (for example it shows instead list with informations about php).
Everything worked fine before I've read somewhere that I have to put code PHPIniDir "E:/PHP" (thats location of my php.ini file) in the httpd.conf.
After I did that browser wouldn't show php pages any more. Then I deleted the code but the problem remained.
What did i mess up?

After every change to httpd.conf I stopped and started again apache, but nothing changed.

i need help.....

mgee — Tue, 24 Nov 2009 12:31:04 GMT

am a final yr student n am required to come up wit a project.......ive run out of ideas n if someone out there can help me with the topic that can carry me through all be very greatful.....i jas need topics that i can chose from......thnks guys......

Need a TCP / IP Port Listener on my centos VPS Hosting to receive gps tracker signals

aruti — Tue, 24 Nov 2009 12:19:34 GMT

Hello,
I Need a TCP / IP Port Listener on my centos VPS Hosting to receive gps tracker signals on ports and store in mysql db.

For further processing of received stored data, we are working on a php mysql application, but to listen to port signals, which programming language is the best option on centos, linux?

Also, if you can show me a ready code for the same, that will be helpful. Also, let me know, what to take care of why working on such a solution.

I have a dedicated IP, a VPS Hosting and port numbers 1701 to 1800 open on my server, is that all? and do I need anything else to make such a solution?

Thanks in advance.

how can i get address from lattitude and longitude

aruti — Tue, 24 Nov 2009 12:18:24 GMT

what problem i am actually facing is that .. i have a database -- table in which i have lng and lat saved .. And i want that when i fetch them in textual form i also get the address to which those particular set of lng and lat are defined ..

Is there any straight forward way to get this ?? I dont need to plot them on map .. just in textual format .

Online video Streaming

niladri.user — Tue, 24 Nov 2009 11:29:12 GMT

how can i integrate live video playing in my personal website?i mean live video streaming integration in the website. I need the help[ urgently.

PHP upating a dropdown list with data from a MySQL database

Folaju — Tue, 24 Nov 2009 11:01:47 GMT

I have a silly issue,

I am creating a CMS at the moment. it has pages and menus .

I created a page to add new pages. on that page i have a drop down list that is populated with data from the menu.

I also have an edit page, on this page i want to pull in the current value from the database into a drop down and be able to change the value.

Can anyone help

find host IP

lifeworks — Tue, 24 Nov 2009 09:36:54 GMT

hi

Ive been posed this problem. A friend does maintenance on a companies network, and would like to do it remotely. Currently, their IP changes every 24hrs and so he has to phone them to find their IP so that he can log in...

He asked me to write him something which would pull the host's IP and email it to him, probably running as a cron job...

I can retrieve a visitors IP using PHP, but have no idea how to get the hosts IP...?

PHP Recursion

codewalkz — Tue, 24 Nov 2009 08:32:53 GMT

i must be able to extract the results of this query and use it as another value for "Parent" in the succeeding "THE SAME QUERY". Right here, the value of parent in WHERE clause is "1". Now, I want to create the same query but the value of the parent is the result of the query below.

Thanks a lot! ^_^

//RIGHT HERE I GET THE TOTAL OF LEVEL RESULT OF LEVEL1
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE sponsor = '$parent'")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$lvl1 = $row['COUNT(*)'];
echo "Total Level 1 Downlines : ";
echo "

$lvl1

";
}
//NOW, I GET THE ID OF FIRST LEVEL RESULTS SO I CAN USE IT AS PARENT OF THE SAME QUERY ON LEVEL 2
$result = mysql_query("SELECT id, lastname FROM agents WHERE sponsor = '$parent'")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$output[] = "sponsor = '".$row['id']."' ";
}
$newparent = implode(' or ', $output);

how to use a external javascript file (like external CSS) in php

abhax — Tue, 24 Nov 2009 06:23:13 GMT

Hey all,
i have been using php for past one month only and now im using javascripts with php too...
but my javascript functions have grown out of proportion ...
I want to make a SEPARATE file for JAVASCRIPT just like we do it for EXTERNAL CSS...

how can i do that and is it possible to make a seperate javascript file and call the functions from my php code...?

THNAKS

MLM Unilevel Compression ( PHP Parent Child Relation )

codewalkz — Tue, 24 Nov 2009 03:29:41 GMT

I am currently working on an MLM System which supports Unilevel with Dynamic Compression. So far, though the below code looks really messy, it was able to get what I want which is to get the Unilevel 8 Levels Deep. The system should run this way:

1 is sponsor of 2 & 3 so UNILEVEL 1 has 2 childs ( 2 and 3) Now, the Level 2 Starts with Children 2 and 3 and so on up to 8th level. The code below did it.

My problem now is, if a parent, like for example Number 2 is INACTIVE ( Active or Inactive ), its child should replace his position.

If you know anything or if you can refer me to something related, please do.

Thank you so much!

mysql_connect("localhost", "myhygeia_jun", "xxxxxxxc") or die(mysql_error());
mysql_select_db("myhygeia_agents") or die(mysql_error());

//GET THE ID OF ROOT NODE
$username = $_COOKIE['ID_my_site'];
$pass = $_COOKIE['Key_my_site'];
$query = "SELECT id FROM agents WHERE username = '$username'";
$result = mysql_query($query) or die('Error :On Right Head ' . mysql_error());
$row = mysql_fetch_array($result);
$parent = $row['id'];

//----------------------------------------------------------------------------------------------------------

//GET THE TOTAL OF LEVEL 1
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE sponsor = '$parent'")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$lvl1 = $row['COUNT(*)'];
echo "Total Level 1 Downlines : ";
echo "

$lvl1

";
}
//GET THE ID FIRST LEVEL FRONTLINES AND PASS TO GET 2ND LEVEL
$result = mysql_query("SELECT id, lastname FROM agents WHERE sponsor = '$parent'")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$output[] = "sponsor = '".$row['id']."' ";
}
$level1 = implode(' or ', $output);

//----------------------------------------------------------------------------------------------------------

//GET THE TOTAL OF LEVEL 2
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE ($level1) ")or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$lvl2parent = $row['COUNT(*)'];
echo "Total Level 2 Downlines : ";
echo "$lvl2parent

";
}
//GET THE ID SECOND LEVEL FRONTLINES AND PASS TO GET 3rD LEVEL
$result = mysql_query("SELECT id, lastname FROM agents WHERE ($level1)")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$output[] = "sponsor = '".$row['id']."' ";
}
$level2 = implode(' or ', $output);

//-----------------------------------------------------------------------------------------------------------

//GET THE TOTAL OF LEVEL 3
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE ($level2) ")or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$lvl3parent = $row['COUNT(*)'];
echo "Total Level 3 Downlines : ";
echo "$lvl3parent

";
}
//GET THE ID THIRD LEVEL FRONTLINES AND PASS TO GET 4th LEVEL
$result = mysql_query("SELECT id, lastname FROM agents WHERE ($level2)")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$output[] = "sponsor = '".$row['id']."' ";
}
$level3 = implode(' or ', $output);

//-----------------------------------------------------------------------------------------------------------

//GET THE TOTAL OF LEVEL 4
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE ($level3) ")or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$lvl4parent = $row['COUNT(*)'];
echo "Total Level 4 Downlines : ";
echo "$lvl4parent

";
}
//GET THE ID FOURTH LEVEL FRONTLINES AND PASS TO GET 5TH LEVEL
$result = mysql_query("SELECT id, lastname FROM agents WHERE ($level3)")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$output[] = "sponsor = '".$row['id']."' ";
}
$level4 = implode(' or ', $output);

//-----------------------------------------------------------------------------------------------------------

//GET THE TOTAL OF LEVEL 5
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE ($level4) ")or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$lvl5parent = $row['COUNT(*)'];
echo "Total Level 5 Downlines : ";
echo "$lvl5parent

";
}
//GET THE ID FIFTH LEVEL FRONTLINES AND PASS TO GET 6TH LEVEL
$result = mysql_query("SELECT id, lastname FROM agents WHERE ($level4)")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$output[] = "sponsor = '".$row['id']."' ";
}
$level5 = implode(' or ', $output);

//-----------------------------------------------------------------------------------------------------------

//GET THE TOTAL OF LEVEL 6
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE ($level5) ")or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$lvl6parent = $row['COUNT(*)'];
echo "Total Level 6 Downlines : ";
echo "$lvl6parent

";
}
//GET THE ID SIXTH LEVEL FRONTLINES AND PASS TO GET 7TH LEVEL
$result = mysql_query("SELECT id, lastname FROM agents WHERE ($level5)")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$output[] = "sponsor = '".$row['id']."' ";
}
$level6 = implode(' or ', $output);

//-----------------------------------------------------------------------------------------------------------

//GET THE TOTAL OF LEVEL 7
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE ($level6) ")or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$lvl7parent = $row['COUNT(*)'];
echo "Total Level 7 Downlines : ";
echo "$lvl7parent

";
}
//GET THE ID 7TH LEVEL FRONTLINES AND PASS TO GET 8TH LEVEL
$result = mysql_query("SELECT id, lastname FROM agents WHERE ($level6)")or die(mysql_error());
$output = array();
while ($row = mysql_fetch_array($result)) {
$output[] = "sponsor = '".$row['id']."' ";
}
$level7 = implode(' or ', $output);

//-----------------------------------------------------------------------------------------------------------

//GET THE TOTAL OF LEVEL 8
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE ($level7) ")or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$lvl8parent = $row['COUNT(*)'];
echo "Total Level 8 Downlines : ";
echo "$lvl8parent

";
}

?>

printer_open() function

sim_pack — Tue, 24 Nov 2009 02:52:58 GMT

hello.. i'd like to confirm if the printer function "printer_open()" without parameters opens the printer connected to the user/client computer? or does it look at all network connections including the web for the presence of a printer?

thanks..

Defining functions in an if-else statement

darkagn — Tue, 24 Nov 2009 01:59:53 GMT

Hi all,

I have seen code of the form:

if(file_exists("foo.php")
include("foo.php");
else
include("blah.php");

As far as I know, this is perfectly legal in php. What I was wondering was is it possible to do the following in in-line code in PHP?

if(file_exists("foo.php")
// contains a specialised version of myFoo function
include("foo.php");
else
{
// define the default function here
function myFoo($param)
{
// do something here
}
}

So in other words I want to be able to define a function in my PHP code only if the specialised version does not exist. I need to do this without the use of classes and inheritance if possible, and I can't include a second file at this stage, just wondering if the above code is legal or not.

Thanks in advance for your thoughts and time.

Regards,
darkagn

Running different scripts off a single form

levsha — Mon, 23 Nov 2009 22:49:47 GMT

Let's say I have an HTML form and there is a group of radio buttons.
A need different script to be run depending on which button is checked.
Let's say I have this:

PRODUCT

SOFTWARE

SERVICE

SLOGAN

How do I do that?
I'm thinking of doing multiple hidden submit buttons, but I don't know how to run PHP scripts off them.
I used to do it through {header}, but when I do that, a parameter that I need to be passed to the next file, somehow doesn't get passed. Or I misunderstand something...

Create a unique Hash

smartness — Mon, 23 Nov 2009 21:45:32 GMT

Hi DaniWeb users.

I am creating a mp3 shop cart script, and I need a function to create a unique id of multiple items in the cart.

for example in cart are these id's: 1,6,21,5
base64 would make this: MSw2LDIxLDU=

I need it only alphanumeric as it is ment to be sent from a sms!

So when the user sents the sms, my server needs to "decode" it and get the cart items user 'purchased' from with a sms!

how do i display date()(the date from that function) in different timezones?

SKANK!!!!! — Mon, 23 Nov 2009 21:34:52 GMT

i need all the 24 timezones and i have to display them all. how do i display the date and time in all 24 timezones?
im using time() to put the time into the mysql database now i need to use date() to display the date and time in all timezones please help

Is it possible for host to do something itself

hno — Mon, 23 Nov 2009 17:53:13 GMT

HI
I want when somebody comes to my site and go out from it , a certain page still execute by the server and continue to do it's work.
Is it possible to execute some codes after the user close it by the server ?
Thanksv

error in php using ajax view list to full listt

mhran419 — Mon, 23 Nov 2009 14:56:42 GMT

i want to create list load from db countries and then full second list from db when condition true.
code run in opera successfully but in IE Not run...
I'm beginner and using Smarty Templates.
first code country.tpl
second show_country.php
third country.js

Country List yousing AJAX

Choose Your Country:

Choose your city

Show Customers

----------------------------------------------------------------------------
include('header.php');

$id = intval($_GET['id']);
//$smarty->assign('id',$id);

require_once('modules/modloadcountry.php');
$arrcountry = loadcountries($id,false);
$smarty->assign('arrcountry',$arrcountry);

/* Smarty Class But Using looping

$sql = "select * from cities where id = ".$id;
$result = $db->Execute($sql);

$id = $result->fields['id'];
$city = $result->fields['city'];
$smarty->assign('id',$id);
$smarty->assign('city',$city);

echo "";
*/

//Normal PHP
$link = mysql_connect("localhost","root","");
$db = mysql_select_db("entelaq",$link);

$sql = "SELECT * FROM cities WHERE id= $id";
$result = mysql_query($sql);

while ( $row = mysql_fetch_array($result) )
{
echo "";

}
//echo "".$sql."";
//echo "".$result."";

$smarty->display('country.tpl');

include('footer.php');
?>

------------------------------------------------------------------------

var xmlHttp = new XMLHttpRequest(); // Declaration Object

function ShowCity()
{
xmlHttp.open('get','show_country.php?id='+document.frm1.slccountry.selectedIndex); // Send Request
xmlHttp.onreadystatechange = handleInfo;
xmlHttp.send(null); // End Request
}

function handleInfo()
{
if(xmlHttp.readyState == 1)
{
document.getElementById('slccountry').innerHTML = 'loading ..';
}

else if(xmlHttp.readyState == 4)
{
var response = xmlHttp.responseText; // Server Answer
document.getElementById('slccity').innerHTML = response; // print to Menu
}
}

Create a shortening hash function

samarudge — Mon, 23 Nov 2009 13:06:50 GMT

Hi,
I need to create a function to shorten a numerical ID to a string of letters
E.G.

echo encode_num('1'); //Outputs a
echo encode_num('3'); //Outputs c
echo encode_num('26'); //Outputs z
echo encode_num('27'); //Outputs A
echo encode_num('52'); //Outputs Z
echo encode_num('53'); //Outputs aa
echo encode_num('54'); //Outputs ab
etc.

But I also need to be able to decode them again like

echo decode_num('a'); //Outputs 1

Is this possible to do?
Thanx,
Sam Rudge

See PHP code from a website online

web3 — Mon, 23 Nov 2009 12:29:39 GMT

I can't access my old hosting account. I don't now my username. I now the domain and can i see PHP code on one page.

How to use curl option

ym_chaitu — Mon, 23 Nov 2009 09:48:35 GMT

Hai
i am using the curl option to validate the site for the rss feed.
my code is

// create a new cURL resource
$ch = curl_init();
$demo='http://chaitu09986025424.blog.co.in/feed/rss/';
// set URL and other appropriate options
curl_setopt($ch, CURLOPT_URL, "http://validator.w3.org/feed/check.cgi?url=$demo");
curl_setopt($ch, CURLOPT_HEADER, false);

// grab URL and pass it to the browser
curl_exec($ch);
echo $info['http_code'] . " " . $http_codes[$info['http_code']];
// close cURL resource, and free up system resources
curl_close($ch);
?>

now the problem is that how do i read the file and pass the parameters...
the result of this would be

Congratulations!
This is a valid RSS feed.

Recommendations
This feed is valid, but interoperability with the widest range of feed readers could be improved by implementing the following recommendations.

•line 11, column 107: Self reference doesn't match document location [help]

... rel="self" type="application/rss+xml" /> ^Source: http://chaitu09986025424.blog.co.in/feed/rss/
1.
2. 3.xmlns:content="http://purl.org/rss/1.0/modules/content/"
4.xmlns:wfw="http://wellformedweb.org/CommentAPI/"
5.xmlns:dc="http://purl.org/dc/elements/1.1/"
6.xmlns:atom="http://www.w3.org/2005/Atom"
7.>
8.
9.
10.Chaitu's
11.
12.http://chaitu09986025424.blog.co.in
13.Know about the World and gain some Knowledge
14.Fri, 20 Nov 2009 11:18:56 +0000

how do i pass the This is a valid RSS feed. data in code so that i can validate the given url..

please some body help me on this..

classes and session variables

lifeworks — Mon, 23 Nov 2009 07:57:59 GMT

Hi

Im new to OO PHP, been reading through my book and in one example they are using a class structure in a shopping cart. I have used session variables in the past for shopping carts, can I assume that if I create a class, which has a cart_contents array variable to which I add products, that the data will be accessible from page to page (like a session variable is accessible on all pages)...?

thanks
lworks

birthday script

muralikalpana — Mon, 23 Nov 2009 07:33:02 GMT

hello,
i want to display names of upcoming birthdays whose between "today" to "end of every month". how to do this

Converting PHP Feed to XML Feed?

brandonmofiki — Sun, 22 Nov 2009 21:49:36 GMT

I have developed an RSS Feed in php. (can be found at http://www.mofikiworldwide.com by clicking the rss icon in the top right)

My reason for using php to develop the feed was so that I wouldn't have to manually update a feed in an xml file everytime I needed to add something to it. It just reads a database and everytime I sbmit a new blog it auto populates the feed.

You can use IE8 I know to subscribe to the feed but most feedburner style sites can't see my feed or wont load it due to the fact that its not actually a xml file.

Any thoughts?

PHP Image processing

lili.edryana — Sun, 22 Nov 2009 19:52:15 GMT

hello everyone..
i would to ask about my simple code here.. it's not working..
i actually want to display a forum badge which is data are received from the database. And i stucked at putting the avatar to a portion of the badge..i mean it looks like facebook profile badge...
i created a background image using imagecreatefrompng() function..

can anybdy with this?

define('PUN_ROOT', '../');
require PUN_ROOT.'include/common.php';

$id = isset($_GET['id']) ? base64_decode($_GET['id']) : 0;

//PHP's GD class functions can create a variety of output image
//types, this example creates a jpeg
header("Content-type: image/png");

//open up the image you want to put text over
$im = imagecreatefrompng("testing.png");

//The numbers are the RGB values of the color you want to use
$black = imagecolorallocate($im, 0, 51, 102);

$sql = $db->query('SELECT username, num_posts FROM '.$db->prefix.'users WHERE id='.$id) or error('Unable to fetch new password', __FILE__, __LINE__, $db->error());
$result = $db->fetch_assoc($sql);
$Uname = $result['username'];
$Nopost = 'No. of posts» '.$result['num_posts'];

//font
$font = './Verdana.ttf';

//write data to the image
imagettftext($im, 10, 0, 20, 12, $black, $font, $Uname);
imagettftext($im, 10, 0, 20, 30, $black, $font, $Nopost);

//path to avatar directory
$avapath = '../img/avatars/'.$id.'png';

// Copy and merge avatar to the backgroud
// Something wrong here.. =(
$src = imagecreatefrompng($avapath);
imagecopymerge($im, $src, 10, 10, 0, 0, 100, 47, 75);

imagepng($im);
imagedestroy($im);

?>

Adding a page - Trick behind

evstevemd — Sun, 22 Nov 2009 19:33:28 GMT

When you add a page in CMS (Like Wordpress' admin) what does it actually do? Add predefined table? Or what?
Thanks!

Practical code for paging

evstevemd — Sun, 22 Nov 2009 15:33:47 GMT

Hi,
I'm learning making CMS. As you can see, I cannot do everything from scratch. So I request anyone with code in his codebase that works fine on paging or knows practical code to point me. I want to page my articles once are more than let say 10

Cheers :)

Select inner join, and limit

evstevemd — Sun, 22 Nov 2009 14:55:01 GMT

Hi all,
I want to do simple query to do the Join
Here is illustartion of my query which gives error

"SELECT * FROM table1, INNER JOIN table2 ON table1.colx = table2.colx LIMIT 30"

What goes wrong here?

Devide in pages (Pageing)

ruwanaru — Sun, 22 Nov 2009 10:44:59 GMT

I need a help with php i have a query it generate result that list of cars and i want is divide in to pages here im giving the table structure and the php file can help me on this

Table Structute

CREATE TABLE IF NOT EXISTS `cars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`make` varchar(50) NOT NULL,
`model` varchar(50) NOT NULL,
`trans` varchar(50) NOT NULL,
`fuel` varchar(50) NOT NULL,
`year` int(11) NOT NULL,
`km` int(11) NOT NULL,
`vin` int(11) NOT NULL,
`regdetails` varchar(50) NOT NULL,
`state` varchar(50) NOT NULL,
`price` varchar(100) NOT NULL,
`features` varchar(1000) NOT NULL,
`pic1` varchar(5000) NOT NULL,
`pic2` varchar(5000) NOT NULL,
`pic3` varchar(5000) NOT NULL,
`pic4` varchar(5000) NOT NULL,
`pic5` varchar(5000) NOT NULL,
`pic6` varchar(5000) NOT NULL,
`uname` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `uname` (`uname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `cars`
--

INSERT INTO `cars` (`id`, `make`, `model`, `trans`, `fuel`, `year`, `km`, `vin`, `regdetails`, `state`, `price`, `features`, `pic1`, `pic2`, `pic3`, `pic4`, `pic5`, `pic6`, `uname`) VALUES
(14, 'ALFA ROMEO ', 'ALFA', 'Automatic', 'Gasoline/Petrol', 2009, 0, 0, 'Unregisted', 'Northern Territory', 'ASK', '
Anti-Lock Brakes(ABS)
Driver Airbag
Passenger Airbag
Side Airbag
Alarm
A/C:front
Cruise Control
Navigation System
Power Steering
Remote Keyless Entry
Tilt Wheel
Digital Meter
Child Seat
Leather Seats
Power Seats
Bucket Seat
Power Windows
Rear Window Wiper
Tinted Glass
AM/FM Radio
AM/FM Stereo
CD Changer
CD Player
Premium Sound
Satellite Radio
DVD
TV
Alloy Wheels
Power Door Locks
Power Mirrors
Sunroof
Third Row Seats
Power Slide Door
Custom wheels
Fully loaded
Maintenance records available
New paint
New tires
No accidents
One owner
Performance tires
Upgraded sound system
Turbo
', './adpics/AlfaRomeoC8.jpg', './adpics/Alfa-Romeo-8c-Competizione.jpg', './adpics/alfa-romeo-8c.jpg', './adpics/alfa-8c.jpg', './adpics/alfa8c.jpg', './adpics/2003_Alfa_Romeo_8C_Competizione_Concept.jpg', 'nirman'),
(11, 'BMW ', 'M3', 'Automatic', 'Diesel', 2007, 123, 0, 'Unregisted', 'Western Australia', 'ASK', '
Anti-Lock Brakes(ABS)
Driver Airbag
Passenger Airbag
Side Airbag
Alarm
Power Door Locks
Power Mirrors
', './adpics/2009_Camaro_1.jpg', './adpics/0007500089184_500X500.jpg', './adpics/0088732421005_AV_500X500.jpg', './adpics/AustraliaMap.png', './adpics/Iloverock.gif', './adpics/YeahIloverock.jpg', 'ruwanaru'),
(12, 'BMW ', 'M3', 'Automatic', 'Diesel', 2009, 123, 0, 'Unregisted', 'Western Australia', 'ASK', '
Anti-Lock Brakes(ABS)
Driver Airbag
Passenger Airbag
Side Airbag
Alarm
Power Door Locks
Power Mirrors
', './adpics/2009_Camaro_1.jpg', './adpics/0007500089184_500X500.jpg', './adpics/0088732421005_AV_500X500.jpg', './adpics/AustraliaMap.png', './adpics/Iloverock.gif', './adpics/YeahIloverock.jpg', 'ruwanaru'),
(13, 'AUDI ', 'R8', 'Automanual', 'Gasoline/Petrol', 2008, 123, 0, 'Unregisted', 'Northern Territory', 'ASK', '
Anti-Lock Brakes(ABS)
Driver Airbag
Passenger Airbag
Side Airbag
Alarm
A/C:front
Cruise Control
Navigation System
Power Windows
DVD
', './adpics/2009_Camaro_1.jpg', './adpics/0007500089184_500X500.jpg', './adpics/2009_Camaro_1.jpg', './adpics/AustraliaMap.png', './adpics/2009_Camaro_1.jpg', '../adpics/2009_Camaro_1.jpg', 'nirman'),
(15, 'ALFA ROMEO ', 'ALFA', 'Automatic', 'Gasoline/Petrol', 2009, 0, 0, 'Unregisted', 'Northern Territory', 'ASK', '
Anti-Lock Brakes(ABS)
Driver Airbag
Passenger Airbag
Side Airbag
Alarm
A/C:front
Cruise Control
Navigation System
Power Steering
Remote Keyless Entry
Tilt Wheel
Digital Meter
Child Seat
Leather Seats
Power Seats
Bucket Seat
Power Windows
Rear Window Wiper
Tinted Glass
AM/FM Radio
AM/FM Stereo
CD Changer
CD Player
Premium Sound
Satellite Radio
DVD
TV
Alloy Wheels
Power Door Locks
Power Mirrors
Sunroof
Third Row Seats
Power Slide Door
Custom wheels
Fully loaded
Maintenance records available
New paint
New tires
No accidents
One owner
Performance tires
Upgraded sound system
Turbo
', './adpics/AlfaRomeoC8.jpg', './adpics/Alfa-Romeo-8c-Competizione.jpg', './adpics/alfa-romeo-8c.jpg', './adpics/alfa-8c.jpg', './adpics/alfa8c.jpg', './adpics/2003_Alfa_Romeo_8C_Competizione_Concept.jpg', 'nirman');

PHP file

include("init/db.php");
$yearfom = $_POST["yearFrom"];
$yearTo = $_POST["yearTo"];

$Year ="SELECT";

if($yearfom!="SELECT"){
$Year ="";
}

$content = array("make"=>$_POST["make"],
"model"=>$_POST["model"],
"year"=>"$Year" );

$validValues=array();

foreach ($content as $key=>$value)
{
if($value != "SELECT")
{
$validValues[$key]=$value;

}

}

$query ="select * from cars where ";
foreach($validValues as $key=>$value)
{

$query1 = $query.$key."='".$value."' AND ";
$qu1=true;
if($key == "year"){
$query1 = substr($query1,0,-8);
$query2 = $query1." BETWEEN '".$yearfom."' AND ' ".$yearTo."'";
$qu1=false;
$qu2=true;

}

}

if($qu1==true){
$query = substr($query1,0,-4);

}elseif($qu2==true){

$query = $query2;
}

echo $query;
$result=mysql_query($query);
$row=mysql_num_rows($result);
if($row>0){
while ($info=mysql_fetch_array($result)){

$make = $info['make'];
$model = $info['model'];
$price = $info['price'];
$features = $info['features'];
$year= $info['year'];

$pic1=$info['pic1'];
$pic2=$info['pic2'];
$pic3=$info['pic3'];

$id = $info['id'];
$desc=str_replace ("
", " ", $features);

$ftt = substr($desc,0,120).".................";
$abc="'viewad.php?id=$id'";

echo '

'.$make.' - '.$model.' - '.$year.'

$ '.$price.'

'. $ftt.'

';
}
}
else {echo '

Comming Soon !

';}
?>

can any one find the error of ths pageing

ruwanaru — Sun, 22 Nov 2009 07:20:34 GMT

In this db and query are working and the firs page but after the 2nd page the variables are not passing can any one help me on this

Untitled Document

include("../init/db.php");

$yearfom = $_POST["yearFrom"];
$yearTo = $_POST["yearTo"];

$Year ="SELECT";

if($yearfom!="SELECT"){
$Year ="";
}

$content = array("make"=>$_POST["make"],
"model"=>$_POST["model"],
"year"=>"$Year");

$validValues=array();

foreach ($content as $key=>$value)
{
if($value != "SELECT")
{
$validValues[$key]=$value;

}

}

$query ="select * from cars where ";
foreach($validValues as $key=>$value)
{

$query1 = $query.$key."='".$value."' AND ";
$qu1=true;
if($key == "year"){
$query1 = substr($query1,0,-8);
$query2 = $query1." BETWEEN '".$yearfom."' AND ' ".$yearTo."' ";
$qu1=false;
$qu2=true;

}

}

if($qu1==true){
$query = substr($query1,0,-4);
echo $sql = $query;

}elseif($qu2==true){

$query = $query2;
echo $sql = $query;
}

// how many rows to show per page
$rowsPerPage = 2;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

// $sql= "select * from cars where year BETWEEN '2007' AND ' 2009' ";
$result=mysql_query($sql);
$row=mysql_num_rows($result);

while($info=mysql_fetch_array($result)){

$make = $info['make'];
$model = $info['model'];
$price = $info['price'];
$features = $info['features'];
$year= $info['year'];

$pic1=$info['pic1'];
$pic2=$info['pic2'];
$pic3=$info['pic3'];

$id = $info['id'];
$desc=str_replace ("
", " ", $features);

$ftt = substr($desc,0,120).".................";
$abc="'viewad.php?id=$id'";

echo '

'.$make.' - '.$model.' - '.$year.'

$ '.$price.'

'. $ftt.'

';

}

// how many rows we have in database
$foreditqu= substr($sql,19,-1);
echo $foreditqu;

$query = "SELECT COUNT(id) AS numrows FROM cars ".$foreditqu;
echo $query;
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
echo "
".$numrows = $row['numrows'];

echo "
";
// how many pages we have when using paging?
echo $maxPage = ceil($numrows/$rowsPerPage);

// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';

for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= " $page "; // no need to create a link to current page
}
else
{
$nav .= " $page ";
}
}

// creating previous and next link
// plus the link to go straight to
// the first and last page

if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " [Prev] ";

$first = " [First Page] ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " [Next] ";

$last = " [Last Page] ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}

// print the navigation link
echo $first . $prev . $nav . $next . $last;

?>

Find a Car

Make

Model

Year

one account for multiple sites

shishtawitch — Sun, 22 Nov 2009 07:19:51 GMT

how can i use a single account on my double sites.........either with cookies or any thing else...........!!

suppose i have http://www.mydomain.com and also
http://another.mydomain.com how can it use my single account with these both sites..........!!

how to style highlight_string() without creating a mock function

SKANK!!!!! — Sun, 22 Nov 2009 04:53:20 GMT

i want to style highlight_string() how can i style it?

signup php page

dalypen — Sun, 22 Nov 2009 03:27:27 GMT

Hi, I got this for nfl pickem program and installed it on my website.I use yahoo web hosting. I have most apps working but the signup form is killing me. when user go to my webpage and try to signup, it just takes you to a blank page. here is the code

require('includes/application_top.php');
require('includes/classes/crypto.php');
include('includes/classes/class.formvalidation.php');
include('includes/classes/class.phpmailer.php');

if (!$allow_signup) {
header('location: login.php?signup=yes');
exit;
}

if (isset($_POST['submit'])) {

$my_form = new validator;
$mail = new PHPMailer();

if($my_form->checkEmail($_POST['email'])) { // check for good mail

if ($my_form->validate_fields('firstname,lastname,email,username,password')) { // comma delimited list of the required form fields
if ($_POST['password'] == $_POST['password2']) {
//create new user, enable
$username = mysql_real_escape_string(str_replace(' ', '_', $_POST['username']));
$sql = "SELECT userName FROM " . $db_prefix . "users WHERE userName='".$username."';";
$result = mysql_query($sql);
if(mysql_numrows($result) > 0){
$display = '
User already exists, please try another username.

';
} else {
$sql = "SELECT email FROM " . $db_prefix . "users WHERE email='".$email."';";
$result = mysql_query($sql);
if(mysql_numrows($result) > 0){
$display = '
Email address already exists. If this is your email account, please log in or reset your password.

';
} else {
$crypto = new phpFreaksCrypto;
$salt = substr($crypto->encrypt((uniqid(mt_rand(), true))), 0, 10);
$secure_password = $crypto->encrypt($salt . $crypto->encrypt($password));
$sql = "INSERT INTO " . $db_prefix . "users (userName, password, salt, firstname, lastname, email, status)
VALUES ('".$username."', '".$secure_password."', '".$salt."', '".$firstname."', '".$lastname."', '".$email."', 1);";
mysql_query($sql) or die(mysql_error());

//send confirmation email
$mail->IsHTML(true);

$mail->From = $user->email; // the email field of the form
$mail->FromName = 'NFL Pick \'Em Admin'; // the name field of the form

$mail->AddAddress($_POST['email']); // the form will be sent to this address
$mail->Subject = 'NFL Pick \'Em Confirmation'; // the subject of email

// html text block
$mail->Body = '
Thank you for signing up for the NFL Pick \'Em Pool. Please click the below link to confirm your account:
' . "\n" .
$siteUrl . 'signup.php?confirm=' . $crypto->encrypt($username) . '
';

//$mail->Send();

header('Location: login.php');
}
}
} else {
$display = '
Passwords do not match, please try again.

';
}
} else {
$display = str_replace($_SESSION['email_field_name'], 'Email', $my_form->error);
$display = '
' . $display . '

';
}
} else {
$display = '
There seems to be a problem with your email address, please check.

';
}
}
?>

NFL Pick 'Em Signup

NFL Pick 'Em Signup

if(isset($display)) {
echo $display;
}
?>

Sign Up

First Name:
Last Name:
Email:
User Name:
Password:
Confirm Password:

include('includes/footer.php');
?>

Help needed to make Mafia Game.

NeeedYourHelppp — Sat, 21 Nov 2009 18:51:03 GMT

I need help to make a Text based mafia game.

I cant code :L But im willing to try and learn.
The game i am thinking of should be something like Gangster Bliss or Gangster Paradise :)

Anybody willing to help me? :D

Web/C++/PHP File Updates

jimmiller96 — Sat, 21 Nov 2009 17:43:27 GMT

I'm not really sure which forum this belongs in, but please bear with me as I try to explain what I am looking to do.

I have a PHP web site designed to display status updates from several dozen computers around the world. Up until now an administrator updates a single .csv file and uploads it to the site, after which PHP parses and displays the information. This is obvious very cumbersome, and has had too many inaccuracies due to the the human element. Therefore, I am looking to automate the update of the csv file directly from each of the computers.

I have designed a C++ program that runs locally on each machine, and will collect and format the respective line that will be updated in the .csv. Unfortunately this all happens locally, and still requires a manual upload. With that said, I am looking for any suggestions and help with being able to automate this process.

My current thought process is to remotely open the .csv file on the web server and update it directly from my C++ app. Or possible download, update, then re-upload. Or maybe PHP (with other technologies) provides the functionality to be able to take a string and update a text file on the server. I may be way off base here, which is probably the case because I wouldn't know how to accomplish these ideas anyway.

With that said, I am open to any and all suggestions to being able to do this. Obviously the simpler the better, but I am really stuck and looking for some thoughts to accomplishing this.

Thanks in advance,
Jim

how to validate a rss feed address

ym_chaitu — Sat, 21 Nov 2009 15:37:50 GMT

Hai
i am building a site for validation of the RSS feeds and adding it in the database.
When a user enters a rss web address i need to validate the address and if it contains a rss then i need to enter it into the site or else i need to mention a message..
how do i do it.
i think the easy way is to pass the feed address to this address http://validator.w3.org/feed/check.cgi?url=

but how can i check what result is it giving..
do any one have an idea or else if u have any validation things available. kindly help me out..

Add New Subscription URL :

//include("login.php");
include("access.php");
mysql_select_db($dbname);
if (isset($_COOKIE['user']))
{
echo "Welcome $_COOKIE[user]
";
$username="$_COOKIE[user]";
//echo "
$username
";
$query = mysql_query("SELECT email,password FROM userlogin WHERE username = '$username'") or die(mysql_error());
$data = mysql_result($query,0);
//echo $data;
}
else
{
echo "";
}

$subscr=$_REQUEST['subscr'];
if($subscr)
{
//url validation

if (preg_match('|^http(s)?://[a-z0-9-]+(.[a-z0-9-]+)*(:[0-9]+)?(/.*)?$|i', $subscr))
{
//print "$subscr url OK.";
mysql_select_db($dbname);
$re=mysql_query("select * from usubs where url='$subscr'");
$rows=mysql_num_rows($re);
if($rows==0)
{
mysql_query("Insert into usubs(email,url) values('$data','$subscr')");
//echo "";
}
else
{
echo "The $subscr url already exists with your login";
//echo "";
}

}
else
{

print "$subscr url not valid!";
}
}
else
{
//echo "";
//echo("$subscr");
}
?>

this is my code
presently i am using the regular expression of the website address but how do i use it to verify the rss feed address..
as the present one is validating the www.google.com also as a valid feed..

Snapshot of webpage using PHP

ayesha789 — Sat, 21 Nov 2009 15:04:15 GMT

Hi dear all
I want to take snapshot of webpage and then save it into a folder.
please tell me the basics , i am new to it.

automated sitemap ?

genieuk — Sat, 21 Nov 2009 13:04:38 GMT

Hi,

I have a sitemap and have decided to create an automated sitemap.

I just wanted to ask would the way i am going to do it be ok.

I was going to create a table let say called `sitemap` have a column in the table called `url`. Basically i would create a section in my admin so i can manually add/delete/edit if i wanted to.

then i was going to create a sitemap.xml file

in that file i was going to create a simple php script that querys the database and using mysql_fetch_array to get everything from the url column and echo it out something like the below, i just created the below script quickly as an example:

// my global file will go here
sql_con(); // function to connect to db in global file
$query = mysql_query("SELECT * FROM `sitemap`");
$fetch_data = mysql_fetch_array($query);

echo "";
echo "" . $fetch_data['url'] . "";
echo "always";
echo "";

?>

Would something like this work?

If it does i will be adjusting some of my scripts that i have to insert url whilst for example submitting a blog post so i wont have to manually add to db, but before i go anyfurther i wanted to maker sure would something like the above work.

Thanks
Genieuk

how do i get expandable veritical menu with stable in navigation

rajabhaskar525 — Sat, 21 Nov 2009 06:31:52 GMT

hi all, i want expandable veritical menu . when click on header it will another page with expandable state is same as previous one. any one having this script help me.......

internal mail

muralikalpana — Sat, 21 Nov 2009 06:01:05 GMT

hello,
i want to build a internal mailing system in website.
only registered users can send mails to each other.
i have taken "compose mail","inbox","sent items","trash".
i want to create database now. can you please tell me cloumn names for this

Strange php behaviour

OrcaSoul — Sat, 21 Nov 2009 03:53:56 GMT

I have a site that I am working on, and I got tired of having to change the root path every time I uploaded the script from the local to on-line server.

I tested the following code on both local (XAMPP under Windows) and web (shared Linux hosted on GoDaddy) server, and both returned the proper path.

echo $_SERVER['DOCUMENT_ROOT'];

?

So, I added a way for the script to detect and automatically use the appropriate server path.

This required changing 3 include files:
In myapp.inc:

require_once 'db.inc';
require_once 'customHandler.inc';

// Switch between local & server
// - local - //define("D_INSTALL_PATH", "c:/xampp/htdocs");
// - server - //define("D_INSTALL_PATH", "/home/content/o/r/c/myapp/html");
define("D_INSTALL_PATH", $_SERVER['DOCUMENT_ROOT']);

In template.inc:

// ITX template class extensions for the myapp
// -- myappTemplate is a generic page
// -- myappFormTemplate is a
page (and extends myappTemplate)

require_once "MDB2.php";
// Switch between local & server
if (D_INSTALL_PATH == "c:/xampp/htdocs")
require_once "C:/xampp/htdocs/PEAR/HTML/Template/ITX.php";
else
require_once "HTML/Template/ITX.php";

In db.inc:

// Database parameters
// Switch between local & server
if (D_INSTALL_PATH == "c:/xampp/htdocs")
{
$hostname = "localhost";
$username = "********";
}
else
{
$hostname = "myapp.db.5158902.hostedresource.com";
$username = "********";
}

****************************************

When I run this on the on-line server, it runs quite well - with little lag time between pages.

But, when I run this on the local server, it spins it's wheels for over a minute before giving me the requested page - or, on the one page where I request an MySQL query, I get the following errors...

Notice: Use of undefined constant D_INSTALL_PATH - assumed 'D_INSTALL_PATH' in C:\xampp\htdocs\myapp\includes\template.inc on line 9

Notice: Use of undefined constant D_INSTALL_PATH - assumed 'D_INSTALL_PATH' in C:\xampp\htdocs\myapp\includes\db.inc on line 4

So what am I missing?

Form Mailer

cguan_77 — Sat, 21 Nov 2009 03:45:35 GMT

hi guys, need your help on this..any ideas is greatly appreciated..i got this form mailer from this site:
http://www.dtheatre.com/scripts/sour...e/formmail.txt

but how to configure in php the form mailer that if in my form got two options (like the code below) that if the user choose this particular option then it will go to that particular e-mail.

So basically, got two options on the site but will have two e-mails also but not both of them will receive the mail, when the user press the submit button then it will go only to that particular mail in which the user selected.

please help...

but this one works if data is sent to one e-mail
here's the code on my form:

'then will go to particular e-mail

Type

Preferred Schedule Date
Preferred Schedule Time
Preferred Location
Name
Tel
Email
Member No.

'problem here I want to put another e-mail
'depending on what option the user choose
'from above selection

getting the form's data is done by a function by php on the form mailer that i found on the link given above..

can anyone help on how to do if there's two e-mail on the form..
below is the php code of the form's mailer to get the data..

thanks..

// This function takes the sorts, excludes certain keys and
// makes a pretty content string.
function parse_form($array, $sort = "") {
// build reserved keyword array
$reserved_keys[] = "MAX_FILE_SIZE";
$reserved_keys[] = "required";
$reserved_keys[] = "redirect";
$reserved_keys[] = "require";
$reserved_keys[] = "path_to_file";
$reserved_keys[] = "recipient";
$reserved_keys[] = "subject";
$reserved_keys[] = "sort";
$reserved_keys[] = "style_sheet";
$reserved_keys[] = "bgcolor";
$reserved_keys[] = "text_color";
$reserved_keys[] = "link_color";
$reserved_keys[] = "vlink_color";
$reserved_keys[] = "alink_color";
$reserved_keys[] = "title";
$reserved_keys[] = "missing_fields_redirect";
$reserved_keys[] = "env_report";
$reserved_keys[] = "submit";
if (count($array)) {
if (is_array($sort)) {
foreach ($sort as $field) {
$reserved_violation = 0;
for ($ri=0; $ri if ($array[$field] == $reserved_keys[$ri]) $reserved_violation = 1;

if ($reserved_violation != 1) {
if (is_array($array[$field])) {
for ($z=0;$z $content .= $field.SEPARATOR.$array[$field][$z].NEWLINE;
} else
$content .= $field.SEPARATOR.$array[$field].NEWLINE;
}
}
}
while (list($key, $val) = each($array)) {
$reserved_violation = 0;
for ($ri=0; $ri if ($key == $reserved_keys[$ri]) $reserved_violation = 1;

for ($ri=0; $ri if ($key == $sort[$ri]) $reserved_violation = 1;

// prepare content
if ($reserved_violation != 1) {
if (is_array($val)) {
for ($z=0;$z $content .= $key.SEPARATOR.$val[$z].NEWLINE;
} else
$content .= $key.SEPARATOR.$val.NEWLINE;
}
}
}
return $content;
}

// mail the content we figure out in the following steps
function mail_it($content, $subject, $email, $recipient) {
global $attachment_chunk, $attachment_name, $attachment_type, $attachment_sent, $bcc;

$ob = "----=_OuterBoundary_000";
$ib = "----=_InnerBoundery_001";

$headers = "MIME-Version: 1.0\r\n";
$headers .= "From: ".$email."\n";
$headers .= "To: ".$recipient."\n";
$headers .= "Reply-To: ".$email."\n";
if ($bcc) $headers .= "Bcc: ".$bcc."\n";
$headers .= "X-Priority: 1\n";
$headers .= "X-Mailer: DT Formmail".VERSION."\n";
$headers .= "Content-Type: multipart/mixed;\n\tboundary=\"".$ob."\"\n";

$message = "This is a multi-part message in MIME format.\n";
$message .= "\n--".$ob."\n";
$message .= "Content-Type: multipart/alternative;\n\tboundary=\"".$ib."\"\n\n";
$message .= "\n--".$ib."\n";
$message .= "Content-Type: text/plain;\n\tcharset=\"iso-8859-1\"\n";
$message .= "Content-Transfer-Encoding: quoted-printable\n\n";
$message .= $content."\n\n";
$message .= "\n--".$ib."--\n";
if ($attachment_name && !$attachment_sent) {
$message .= "\n--".$ob."\n";
$message .= "Content-Type: $attachment_type;\n\tname=\"".$attachment_name."\"\n";
$message .= "Content-Transfer-Encoding: base64\n";
$message .= "Content-Disposition: attachment;\n\tfilename=\"".$attachment_name."\"\n\n";
$message .= $attachment_chunk;
$message .= "\n\n";
$attachment_sent = 1;
}
$message .= "\n--".$ob."--\n";

mail($recipient, $subject, $message, $headers);
}

Crawler

taminder — Sat, 21 Nov 2009 00:56:00 GMT

hey, so for my first project in my class, I need to build a crawler
this is what I need it to do:

- crawl and follow all urls on a domain (not go out into other websites)
- get the title of the page
- get the meta tag keywords of the page
- get the meta tag description of the page
- get the url of the page
- store all of this information in a MySQL database
- then follow the url's on the page and do the same thing on those pages

- if possible, I would also like to get the full index of the page and store it into the MySQL database as well (we are going to make a script for our next project to search for keywords of what we crawled, but I can do that myself after I have the data).

I'm not planning to create a public website or anything, just something for private testing. if you cannot help with this but you know of other scripts with similar features to use as reference, that would be huge help as well.

One DB record from two HTML forms

levsha — Fri, 20 Nov 2009 21:52:18 GMT

I have two HTML pages, each has a form.
The user is supposed to fill out the input fields in one, then click a submit button that will send him to the next page, where he would fill out the rest of the fields of his questionaire, click a submit button.
After that I need all the input data collected from both pages (forms) to be inserted into one record in the database.
How would I achieve that?

Thanks a million in advance!

lamp

coolbuddy059 — Fri, 20 Nov 2009 20:21:55 GMT

hi friends,
I've come across a word LAMP while searching for some php codes.Can someone kindly tell what does this mean and what type of application can be developed from it. And how to begin learning it(sources which provide complete information).

2 dimensional array issue

loligator — Fri, 20 Nov 2009 20:07:24 GMT

So here's the code:

function procRestSearch($searchQuery){
//Don't forget to have $searchquery defined before calling this function
$intSearchCounter = 0; //Used to set the arrays
$searchResult = mysql_query($searchQuery);
while($searchRow = mysql_fetch_array($searchResult, MYSQL_ASSOC)){
//Change/Add/Delete the variables below to match what data needs to be returned
$strRest = array($intSearchCounter => array('restID' => $searchRow['rest_id'],
'restName' => $searchRow['rest_name'], 'restAddress' => $searchRow['rest_address'],
'restAddress2' => $searchRow['rest_address2'], 'restCity' => $searchRow['rest_city'],
'restState' => $searchRow['rest_state'], 'restZip' => $searchRow['rest_zip'],
'restCC' => $searchRow['rest_country_code'], 'restAC' => $searchRow['rest_area_code'],
'restPhone' => $searchRow['rest_phone_no'], 'restFAC' => $searchRow['rest_fax_no'],
'restManager' => $searchRow['rest_manager'], 'restAsManager' => $searchRow['rest_assistant_manager'],
'restWebsite' => $searchRow['rest_website']));

$intSearchCounter++;
}
return $strRest;
}

the problem is when I call this function I get a Notice: Undefined offset: 0 in... error. However, if I replace $intSearchCounter with a static value, such as just replacing it with 0, it works but then I only get the last result from the query returned. What am I doing wrong?

I a php script that can restrict a user from adding additional image to his account o

dannybarh — Fri, 20 Nov 2009 18:05:38 GMT

Hi to All.
1. I want a php script that can restrict a user from adding additional image to his account on my site, I the admin should be able to set the restricting for the user. I also want to be able to activate/deactivate this function in the admin section
2. I want users to be able to add things they browse to “add to my list” , just like adding things to a shopping cart.

Thank You.

php on same page as form

mrjoli021 — Fri, 20 Nov 2009 16:21:45 GMT

I have an html form when i submit it it goes to a php page. i want to change the action so the php execution happens on the same page.

EMail:
First Name:
Last Name:
Password:

//conection
include('sqlconn.php');
$mysql = new sqlConnection;

//retrive data from POST form
$email=$_POST['email'];
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$password=$_POST['password'];

//insert data into DB
$query = "INSERT INTO `client_Info`.`users` (`email` ,`fname` ,`lname` ,`password`)
VALUES (NULL , '$email', '$fname', '$lname', '$password')";
mysql_query($query) or die('Error, insert query failed');
$last_Id = mysql_insert_id();

$mysql->close();

//redirect back to login page.
header( 'Location: http://localhost/testsite' ) ;
?>

php preg_match vs preg_replace

shishtawitch — Fri, 20 Nov 2009 14:51:47 GMT

i have following in my database
------------------------------------------------------------------------------------

Vicky Bhai Part 4
http://www.mysite.com
Stage Funny Stuff
------------------------------------------------------------------------------------
if want to add a anchor tag to only image before displaying it on page.................how can i do that with preg match or preg replace

.htaccess, some symbols causing problem

anishmsry — Fri, 20 Nov 2009 13:05:07 GMT

hi,
i'm using .htaccess so that the variables passed through links are not seen.

http://localhost/user/jack should be converted to http://localhost/user/?uid=jack

i used:
RewriteRule ^user/([^.]+)/?$ profile/?uname=$1 [NC,L]
whatever characters is input, i want that to be passed and then check.
everything's working perfect.
but when the following symbols are used, the errors such as these are appearing
Forbidden
You don't have permission to access /user/: on this server.

the symbols which are causing the problems are:
%,*,\,:,",<,>

what should i do to avoid this?

refresh

muralikalpana — Fri, 20 Nov 2009 10:25:37 GMT

hello..
i want to write code for refresh only division part which is in page. why because i am fetching images from database randomly. when we refresh the page the image change randomly.
so.....i want to do refresh only division part every 1min. how to do?

getting part of url with php

shishtawitch — Fri, 20 Nov 2009 10:05:56 GMT

how can i get only value of 'v' from the following url
http://www.youtube.com/watch?v=NMAYr709-9Y&feature=dir
i.e NMAYr709-9Y
with php

fetching youtube embed code.......with php

shishtawitch — Fri, 20 Nov 2009 09:12:26 GMT

i want to pass a youtube code like
http://www.youtube.com/watch?v=NMAYr709-9Y&feature=dir
and it return me the embed code.........!! how can i do that with php and curl........!!

How to display random html pages using php

ym_chaitu — Fri, 20 Nov 2009 08:59:12 GMT

Hai
I have some html files and i would like to display them in a random manner using the php.
can any one help me out..I have been trying this one..
but it is not working..

$dir="./clock/";
$nimg="10";
$itype="html";
$rnumb=rand(1,$nimg);

echo "";
?>

Add a date in mysql using php

mundetas — Fri, 20 Nov 2009 08:11:10 GMT

Can someone please help:(. I have a database with a field Date. I made the datatype to Date. But when I code the date in php I use the date() function to get the current date it donesn't want to insert in the database. Please help.

For example my code.

$name = $_POST['name'];
$date = date("yyyy,mm,dd");

insert into tablename ('name','date') values ('{$name}','{$date}');

network timeout on updating large result in one query

sam023 — Fri, 20 Nov 2009 07:45:06 GMT

i m updating 3000 records in on query after few sec.. page shows network timeout...!! how to get rid of it..

thanks

curl vs xmlhttprequest

shishtawitch — Fri, 20 Nov 2009 07:36:09 GMT

hi,
how can i make a link attache ment system with php, culr / ajax
one like in facebook..........!!
i.e by typing a link fetching meta, title and images from that link...!!

thanks in advance.........!!

how to sms to mobile phones from my web site.

rajabhaskar525 — Fri, 20 Nov 2009 05:50:27 GMT

hi all, i want to send sms to mobile phones from web site . is there any solution for this ....... give me idea!!!!!!!!.......

Search query

ruwanaru — Fri, 20 Nov 2009 05:10:54 GMT

this is my db table content

tble name : cars
id | make | model | trans | fuel | year | km | vin | regdetails | state | price | features

what i want is search the car with this form

Find a Car

Make

Model

Year

Price

im new in php so please help me with full scripts

insertion of selected checkbox records in another table

ayesha789 — Fri, 20 Nov 2009 04:12:09 GMT

hi every body, i am sure its not that much hard but somehow i stuck in situation which look
very much unclear to me.

in fact i have a table through i am selecting different records

each records will be printed with the checkbox

what i want to insert checked fields in the database

following is the code which i am using for printing the each field with check box

$con = mysql_connect("localhost","","");
if(!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("", $con);

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

while($row = mysql_fetch_array($result))
{
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";

echo "";
echo "";
echo "
" .$row[1] . " " . $row[2] . " " . $row[5] . " " . $row[4] . "
";

}

?>

Passing variable as a link

levsha — Fri, 20 Nov 2009 04:03:43 GMT

I retrieve three pieces of data from my MySQL table and need to pass one of them as a parameter in a link to a dynamically populated .php page and two of them use as the link text.
The echo statement below is not working.
Could you please see what's wrong with it?
Thank you!

$connection = mysql_connect("server.com","user","password") or die ("Couldn't connect to server.");
$db = mysql_select_db("mydb", $connection) or die ("Couldn't select database.");

$data = "SELECT inventorid, firstname, lastname FROM inventors WHERE taskdate - curdate() = 0";
$query = mysql_query($data) or die("Couldn't execute query. ". mysql_error());

while($data2 = mysql_fetch_array($query)) {
echo "$data2['inventorid'] $data2['firstname'] $data2['lastname']\n";
}
?>

Internet bot

drjay1627 — Fri, 20 Nov 2009 00:28:54 GMT

My friend and I are working on an Internet bot. We want to make a bot that given a website, would index into a table.

Example --

Given the website: www.daniweb.com

Add to table:

www.daniweb.com/c++
www.daniweb.com/c++/forum
www.daniweb.com/java
etc...

Any suggestion on how to do this?

How do I get rid of gaps between cells in table.

marlowkc — Thu, 19 Nov 2009 23:52:13 GMT

I cannot figure out how to do this. I have set the padding and border as 0 and tried the collapse border command. Here is my code:

Untitled Document

Enable GD Library

ytregnn — Thu, 19 Nov 2009 21:44:36 GMT

I'm trying to enable GD Library. I use PHPMyAdmin.

How can I do this?

Tiles Matching Game, Sessions 1D array // random_shuffle()

kryz — Thu, 19 Nov 2009 18:55:53 GMT

I'm trying to create a tiles matching (memory) game. I'm a beginner and I'm confused how exactly to start on creating one dimensional array for sessions. The tiles should be at least 30 with text values. When the user select first tile (reveal the text) and then user select second tile; if two tiles match, should remove tiles from the board. When user complete the board, user should be presented with a summary of their performance and the option to play again (new board should be generated).

I have no clue how to make 1d dimensional array or make random_suffle().

I try to run it and it doesn't show up any errors. Its just blank page.

Here is what I have so far:

session_start();

if(!isset($_SESSION['game']))
{
$tile = array("Item 1", "Item 2");

for($n = 3; $n<11; $n++)
{
$tile[] = "Item ".$n;
}
}
else
{
$tile = $_SESSION['game'];
}

echo "";
echo "";
$rowCount=0;
for($i=0; $i {
// if($i%6==0)
$rowCount++;
if($rowCount==6)
{
echo "\n";
$rowCount=0;
}
if(($_SESSION['flip1']==$i)or($_GET['index']==$i))
{
echo "";
}
else
{
echo "";
}

}
echo "";
echo "
".$_SESSION['game'][$i]." flip me!
";
?>

else not working

mrjoli021 — Thu, 19 Nov 2009 17:25:13 GMT

my else statement is not executing it returns a black page.

while($results = mysql_fetch_array($user_name))
{
if ($results['email'] == $Entered_UserName && $results['password'] == $Entered_PassWord)
echo 'working';
else
echo 'not working';
}

php mail with mysql

HITMANOF44th — Thu, 19 Nov 2009 15:30:25 GMT

ok i can post the script if you guys want its kinda on the large side mostly i just need to bounce some ideas off you

i made a event calendar and now i am making a script to email
users of the current months events i have this working

this is the issuse i made a html email in php i make a table in it
now when i go to the page every thing comes up perfect but
when i get the email that should look exsactly like that
some data in the table is shifted or the itself is not
a color any one have any ideas and some random ! show up ?

mail form with jQuery and PHP

Neona — Thu, 19 Nov 2009 15:25:49 GMT

I will start out by saying that I have no experience with PHP at all.. sorry.
However, since I do some asp.net etc I thought I would throw myself into it..

I have come across a problem though.
I've found a mail form using jQuery.

What it's supposed to do when I hit the 'submit' button is this:

function closeForm(){
$("#messageSent").show("slow");
setTimeout('$("#messageSent").hide();$("#contactForm").slideUp("slow")', 2000);

But ever since I tied some PHP to the thing to actually make it work and send mail. It will automatically redirect me to a blank page.. the PHP document address. Instead of calling closeForm.

Alternatively I can do a header() and send it back to the front page, but that's just so far from satisfying...

I'm thinking there's just something basic about how PHP operates that I don't know about..
But let me know if you need to see more of the code behind, and I'll gladly supply it.

Thanks in advance
Maria

Passing variables from a php MySQL lookup

VAMPResearch — Thu, 19 Nov 2009 14:39:20 GMT

I am trying to create a page that will look up values from a table to fill in drop down boxes, i have this working. Now when the user selects options and presses a button i would like these values to get written to a table.

This code is my form that looks up values and populates drop down fields for the user.

Godfather Wars

« Goto VAMP Research by Kristopher Thomas Croteau

Godfather Wars

Welcome to your desk

$user = $_GET['user'];
echo "
Home
";
echo "
Profile
";
echo "
Your Family
";
echo "
Hitlist
";
echo "
Contact Admin
";
echo "
Dons Desk
";
?>

Message Inbox

// Connecting, selecting database
$link = mysql_connect('HOST', 'USER', 'PASSWORD')
or die('Could not connect: ' . mysql_error());
mysql_select_db('DBNAME') or die('Could not select database');
// Performing SQL query
$user = $_GET['user'];
$query = "SELECT `name` FROM Members where username = '$user'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "";foreach ($line as $value);}
echo "
Welcome to your desk Don $value
";
// Closing connection
mysql_close($link);
?>

This is your desk

// Connecting, selecting database
$link = mysql_connect('HOST', 'USER 'PASSWORD')
or die('Could not connect: ' . mysql_error());
mysql_select_db('DBNAME') or die('Could not select database');
// Performing SQL query
$user = $_GET['user'];
$query = "SELECT `name` FROM Members where username = '$user'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "";foreach ($line as $value);}
echo "$value";
// Closing connection
mysql_close($link);
?>

Your family members

// Connecting, selecting database
$link = mysql_connect('HOST', 'USER 'PASSWORD')
or die('Could not connect: ' . mysql_error());
//echo 'Connected successfully';
mysql_select_db('DBNAME') or die('Could not select database');
// Performing SQL query
$user = $_GET['user'];
$query = "SELECT * FROM Members where family = (SELECT family FROM Members where username = '$user')";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

$num = mysql_numrows($result);
$i=0;
do {
$Name = mysql_result($result,$i,"name");
$rank = mysql_result($result,$i,"rank");

$queryrank = "SELECT `rank` FROM ranks where id = '$rank' order by rank desc";
$resultrank = mysql_query($queryrank) or die('Query failed: ' . mysql_error());
while ($line1 = mysql_fetch_array($resultrank, MYSQL_ASSOC)) { echo "";foreach ($line1 as $value1);}

// Printing results in HTML
echo "$Name - $value1
";
$i++;
} while ($i < $num);
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
?>

Contracts on your family

// Connecting, selecting database
$link = mysql_connect('HOST', 'USER 'PASSWORD')
or die('Could not connect: ' . mysql_error());
//echo 'Connected successfully';
mysql_select_db('DBNAME') or die('Could not select database');
// Performing SQL query
$user = $_GET['user'];
$query = "SELECT * FROM hitlist where targetfamily = (SELECT family FROM Members where username = '$user') and complete = '0' and sanctioned = '1'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$num = mysql_numrows($result);
$i=0;
if($num==0)
{
echo "There are no contracts on your family!";
}
else
{
do {
$target = mysql_result($result,$i,"target");
$killer = mysql_result($result,$i,"contractedto");
$family = mysql_result($result,$i,"contractfamily");
$date = mysql_result($result,$i,"issuedate");
// Printing results in HTML
echo "Target: $target
";
//echo "Assassian: $killer
";
echo "Contracted by: $family
";
echo "Contract Date: $date
";
echo "------------------------------------
";
$i++;
} while ($i < $num);
}
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
?>

Contracts started by your family

// Connecting, selecting database
$link = mysql_connect('HOST', 'USER 'PASSWORD')
or die('Could not connect: ' . mysql_error());
//echo 'Connected successfully';
mysql_select_db('DBNAME') or die('Could not select database');
// Performing SQL query
$user = $_GET['user'];
$query = "SELECT * FROM hitlist where contractfamily = (SELECT family FROM Members where username = '$user') and complete = '0' and sanctioned = '1'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$num = mysql_numrows($result);
$i=0;
if ($num==0)
{echo "There are no contracts started by your family! You are the Don start one!";
}
else
{
do {
$target = mysql_result($result,$i,"target");
$killer = mysql_result($result,$i,"contractedto");
$family = mysql_result($result,$i,"contractfamily");
$date = mysql_result($result,$i,"issuedate");
// Printing results in HTML
echo "Target: $target
";
echo "Target family: $family
";
echo "Assassian: $killer
";
echo "Contract Date: $date
";
echo "------------------------------------
";
$i++;
} while ($i < $num);
}
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
?>

Requested contracts

// Connecting, selecting database
$link = mysql_connect('HOST', 'USER 'PASSWORD')
or die('Could not connect: ' . mysql_error());
//echo 'Connected successfully';
mysql_select_db('DBNAME') or die('Could not select database');
// Performing SQL query
$user = $_GET['user'];
$query = "SELECT * FROM hitlist where contractfamily = (SELECT family FROM Members where username = '$user') and complete = '0' and sanctioned = '0'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$num = mysql_numrows($result);
$i=0;
if ($num==0)
{
echo "There are not requested contracts at this time!";
}
else
{
do {
$target = mysql_result($result,$i,"target");
$killer = mysql_result($result,$i,"contractedto");
$family = mysql_result($result,$i,"contractfamily");
$date = mysql_result($result,$i,"issuedate");
// Printing results in HTML
echo "Target: $target
";
echo "Target family: $family
";
echo "Requested By: $killer
";
echo "Contract Date: $date
";
echo "------------------------------------
";
$i++;
} while ($i < $num);
}
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
?>

Family Controls

Use the controls below to control your family:

Contracts/Hits

View Current

Add

Cancel

Complete

Members

Add

Remove

Promote

Demote

Points

View Current

Add

Remove

This page uses the Perfect 'Holy Grail' 3 Column Liquid Layout by Matthew James Taylor. Thanks for such a cool layout.

When the user clicks the button these variables should be passed into the database. I have this form so far:

//This section writes the user data to the table.
$target=$_POST['target'];
$date=$_POST['date'];
$assign=$_POST['assign'];
echo "Values are Target: " .$target;
$host="HOST"; // Host name
$username1="USER"; // Mysql username
$password1="PASSWORD"; // Mysql password
$db_name="DBNAME"; // Database name
$tbl_name="TABLENAME"; // Table name
// Connect to server and select databse.
$con = mysql_connect("$host", "$username1", "$password1")or die("cannot connect");
mysql_select_db('gfwars') or die('Could not select database');
$query = "INSERT INTO `Members` VALUES ($target,'',$assign,'',$date,'0','','1')";
mysql_query($query);
mysql_close($con);
header('Location: family.php?user='.$user);
?>

Any idea how i can get the information in the option boxes to this second php page?

Storing info in Cookies

hkseo100 — Thu, 19 Nov 2009 14:26:23 GMT

Hey guys, I'm modifying a classified site, it's written in PHP.
What I'm trying to do is when a user comes in the website for the first time (aka no cookies created) the value of the variable would be -1, when they click on a state to browse in, it will have ?statechosen=1&blahblah, so the value would be 1 for a variable, and if its 1 it won't ask for the states again, it will only ask for the states when its -1, or 0.

but it's weird.
i have to click on the name of the state twice to have the cookie settings in effect. And if i go on the index page twice, it'll ask me to choose the state again.

here's the code.

function xSetCookie($name, $value)
{
setcookie($name, $value, 0, "/");
}

setcookie($ck_choosestate, $xstatechosen, time()+(60*24*60*60), "/");

$xstatechosen ="";
$statechosen ="";

$ck_choosestate = "xzclf_choosestate";

//Choose State
$nostate = -1;
if ($_GET['statechosen'] > 0)
{
$xstatechosen = $_GET['statechosen'];
}
elseif ($_GET['statechosen'] < 0)
{
$xstatechosen = $_GET['statechosen'];
}
elseif ($_COOKIE[$ck_choosestate] > 0)
{
$xstatechosen = $_COOKIE[$ck_choosestate];
}
elseif ($_COOKIE[$ck_choosestate] < 0)
{
$xstatechosen = $_COOKIE[$ck_choosestate];
}
elseif ($nostate)
{
$xstatechosen = $nostate;
}

how to import the contacts from sites like yahoo, gmail, facebook, orkut..

rajabhaskar525 — Thu, 19 Nov 2009 13:31:48 GMT

hi all, i am new to php. i want know about how to import contacts from yahoomail,gmail, orkut, facebook, xing,..........like. if anybody know about these. help me. share with me. ........

Problem in transfer fron 1st list to another?

Aamit — Thu, 19 Nov 2009 12:48:04 GMT

Hi,

I am trying to transfer multiple select country to another select box.

But when i click on submit i didn't get the value of array of list2 i.e finallist?

I can't understand what is problem??

Please help me how to solve this??

if($_POST["add"])
{
echo "sdads";
echo "
hello ->".$country_array=$_POST['finallist'];

}
?>

Sql upload - I must be simple?

eman neercs — Thu, 19 Nov 2009 12:38:10 GMT

Running php/mysql site where the db is constantly being changed with new products added, categories and prices changed all through php scipts.

Just before it publishes the results to a static html file, there is a (my)sql file with product data that has been held "off table" so it cannot be inadvertently changed by the other scripts. I currently add this back manually but I'd like to use php to do it.

I could change the data to txt or csv and use mysql insert statements but I cannot find how to do a simple upload the .sql to a db.

Where should I start looking?

how to insert data into 2 tables in MySQL using PHP

Nuw2php — Thu, 19 Nov 2009 09:39:28 GMT

hi,

I have created 2 tables called "User_Info" & "Auth_Users".

In "User_Info" table "ID" is the primary key. In "Auth_Users" table "ID" is the foreign key.

I have created a "User Form" through which I am trying to capture the data. Since the primary key is an auto_increment value I don't have to insert that in the "User_Info" table.

In the "User Form" I have fields like - Firstname, Lastname, Phone, Email & Password. I am trying to break this fields and Insert "firstname, lastname, phone" in "User_Info" table and "Email & Password" in "Auth_Users" table.

Besides this, i also want to insert the same "ID" number from "User_Info" table to "Auth_Users" table "ID" field.

I couldn't get it solved. Please help me.

refresh part of the page

rajabhaskar525 — Thu, 19 Nov 2009 07:53:37 GMT

hai all, i want to refresh particular part of the page ,not whole page. is it possible? . if so, how is it? .........

Moving a field contents from Table B to Table A

futhonguy — Thu, 19 Nov 2009 07:41:55 GMT

Hi

I am wondering if i can move a field (with contents) from Table B to Table A. If so how can i do it?

Any advise ?? Thank you very much..

php hedder is not working

ruwanaru — Thu, 19 Nov 2009 06:21:58 GMT

This is the error

Warning: Cannot modify header information - headers already sent by (output started at /home/rejocoma/public_html/login-registor/do_login.php:9) in /home/rejocoma/public_html/login-registor/do_login.php on line 40

and this comming only on my hosting not in local machine ita unix hosting solution

can any one give me a help on this im a new in php and pleas give me a help...

Thank you.........

login in php

xuexue — Thu, 19 Nov 2009 05:50:39 GMT

hi there, i am making a website. my problem is that, i have multiple users who should access the same page, now what i want is that, my login code will work whenever users will access it simultaneously. the problem is that, the code just checks the first logged in user.

Example, user1 and user2 logged in simultaneously. the login code detects the first logged in user it sees from the database (user1). user1 views its homepage, now user2 accesses user1's homepage since user1 logged in first. now, when user1 logs out, it will only be the time when user2 sees his homepage.

what i want is that, when both users log in simultaneously, they will see their own homepages. thanks, any code will be very much appreciated.. tnx in advance.

mail() not doing tables (showing code: etc..)
SKANK!!!!! — Wed, 18 Nov 2009 22:56:02 GMT
im using the php mail() function to send an email and i got the email. except its formatted wrong like it looks like this:

width="60%"etc.. u get it right?
i use gmail. now ive had images sent in mails to me. so why is this not working? i havent tested images but i figure that if table doesnt work img wont either. whats going on? is there a workaround? or is this what all mail sent by php mail() is bound to look like.

i have free hosting atm. or is it the hosting?
im clueless halp?!

dynamic variable plug into a mysql query?

localtechguy — Wed, 18 Nov 2009 19:57:23 GMT

HI!

I am trying to find a way to plug some data that is spit out of a mysql query into another mysql query.

example.

$zip1 = $_POST[zip1];

"SELECT * FROM zipcodedb WHERE ZipCode >= '". $zip1 ."'"
lets say i get that query to spit out these 3 results with a while loop :
11758
11759
11760

now i need to take those three zipcodes and plug them into another mysql query

"SELECT * FROM zipcodedb WHERE ZipCode = 11758 OR ZipCode = 11759 OR ZipCode = 11760"

The part i am stuck on is this.
I need to figure out a way to dynamically populate the WHERE portion of this query because the above zipcodes will change depending on what was entered and submitted into the FIRST mysql query.

I'm trying to explain best as i can, my english is not perfect.
Thank you for any help anyone can offer.

GD Question

EvolutionFallen — Wed, 18 Nov 2009 19:35:50 GMT

Hi,
I'm using GD to dynamically draw a rectangle on an image I have of a map. I've got that part working fine.

Here's my question:
I know I need to set the headers of the page to
content-type: image/png
, otherwise I get a bunch of characters instead of the picture.
But what if I want to place this dynamically created image inside a PHP or HTML document so that I can place text and other data around it? Is there any way to do this, or does the GD-generated image have to stay on its own page?

Thanks
- EF

help with solr (java application) on GoDaddy php shared hosting

galaxygal — Wed, 18 Nov 2009 19:28:17 GMT

exec('java -version', $javaver);

print_r($javaver);
echo "
";

exec('java -jar start.jar', $output);

print_r($output);
echo "
";

exec('java -jar post.jar /home/content/j/a/n/jandtesting/html/solr/example/exampledocs/solr.xml /home/content/j/a/n/jandtesting/html/solr/example/exampledocs/monitor.xml', $output2);

print_r($output2);

I've never attempted anything with java before. I'm trying to get started on the solr tutorial -- a java based search engine based on Lucene. I don't think I've got this working at all because I probably didn't put the java commands in correctly above. I would really appreciate some guidance.

Galaxygal

dynamic videos with php

shishtawitch — Wed, 18 Nov 2009 17:29:32 GMT

how can i play videos at its place...........like in facebook........!!

i.e in facebook video thumb is given when we click on it it place at its place............!! how can i do it with jquery and php...........!!

Arrays and include function?

whitestream6 — Wed, 18 Nov 2009 16:55:15 GMT

I've just been learning arrays, and so far it's going well :)
This is my current PHP code:

$states = array ('MD' => 'Maryland', 'IL' => 'Illinois', 'MI' => 'Michigan');
$provinces = array ('QC' => 'Quebec', 'AB' => 'Alberta');
$abbr = array ('US' => $states, 'Canada' => $provinces);
$japanesemotors = array ('ToyotaCamry' => '');
?>
echo $abbr['US']['MI']; ?>
echo $abbr['Canada']['AB'];
?>
echo $abbr['japanesemotors']['ToyotaCamry'];
?>

However, I can't get a newline in between the arrays, so it produces the following:

MichiganAlberta

How do I get a new line to work in or in between the echo function?

Also, can you use the php include function in arrays like I used the HTML image function in my japanesemotors example above?

Thanks

A variety selection

rajeesh_rsn — Wed, 18 Nov 2009 15:36:32 GMT

Hai friends I need a simple (?) advice in one of my web page.

I had developed a web application in one of its page there are many number of checkboxes. Users are need to select single or multiple check boxes. But there is a limit for each users. ie If an user are only permitted to select 2 items, then I need to disable all the rest of checkboxes after he/she selected the 2. And also they can select another item , if they deselect the existing item.

Friends I am little bit confused and wondered how to do this. I am using PHP for development.

Please help me.
Thanks for your valuable time
Rajeesh

why ob_start()

veledrom — Wed, 18 Nov 2009 15:18:03 GMT

Hi,

I read this ob_start() but want a bit cleaner explanation.
why we use it, should we use it, what happens if we don't?

I have never used it and won't use it until I understand it is best practise.

Thanks in advance

Help Me Out!!!

ym_chaitu — Wed, 18 Nov 2009 13:32:10 GMT

include("access.php");
mysql_select_db($dbname);
$user="ym_chaitu";
//$e=mysql_query("select email from userlogin where username='$user'");
//$email=mysql_query($e,0);
$query = mysql_query("SELECT username,password FROM userlogin WHERE username = '$user'") or die(mysql_error());
$data = mysql_result($query);
echo $data;
?>

this is my code,,when i am using it out, it is giving me an error
Warning: Wrong parameter count for mysql_result() in C:\Program Files\xampp\htdocs\chaitu\magpierss\test.php on line 8

can any one let me know where an i wrong

how to make a online game web site

hno — Wed, 18 Nov 2009 13:24:43 GMT

HI
i know php/mysql and javascript well and I've made some web site .

now , I want to make a online game web site that it has two type of games . One type are simple games like BACKGAMMON or chess

another type are multiplay games . I have installed Arcade.Script.v1.2.B but it didn't has any game .

can any one help me to make a online game web site .
i've searched alot in the net but i couldn't find any good information about it . where I can get more information about the scripts and other game systems ?

I asked lots of question, please forgive me

thanks very much

How to insert csv file data to mysql table selected colum

sandipan.rcciit — Wed, 18 Nov 2009 12:53:31 GMT

hi,
i want to make a program where the csv file directly insert into the mysql database table.

i found the code:

include 'mysql-connect.php';
$rec=0;
$handle = fopen ('datafile1.csv', 'r');
while (($data = fgetcsv($handle, 1000, ',', '"')) !== FALSE)
{
$rec++;
if($rec==1)
{
continue;
}
else
{
$query = "INSERT INTO Book_details VALUES ('". implode("','", $data)."')";
$query = @mysql_query($query);
}
}

?>

it working fine .

but i have to face problem when i specify the columns in the mysql table like

while (($data = fgetcsv($handle, 1000, ',', '"')) !== FALSE)
{
$query = "INSERT INTO Book_details(idt_no,book_name,author_name,publisher_name,condition,condition_note,price,cur,quantity) VALUES ('". implode("','", $data)."')";
$query = @mysql_query($query);
}
no value is insert in the data base???

mention that database have 12 columns and csv have 9.
i have to insert all 9 to selected 9 columns in the database.
plz help me....

find the url someone entered

lifeworks — Wed, 18 Nov 2009 10:54:08 GMT

Hi

Im setting up a news distribution system... sort of... i want to record everyone who downloads the news articles... so ive blocked direct linking to the pdf files using an htaccess file.

my htaccess file redirects people to a page which captures where they came from ( for interests sake) and then tells them they have tried to access a file without authorization... ie, without going through my website and being 'counted'...

so now I want to find the url they typed in to access that file directly, so that i can provide a link to it, this time through my website, and thus give them access but also be able to 'count' them and provide accurate analytics on viewership...

how do i find that url they originally typed in? I currently collect the referer_url but dont know if I can get the one they typed in...?!

Thanks lworks

virus in hosting server

praveen_dusari — Wed, 18 Nov 2009 08:43:46 GMT

hi all,
i have downloaded my site from ftp to make changes there is a virus in that server my sir told me to clear that and upload.
In the source code i found a line which i thought is a virus containing a trojen program
i deleted that line in dreamweaver and exectuded locally but line is reappearing in code when in viewed a page source code how come this is possible

i thought of pasting that line which is a script include to another site but i thought it may infect this site too..

any ideas??

adding cron job with php ajax

shishtawitch — Wed, 18 Nov 2009 07:55:06 GMT

hi, my problem is that,
i want on my site, that when a user uploads a video on my site, my script get the uploaded video, and let the user what he was doing, and process that video behind the scences with php and ffmpeg, and displays it when it is ready,........lik in face book.........!! how can i do that..........!!
i am able to convert videos, fetching thumbs, and duration and storing to database but i know the direct process, now i want the behind the scenes process..............

Thanks in advance

Showing DB data in an order

kiranhg.2008 — Wed, 18 Nov 2009 07:40:31 GMT

I want to display records from database in this order

1 2 3
4 5 6
........

or

1 4 ....
2 5 ...
3 6.....

pls can anybody help me ........

Type
Preferred Schedule Date
Preferred Schedule Time
Preferred Location
Name
Tel
Email
Member No.
	'problem here I want to put another e-mail 'depending on what option the user choose 'from above selection