Webmaster-Talk.com - PHP Forum

Using Advanced DHTML Popup / Form In pop up / submit action

csads — Fri, 20 Nov 2009 22:00:47 GMT

Advanced DHTML Popup

http://www.dpopup.com/dhtml-popup-examples.html

I am using there pop up script to display a form , very similar to what they have on the page above where it pops up on the bottom.

When I submit the form I want it to post the data to the DB but also stay on that same window and say thank you , blah blah you can now close this window.

But its not going that, How can I do it how they have it on their thing ? where when you hit submit it loads on that same pop up window.

PS. I also tried to close on submit but that does not work

Thanks for the help

HTML Code:

"post" action="register2.php" onsubmit="top.close();">

  Name
"text" name="name" maxlength="20" />


  Email
"text" name="email" />


  "submit" input type="submit" value="Submit Me" />

My PHP

PHP Code:


		
			
// register2.php  

include("dbconnect.php");  

$errors = "";  

if (!isset($_POST['name']))  

$errors .= "Please provide your name. 
";  

if (!isset($_POST['email']))  

$errors .= "Please provide an email address. 
";  

if ($errors == "") {  

mysql_query("INSERT INTO user_list VALUES(  

'',  

'".addslashes($_POST['name'])."',  

'".addslashes($_POST['email'])."',  

'".time()."'  

)") or die(mysql_error());  

echo "Registration Successful!";  

} else {  

echo $errors."Please go back and try again.";  

}  

?>

a little help please

rober7 — Fri, 20 Nov 2009 11:44:59 GMT

i have a wordpress mu script installed and i have global admin bar ... but i want to add some commands after login form ( mynconnect.com )
i manage to add but i didn`t manage to alignment them
here is the code

Code:





 

  

   

   

            

   

   

   

            Remember Me

   


Get" target="_blank">http://mynconnect.com/wp-signup.php">Get a BlogRandom" target="_blank">http://mynconnect.com/?random">Random blog

   


can somebody help me?

and i want to add and a link to home page named Main Blog



Is there any way to do this in PHP (or with a combination of JS)?
yangyang — Fri, 20 Nov 2009 03:26:40 GMT
There's a login form on page A: http://www.example.com/A.html



The 'action' attribute of which is: action="/B.html"



So when someone logs in with the form on A.html, the data will be submitted to / visitor redirected to B.html. 



Now what I want is: there's an  on /C.html, framing B.html, is there any way so that when someone logs in with the form on A.html, the visitor is redirected to C.html and the login details is submitted to B.html that's framed on C.html in the ? So after the person logs in from A.html, he arrives at C.html with the actual CP dashboard framed in an .



I have absolutely no clue in achieving this. Maybe the form will be submitted to C.html first and C.html submits the login details to B.html (framed in C.html) via JavaScript? How?




Please Help with error!
DrVPSHosting — Fri, 20 Nov 2009 03:14:26 GMT
I am using a wordpress photo gallery plugin and I am receiving the following error when I upload a photo.



Warning: getimagesize() [function.getimagesize]: Filename cannot be empty in /home/******/public_html/alr/wp-content/plugins/wp-photo-album/wppa.php on line 651







The .php file info is below.


	PHP Code:
	
		
		
		
			
    // check if thumbs dir exists 
    if (!is_dir($wppa_dir . '/thumbs')) {
        mkdir($wppa_dir . '/thumbs');
    }
    
    foreach ($_FILES as $file) {
[B][COLOR=Red]Line 651[/COLOR][/B]        if (getimagesize($file['tmp_name'])) {
            $ext = substr(strrchr($file['name'], "."), 1);
        
$query = "INSERT INTO " . PHOTO_TABLE . " (id, album, ext, name, description) VALUES (0, {$_POST['wppa-album']}, '$ext', '{$file['name']}', '')";
            $wpdb->query($query);
            //echo $query;
            $image_id = $wpdb->get_var("SELECT LAST_INSERT_ID()");
            
            $newimage = $wppa_dir . '/' . $image_id . '.' . $ext;
            copy($file['tmp_name'], $newimage);

            if (is_file ($newimage)) {
                $uploaded_a_file = TRUE;
                if (is_numeric(get_option('wppa_thumbsize'))) {
                    $thumbsize = get_option('wppa_thumbsize');
                } else {
                    $thumbsize = 130;
                }
                
                wppa_create_thumbnail($newimage, $thumbsize, '' );
            } 
        }
    }
    
if ($uploaded_a_file) { echo 'Photos Uploaded.
'; }

} 




		

		
		
	
Can someone please tell me how to fix this?




Need SESSION across folders
gdaniels — Fri, 20 Nov 2009 00:58:25 GMT
Hi, Noob here.  Been searching for help and guidance.  I had my web pages displaying properly when they were all in the same folder.  After I moved some pages into a new folder they do not display the correct information.  I believe this is related to SESSION.  I need to have the SESSION data available to files in different folders.  What is the proper way to do this?  I've check the manual and other sources, but ended up confused.  Thanks in advance.




Help me to create popup window for feedback button?
flek — Thu, 19 Nov 2009 19:35:13 GMT
Hi friends,



I could create feedback button ( on the right side fixed position ) on my blog. Its working fine too. But I would like to know how to create an asynchronous script for making the form with in the blog. I mean without navigating to other page. 



See the current button here - I had a twitter button too. http://newgenreseoblog.com



The code was just simple - url and image..

.




Problems with simple if statement/query
WebTraffic — Thu, 19 Nov 2009 19:33:46 GMT
I am trying to make a listings of products, based on category. I have been fighting with this script for the past 3 hours trying to get this to work and for some reason it is only pulling the products that do not have a category2

 


	PHP Code:
	
		
		
		
			
else if (isset($_GET['category1'])) { 
 
 $resultwithcat2 = mysql_query("SELECT * FROM products WHERE category1='$_GET[category1]'", $dbhandle);
 $resultnocat2 = mysql_query("SELECT * FROM products WHERE category1='$_GET[category1]' AND category2=''", $dbhandle);
 
 if (!empty($row[category2])) { 
  while ($row = mysql_fetch_array($resultwithcat2)) {   
 echo ".$row['category2']."\">".$row['category2']." in ".$row[category1]." WITH 2nd category of ".$row[category2]."
";
  } 
 } 
 
 echo "
";
 
 if (empty($row[category2])) {
  while ($row = mysql_fetch_array($resultnocat2)) { 
 echo ".$row['productid']."\">".$row['productname']." in ".$row[category1]." NO 2nd category 
";
 }
 } 
 
} 




		
		
		
	
 

Breaking this code down, I think the problem lies somewhere within here:

 


	PHP Code:
	
		
		
		
			
 
 $resultwithcat2 = mysql_query("SELECT * FROM products WHERE category1='$_GET[category1]'", $dbhandle);
 
 
 if (!empty($row[category2])) { 
  while ($row = mysql_fetch_array($resultwithcat2)) {   
 echo ".$row['category2']."\">".$row['category2']." in ".$row[category1]." WITH 2nd category of ".$row[category2]."
";
  } 
 } 




		
		
		
	
Either something is wrong with my query or something is wrong with my php. I can't, for the life of me, figure out what is wrong with it. Like I said, it is pulling the results without a category2 properly. I want it to take the products with a category2 and list them at the top.

 

Note: The page with the problem can be found here: http://hvacdirect.us/products.php

Note: I have been testing in Test Category 4




Can someone tell me what this means?
Physicsguy — Wed, 18 Nov 2009 22:43:54 GMT
Hello,



While surfing to find an answer to yet another one of my problems, I've found a working solution; this:




	PHP Code:
	
		
		
		
			
preg_match("/\[\d+](.*)\[\d+]/", $text, $matches); 




		
		
		
	
But I have no idea what the "/\[\d+](.*)\[\d+]/" is.



I've tried deleting some things, but I either get an error or it doesn't work.



What does it mean?  Thanks :)




Store PHP in MySQL?
WebTraffic — Wed, 18 Nov 2009 19:39:23 GMT
I know that you are able to put html in a database... 

 

I am trying to put php in my database so that I can pull php scripts from my database. Is it possible to do this?

 

Example... when I add This is a test to a table in my database, the website pulls it just fine. However, if I put echo "This is a test"; in my database it will not pull it.

 

I need to put php inside my database :(




Site Setup
RiverAce — Wed, 18 Nov 2009 06:15:12 GMT
Hey Guys,



I am pretty new to the PHP world and am looking for some guidance in building a certain type of site.



I wish to create a site for my work colleagues where they can simply slick on a button which then copies proformas, text etc from a data base or word document.



Of course their would be a different button for each proforma etc.



Does anyone have tips or ideas on scripts that would allow such functionality.



Thanks In Advance :)




List Folders Only
sith717 — Wed, 18 Nov 2009 01:06:14 GMT
I would like to only show folders, not the files.



It is showing me files and folders.



     PHP Code:

                             


	PHP Code:
	
		
		
		
			
function populateDropdown(){ 
$path = glob("/home/bucket/public_html/*"); //the double \\ is not a typo you 
//have to escape it 
//if the path cannot be found 
if(!($path)){ 
echo("The path cannot be found"); 
return; 
}//if 

//the path is valid 
else{ 
foreach($path as $i){ 

echo("$i"); 

}//foreach 
}//else 
}//populateDropdown 

?>


		
		
		
	

	Code:
	
                





Stupid If Statement.  Should work, but it doesn't...
Physicsguy — Tue, 17 Nov 2009 22:24:11 GMT
Hi all,



I've made an incredibly simple if statement.  All it does is check if a URL parameter is a certain value, and according to that, display certain content.




	PHP Code:
	
		
		
		
			
$currentURL = "/userreview.php?reviewID=$reviewID";
$CommentingStatus = $_GET["comments"];


  if ($CommentingStatus = "on") {
    echo "Turn Off Comments"; 
  }
  else if ($CommentingStatus = "off") {
    echo "Turn On Comments"; 
  }   
  else {
    echo "Parameter 'Comments' must be set to either 'on' or 'off'.";
  }

?>


		
		
		
	
I don't know why that won't work.  It always displays 'Turn Off Comments', even if comments are already off!



It's supposed to:



Check if 'comments' is on or off.

If the comments are off, ask to turn them on.

Else if the comments are on, ask to turn them off.



Simple?  Apparently not...?




How do I make this contact form secure?
gh05 — Tue, 17 Nov 2009 19:38:58 GMT
Hi, I've heard that it is important to make a contact form secure to avoid spam attacks etc but have no clue how to do it really. Have found some quite old tutorials but think they may be out of date. It took me long enough to get the contact form working so I don't know where to start with making it secure. Are there any simple lines of code that I can add to make it more secure from attacks? 

 

My code is below. Any help much appreciated.

 

 

Code:


	Code:
	

Email the site
If you have any comments or questions about the site then please feel free to send me an email. 
 Name: 

 
 Email:
 
 
 Your Comments: 
  
 
 
mailer.php:

 

 


	Code:
	

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

$to = "myemail.com"; 

$subject = "Feedback"; 

$name_field = $_POST['name']; 

$email_field = $_POST['email']; 

$message = $_POST['message']; 

$body = "From: $name_field\n E-Mail: $email_field\n Message:\n $message"; 

echo "Data has been submitted to $to!"; mail($to, $subject, $body); 

} 

else { echo "blarg!"; } ?>





Incrementing a database value not working!
alexjames01 — Tue, 17 Nov 2009 14:48:42 GMT
I am using a simple script to count clicks of a link... problem is that when it is supposed to increment the value of a table in the DB... it, well, doesn't. 



Here is the click.php:


	HTML Code:
	
    ...

        // get id and protect it

        $id = htmlspecialchars($_GET[id]);      

        // check db

        $get = mysql_fetch_assoc(mysql_query("SELECT * FROM `affiliates` WHERE `id` = '$id' LIMIT 1"));        

        // increment hits

        $insert = mysql_query("UPDATE `affiliates` SET `out` = 'out+1' WHERE `id` = '$id'");  



    break;

}

?>
It doesn't increment 'out' at all... and if i set the value of "out" to something other than 0 and call it, it defaults it back to 0.



What am i doing wrong? :confused:




cURL - pause transfer
Piotr — Tue, 17 Nov 2009 13:20:15 GMT
Hi,



I have a question about downloading web page using cURL. 

I am trying to parse a web page where I found javascript 











When browser reads the webpage it process javascript updateprogress. 

This causes the transfer to be paused for some time. 

After that script there is a table which contains data that I want to get. 



When the webpafe is displayed in web browser everything is fine. 

But when I read it using curl (no delay in transfer) table is empty. 



It looks that the server is still preparing data to display and it is not ready. 



I have a question - is there a way to suspend curl transfer ? 

I already tries write callbacks - and this only pause php script not the transfer. It looks that curl is getting the data in the background and without wait in the middle the data are not ready yet. 



I will appriciate any sugestions. 



Piotr




Using the PHP imap() function
Mteigers — Tue, 17 Nov 2009 09:54:43 GMT
Ok here's what I want to do.. I want to write a script that will automatically catch all emails and auto-respond based on what is in the content of the email... For example I know how to create auto-responders but they send the same email everytime.. I want a script that first off checks the email account (imap()) and then responds based on the user email... eventually I would like to turn my server into a text sending server sending texts to cellphones (I can do that already) but I want it so users can send in a question from their phone and the server will answer them back correctly.



Any thoughts on how to go about doing this?




Image Upload Script...
Brian07002 — Tue, 17 Nov 2009 02:04:25 GMT
I am using this script to upload image to the webserver, and works fine, but how can I store the images uploaded from this script into the db? I would like to echo the image back to the webpage from the database.



Sorry for posting this as I should be able to do this by now, but I have been away from db development for quite some time, so my memory has failed me in the trying attempt. :(



Thanks alot!




	PHP Code:
	
		
		
		
			
//define a maxim size for the uploaded images in Kb

 define ("MAX_SIZE","100"); 



//This function reads the extension of the file. It is used to determine if the file  is an image by checking the extension.

 function getExtension($str) {

         $i = strrpos($str,".");

         if (!$i) { return ""; }

         $l = strlen($str) - $i;

         $ext = substr($str,$i+1,$l);

         return $ext;

 }



//This variable is used as a flag. The value is initialized with 0 (meaning no error  found)  

//and it will be changed to 1 if an errro occures.  

//If the error occures the file will not be uploaded.

 $errors=0;

//checks if the form has been submitted

 if(isset($_POST['Submit'])) 

 {

     //reads the name of the file the user submitted for uploading

     $image=$_FILES['image']['name'];

     //if it is not empty

     if ($image) 

     {

     //get the original name of the file from the clients machine

         $filename = stripslashes($_FILES['image']['name']);

     //get the extension of the file in a lower case format

          $extension = getExtension($filename);

         $extension = strtolower($extension);

     //if it is not a known extension, we will suppose it is an error and will not  upload the file,  

    //otherwise we will do more tests

 if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif")) 

         {

        //print error message

             echo 'Unknown extension!
';

             $errors=1;

         }

         else

         {

//get the size of the image in bytes

 //$_FILES['image']['tmp_name'] is the temporary filename of the file

 //in which the uploaded file was stored on the server

 $size=filesize($_FILES['image']['tmp_name']);



//compare the size with the maxim size we defined and print error if bigger

if ($size > MAX_SIZE*1024)

{

    echo 'You have exceeded the size limit!
';

    $errors=1;

}



//we will give an unique name, for example the time in unix time format

$image_name=time().'.'.$extension;

//the new name will be containing the full path where will be stored (images folder)

$newname="http://www.webmaster-talk.com/images/".$image_name;

//we verify if the image has been uploaded, and print error instead

$copied = copy($_FILES['image']['tmp_name'], $newname);

if (!$copied) 

{

    echo 'Copy unsuccessfull!
';

    $errors=1;

}}}}



//If no errors registred, print the success message

 if(isset($_POST['Submit']) && !$errors) 

 {

     echo "File Uploaded Successfully! Try again!
";

 }



 ?>


		
		
		
	


And of course this to upload the files:

 


	Code:
	


 

 

         

         

 
        

 





Convert this code into a google like pagination
MyMarket — Sun, 15 Nov 2009 23:50:51 GMT
I have this RSS parsing code and it paginates , but only uses 'next' and 'previous' links instead of how google does it. I want it to read like this: first 1 2 3.... last




	Code:
	

require_once('simplepie.inc');

 

// Set your own configuration options as you see fit.

$feed = new SimplePie();

$feed->set_feed_url(array(

'http://feeds2.feedburner.com/MishsGlobalEconomicTrendAnalysis',

'http://feeds.feedburner.com/TheBigPicture',

'http://feeds2.feedburner.com/ChartsAndCoffee',

        'http://feeds.feedburner.com/typepad/tradeblogs/the_slope_of_hope_with_ti',

));

$success = $feed->init();







// Make sure the page is being served with the right headers.

$feed->handle_content_type();

 

// Set our paging values

$start = (isset($_GET['start']) && !empty($_GET['start'])) ? $_GET['start'] : 0; // Where do we start?

$length = (isset($_GET['length']) && !empty($_GET['length'])) ? $_GET['length'] : 5; // How many per page?

$max = $feed->get_item_quantity(); // Where do we end?

 

// When we end our PHP block, we want to make sure our DOCTYPE is on the top line to make 

// sure that the browser snaps into Standards Mode.

?>

 





SimplePie: Demo

 



 



 





   
   // If we have an error, display it.

   if ($feed->error())

   {

   echo '' . "\r\n";

   echo '' . htmlspecialchars($feed->error()) . "
\r\n";

   echo '
' . "\r\n";

   }

?>

 

   if ($success): ?>

      
   // get_items() will accept values from above.

   foreach($feed->get_items($start, $length) as $item):

$feed = $item->get_feed();

?>

 

         

 

            if ($item->get_permalink()) echo '. $item->get_permalink() . '">'; echo $item->get_title(true); if ($item->get_permalink()) echo ''; ?>


            

            Source: echo $feed->get_permalink(); ?>">echo $feed->get_title(); ?> | get_date('j M Y | g:i a'); ?>


 

         


 

      endforeach; ?>

   endif; ?>

 

   
   // Let's do our paging controls

$next = (int) $start + (int) $length;

$prev = (int) $start - (int) $length;

 

// Create the NEXT link

$nextlink = '. $next . '&length=' . $length . '">Next »';

   if ($next > $max)

   {

$nextlink = 'Next »';

   }

 

// Create the PREVIOUS link

$prevlink = '. $prev . '&length=' . $length . '">« Previous';

   if ($prev < 0 && (int) $start > 0)

   {

$prevlink = '. $length . '">« Previous';

   }

   else if ($prev < 0)

   {

$prevlink = '« Previous';

   }

 

// Normalize the numbering for humans

$begin = (int) $start + 1;

$end = ($next > $max) ? $max : $next;

?>

 

   Showing echo $begin; ?>–echo $end; ?> out of echo $max; ?> | echo $prevlink; ?> | echo $nextlink; ?> | echo '?start=' . $start . '&length=5'; ?>">5, echo '?start=' . $start . '&length=10'; ?>">10, or echo '?start=' . $start . '&length=20'; ?>">20 at a time.




 









string work
Skeddles — Sun, 15 Nov 2009 20:07:34 GMT
I'm trying to get information from filenames.

It loops through everything in the directory, now I just need it to chop them up.



The format:

number-name.ext



I need $number to equal everything before the first dash, and $name to equal everything after the dash until the last period. 



I've been trying a bunch of functions, but I can't get it quite right.



current code:


	PHP Code:
	
		
		
		
			
$handle = opendir('scans/3/');
while (false !== ($file = readdir($handle))){
  $extplace = strchr($file, ".");
  $number = substr($file,0,strpos($file, "-"));
  $name = strchr($file, "-");
  echo $number.'/'.$name.'';
} 




		
		
		
	
Currently it get's the number correctly, I just don't know how to do the name.



echo will be something like 

10/-name.jpg





EDIT:

nvm, I'm pretty sure this worked


	PHP Code:
	
		
		
		
			
  $name = strchr($file, "-");
  $name = substr($name, 1, strlen($name)-5); 




		
		
		
	





"dynamic" links
kcmartz — Sun, 15 Nov 2009 01:43:01 GMT
I would like, on my school site: http://hulk.osd.wednet.edu/~martzkc/ , to have the "Member Links" to only appear when logged in (still making login/reg PHP file), and then, when NOT logged in, you don't see it, you see: "Log In!".



EX:

(LOGIN!):confused:

VVVVVV | [Then when logged in, change to:]:confused:

(Member Links):confused:



You know what I mean?




How to calculate X days moving average.
rcajht — Sun, 15 Nov 2009 01:26:27 GMT
Anybody knows How to easily calculate X days moving average for a 365days data.  any source available?




Help to sort folders alphabetically
100tral — Sat, 14 Nov 2009 16:10:10 GMT
hi,

in this code "Virtual Directories" and "Files" are sort alphabetically, but i don't know how to sort "Non Virtual Directories"  ???

Thanks for your help and sorry for my bad english !




	Code:
	
        // For Virtual Directories

        if($path == '' || $path == '/'){



                $query = sprintf('select * from %spermissions inner join %sbins on %spermissions.binid=%sbins.id where userid="%s" and %sbins.name ="%s" order by display',

                                                $GLOBALS['tablePrefix'],

                                                $GLOBALS['tablePrefix'],

                                                $GLOBALS['tablePrefix'],

                                                $GLOBALS['tablePrefix'],

                                                $_SESSION['userid'],

                                                $GLOBALS['tablePrefix'],

                                                $_SESSION['user']);

                                                

                $result = mysql_query($query,$database) or die( error('Get Folder query failed') );

                

                while($bins = mysql_fetch_assoc($result)) {

                        $listing[] = array(  displayname => $bins['display'],

                                                                                scheme => $bins['scheme'],

                                                                                type => "directory",

                                                                                name => $bins['name'],

                                                                                path => '/'. $bins['name'],

                                                                                virtual => "true" );

                }                                

                        

                $query = sprintf('select * from %spermissions inner join %sbins on %spermissions.binid=%sbins.id where userid="%s" and %sbins.name !="%s" order by display',

                                                $GLOBALS['tablePrefix'],

                                                $GLOBALS['tablePrefix'],

                                                $GLOBALS['tablePrefix'],

                                                $GLOBALS['tablePrefix'],

                                                $_SESSION['userid'],

                                                $GLOBALS['tablePrefix'],

                                                $_SESSION['user']);

                                                

                $result = mysql_query($query, $database) or die( error('Get Folder query failed') );

                $vdcount = mysql_num_rows($result);

                

                switch(true) {

                        case ($vdcount >= 1):

                                $virtual = "closed";

                                break;

                        case ($vdcount == 1):

                                $virtual = "true";

                                break;

                        default :

                                $virtual = "false";

                }

                

                if($vdcount > 0)

                        while($bins = mysql_fetch_assoc($result)){

                                $listing[] = array(  displayname => $bins['display'],

                                                                                        scheme => $bins['scheme'],

                                                                                        type => "directory",

                                                                                        name => $bins['name'],

                                                                                        path => '/'. $bins['name'],

                                                                                        virtual => $virtual );

                        }

                        

                echo $json->encode($listing);

                exit;

        }





        // Non Virtual Directories

        if( getUserAuth('view', $path) ){

                logAction('list',$path);

                $fullpath = getUserPath($path).$path;

                databaseSync($fullpath,$path);

                

                // Directories

                if (is_dir($fullpath)) {

                        if ($dh = opendir($fullpath)) {

                           while (($file = readdir($dh)) !== false) {

                             if(substr($file,0,1) != '.' && is_dir($fullpath . '/' . $file)) {

                                                $listing[] = array( 

                                                                        type => "directory", 

                                                                        name => $file, 

                                                                        path => $path .'/'. $file );

                                  }

                           }

                           closedir($dh);

                        }

                }

                else error("directory doesnt exist $fullpath");



                // Files

                $query = sprintf('select *,date_format(`date`,"%s") as `dateformatted` from %sfilesystem where path="%s" and status="%s" order by `filename',

                                                                $dateFormat,

                                                                $GLOBALS['tablePrefix'],

                                                                $fullpath,

                                                                "found" );

                                                                

                $result = mysql_query($query,$database) or die( error('Get Folder query failed') );

                while($files = mysql_fetch_assoc($result)) {

                        $listing[] = array(        type => "file",

                                                                                name => $files['filename'],

                                                                                date => $files['dateformatted'],

                                                                                id => $files['id'] );

                }

              

        }

        else error("Access Denied $path");

        

        echo $json->encode($listing);

        exit;

}



	

	

	

	

	
		
			Attached Images
			
			
	
	sort.jpg (14.1 KB)

			
			
	

	

	



Add Another PHP...  "URL Thing" To The Current One?
Physicsguy — Fri, 13 Nov 2009 20:40:26 GMT
I don't know what they're called, but here's an example:



http://www.example.com/page.php?whatever=something



The bold stuff.  Now I have a script that is on a page with the URL as:



http://www.pgreviews.com/userreview.php?reviewID=2



(don't go there, it's not fully functionable yet ;))



And on that page, I have a script that sets ?comments to "on".

So the whole URL should be:





http://www.pgreviews.com/userreview....=2&comments=on



Right?



It doesn't work for me.



It just takes me back to userreview.php?comments=on.



How can I get it so that it adds it to the one already there, keeping reviewID as whatever it is?



Thanks!  :)




need HELP
wayz1229 — Fri, 13 Nov 2009 17:21:20 GMT
can anyone teach me how to do loop for the script below.. thanks in advance..

 


	Code:
	

require_once('config.php');

 

 $aid1=$_POST['Question-1'];

 $aid2=$_POST['Question-2'];

 $aid3=$_POST['Question-3'];

 $aid4=$_POST['Question-4'];

 $aid5=$_POST['Question-5'];

 $aid6=$_POST['Question-6'];

 $aid7=$_POST['Question-7'];

 $aid8=$_POST['Question-8'];

 $aid9=$_POST['Question-9'];

 $aid10=$_POST['Question-10'];

 

 $qid1=$_POST['qid1'];

 $qid2=$_POST['qid2'];

 $qid3=$_POST['qid3'];

 $qid4=$_POST['qid4'];

 $qid5=$_POST['qid5'];

 $qid6=$_POST['qid6'];

 $qid7=$_POST['qid7'];

 $qid8=$_POST['qid8'];

 $qid9=$_POST['qid9'];

 $qid10=$_POST['qid10'];

 

 

    // update vote counter

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid1' AND qid = '$qid1'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid2' AND qid = '$qid2'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid3' AND qid = '$qid3'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid4' AND qid = '$qid4'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid5' AND qid = '$qid5'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid6' AND qid = '$qid6'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid7' AND qid = '$qid7'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid8' AND qid = '$qid8'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid9' AND qid = '$qid9'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

 $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid10' AND qid = '$qid10'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

    // close connection

    mysql_close();

?>





Is it possible to auto-direct users to a page depending on their geographic location?
jpf566 — Fri, 13 Nov 2009 14:53:49 GMT
Hey guys, I�m taking care of a website for a  company that has locations in two general locations (The Philadelphia/NJ area and the DC/VA/MD area) I would like it so when the user clicks �Sales & Events� they are directed to the sales & events at the location they are closest to (Either the Philly/NJ or the DC,VA,MD area) Is there any way to effectively do this or will I need to create some type of gateway page so they can choose their location? I�m sorry if this is not in the right part of the Forum but if this is possible, I don�t know what type of scripting would be used� Thanks for any and all help!





Jon




Select based on radius help
gdaniels — Fri, 13 Nov 2009 00:50:12 GMT
Please help.  I am trying to select records from a MySQL database table based on a radius.  Users enter an address and a radius in a form and are received in $_POST.  I can successfully determine the latitude and longitude of the submitted address.  The variables are $lat1 and $long1, and the radius is $radius.   The database table has columns named "lat" and "long" for the latitude and longitude of each record.  I can calculate the distance between to sets of latitudes and longitudes successfully using the code below.   




	PHP Code:
	
		
		
		
			
$distance = (3958*3.1415926*sqrt(('$lat1'-lat)*('$lat1'-lat) + cos('$lat1'/57.29578)*cos(lat/57.29578)*('$long1'-long)*('$long1'-long))/180) 




		
		
		
	
My existing code below works:




	PHP Code:
	
		
		
		
			
$resultsrchdate = "SELECT date FROM wamuexp where date >= '$date1' && date <= '$date2' && state = '$selectstate' ";
$sql_resultsdate = mysql_query($resultsrchdate,$dbc); 




		
		
		
	
What I need to do is somehow incorporate the formula for calculating distance into the SELECT statement of my existing code, or a loop might be needed, so only records that are less than or equal to the radius are returned.  Thanks in advance.




307 Redirects
wayfarer07 — Thu, 12 Nov 2009 23:36:11 GMT
You've all heard of 301 and 302 redirects, but have you ever heard of a 307?  I hadn't until today: Cross Domain Post Redirects.



I stumbled on this today when reading headers and session security, though it is only indirectly related to security.




code to display only certain things from mysql
bswinnerton — Thu, 12 Nov 2009 18:32:48 GMT
Hey everyone,



I'm new to the forum (as well as php), and I'm looking for a bit of help on a blog-like solution I'm trying to build up. On my front page I have three columns (technology, music, and movies) and I would like to have the php pull the content out of the mysql database and display it on my website.. Which I've been able to successfully do. 



However I have a field in my mysql database called disclude_categories which is numeric and what I would like to have is when it is set to 1 it doesn't show up on my front page. I thought that maybe I could include it on my while loop, but can't seem to get it to work.



Here's the code that I have so far:




	Code:
	
mysql_connect($host,$user,$pass) or die("ERROR:".mysql_error());

mysql_select_db($database) or die("ERROR DB:".mysql_error());

$query = "select * from blog WHERE categories='Technology' ORDER BY date DESC";

$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {         

            echo $row['content'];                                                                        }





Need advice for building a script...
alexjames01 — Thu, 12 Nov 2009 15:13:54 GMT
Alright, I have a client who needs a website that allows users to get a unique URL where they can "login" (it would be better if they didnt have to actually login and just be "logged in" by going to the URL) and see certain stats. The stats will be who they have referred to sign up. They want to be able to allow the user to track everyone they signed up.



Pretty much like an affiliate program but without any money involved (it's for a cause).



They also want to do some other things like integrate googlemaps and so on.



My question is, is there a script out there or a tutorial out there to help me get a jump start on this? I'm not advanced in php and this thing doesn't have to be too extensive. I just need the above functionality.




What script to make
Waizujin — Thu, 12 Nov 2009 04:04:04 GMT
Okay. So I am interested in making an open source script coded in PHP. So let me know, what do you think I should make that you would use? Feel free to post examples of scripts like it and let me know what you would want in it to make it different than the others.




emailing a sql error
robsmith — Wed, 11 Nov 2009 18:50:09 GMT
Does anybody know how to send a sql error via email? 



I know you can put OR DIE (), but that only seems to print it out.



I want to execute an email script if it fails...




Looking for a page counter that is a jpeg link,(dont know whats it called)
qwan — Wed, 11 Nov 2009 13:05:04 GMT
I was trying google for jpeg page counter but could not find any results.

I really dont know what its called so let me explain what I am looking for.

I am sure many of you must have heard of it, I think I just dont know the exact name.

Basically is is a page counter.

It will be in form of a link http://www.pagecounter/pagecounter.jpeg



Normally a page counter will need you to add some javascript or php code into the page.

but on blogs that do not allow that, but allow images I think this can be very effective to get the number of hits on that page.



I had see this long ago in  yahoo360(now closed). As yahoo did not allow addition of scripts or javascript to their posts, but allowed images.

Many posters would add a link.

ofcourse if you refreshed the page twice it would show up on the counter.

But a good way to get approximate hits.



Also will this work in emailer/newsletters.

Thanks




php file uploading problem ..???
ED!T — Wed, 11 Nov 2009 12:22:06 GMT
I have tried to upload a file using php. The code was  

-uploadfile.php-




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

include("form_upload.inc");

}

else{

if($_FILES['pix']['temp_name']=="none"){

echo "Files didn't successfully uploaded.

";

include("form_upload.inc");

exit();

}

if(!ereg("image",$_FILES['pix']['type'])){

echo "File is not a picture

";

include("form_upload.inc");

exit();

}

else{

$destination="F:/Installed\/Xampp/xampp/htdocs/test/upload".$_FILES['pix']['name'];

$temp_file=$_FILES['pix']['name'];

move_uploaded_files($temp_file,$destination);

echo " file uploaded successfully

{$_FILES['pix']['name']}

({$_FILES['pix']['size']})
";

}

}



?>



And I create an interface in an include file call 'form_upload.inc'





File Upload



Enter the name of the picture



action="uploadFile.php method=POST">






value="Upload Picture">









interface is working but uploaded image is not at the particular destination, "F:/Installed\/Xampp/xampp/htdocs/test/upload".

I have set "upload_tmp_dir=" in php.ini to the destination address.



but when I upload "object not found" error occurred... 



PLEASE HELP ME ......!!!!!!!!!!




Form action
josil — Tue, 10 Nov 2009 23:30:03 GMT
Hi

 

Can someone help me here?

 

For example:

 

In  mywebsite.com, I must select a country "spain" (websitespain.es) and choose a certain product with price between 100 euros and 200 euros that must open that range of product in that websitespain.es in other window.

 

I did this but does not work.

 




  
     

     

     

         
$array_countries = array(

  "Finland",

  "France",

  "Ireland",

  "Italy",

  "Liechtenstein",

  "Luxembourg",

  "Spain",

   );

   

   ?>

     

      



















       
         

       
echo 'Choose a country:
'; 

?>


 
 
  
  
  
       

 

    Price range between:


      
       
        
                 

          € 

             and  €

            
          
       
       

     
    
   
  

   
    
     




After Login go back to original Page.
sith717 — Tue, 10 Nov 2009 22:59:00 GMT
I have this script, its a login script. Currently after logging in and checking the login it goes to accounts.php



Goes on top of the webpage:


	PHP Code:
	
		
		
		
			
session_start();
if(!session_is_registered(myusername)){
header("location:accounts-login.php");
}
?>


		
		
		
	
Form:


	PHP Code:
	
		
		
		
			
<form autocomplete="off" id="form" method="post" action="checklogin.php">
<h1>Login Formh1>
<p>Please log in to the admin area to view logged accounts.p>

<label>Username
<span class="small">Min. size 6 charsspan>
label>
<input name="myusername" type="text" id="myusername" size="20" />


<label>Password
<span class="small">Min. size 6 charsspan>
label>
<input name="mypassword" type="password" id="mypassword" size="20" />

<button name="submitBtn" type="submit">button>
<div class="spacer">div>

form> 




		
		
		
	
checklogin.php


	PHP Code:
	
		
		
		
			
require "inc/config.php";
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM `admin` WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1)
{
// Register $myusername, $mypassword and redirect to file "accounts.php"
session_register("myusername");
session_register("mypassword");
header("location:accounts.php");
}
else 
{
header('Location:accounts-login.php');
}
?>


		
		
		
	
Lets say I was at contact.php, and I had no session, it would redirect me to accounts-login.php 



after I login it takes me to accounts.php.



Accounts.php is like the index of the folder.



What I need is for it to take me back to the page I was viewing before.



Kind of like in vbulletin, if your viewing a thread and ur not logged in, when u login it takes u back to the thread. 



Is that possible?




Writing multiple lines of text to a gif file with PHP
exec-qt — Mon, 09 Nov 2009 23:37:22 GMT
Hello fellow web/graphic designers,



Does anyone know how to write multiple lines of text into a gif file in PHP?

I know you can do this with one line.



Can you have something like but written to GIF format?



Line 1 of text

Line 2 of text

Line 3 of text



I'm fairly sure it's possible with PHP.. was wondering if any of you guys out there could help me out with this php script.



Thank you!




Curl or script not working.
sith717 — Mon, 09 Nov 2009 20:06:08 GMT
I have this script, it checks if an account information is valid or not, then says if it is or not.



It is not working for some reason.



By the way, make a free account here and check, I have my own private accounts to check with:



https://secure.runescape.com/m=create/index.ws



Or use this login information (DO NOT CHANGE THE PASSWORD TO BE AN *******)



Username: codingforums

Password: donotchange



THIS IS NOT ADVERTISING, THIS IS TO MAKE AN ACCOUNT TO SEE IF IT WORKS.





Edit $username and $password to check after.



If I put legit information into the $username and $password it says Invalid.



But if i put fake information into $username and $password it also says invalid, which is correct.




	PHP Code:
	
		
		
		
			
$username = "username";
$password = "password";

   $ch = curl_init();
   curl_setopt($ch, CURLOPT_URL, "https://weblogin.runescape.com/login.ws"); 
   curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
   curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
   curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
   curl_setopt($ch, CURLOPT_POST, 1);
   curl_setopt($ch, CURLOPT_POSTFIELDS, "username=".$username."&password=".$password."&dest=title.ws&mod=www&ssl=0");
   $pagedata = curl_exec($ch);
   curl_close($ch);
   
   
   
if (preg_match("/Your login was successful. You will shortly be redirected to your destination./i", $pagedata)) {

$valid = "Valid";
   
   } elseif (preg_match("/Login Failed - Invalid Username or Password/i", $pagedata)) {
    $valid = "Invalid";

} else {
$valid = "Cannot check! Too many invalid logins";
}
echo $valid; 
?>


		
		
		
	
Does anyone notice the problem?




PHP beginner
fooodin — Mon, 09 Nov 2009 13:37:48 GMT
Hi guys !!!

 

As a beginner in PHP i don't have much knowledge about it. Can anyone suggest me an amazing book from where it can be learnt in less time and with less effort? 

 

I want a beginner's guide to PHP.

 

Please suggest me the right guide.

 

<removed>




PHP image color change
phpcoder848 — Mon, 09 Nov 2009 08:03:54 GMT
Is it possible on php change pictures black colour to any other?

I need that user have possibility to choose colour and im wondering is it possible to do it on php, i have a hundred of pictures and i need at least 10 colours for each. all pictures are black and white like example.



if its not possible on php maybe you can suggest way how to doit?

thnx



example:






Need header logo to link back to website
TheDon — Mon, 09 Nov 2009 06:49:16 GMT
Hi peoples.

I have a blog page at http://www.thai-discovery.com/blogs/ which I want to have the header banner link back to http://www.thai-discovery.com

 

Below is the folling header php code


	PHP Code:
	
		
		
		
			
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

(); ?>>



('html_type'); ?>; charset=('charset'); ?>" />

<span style="color: #0000BB"><?php wp_title</span><span style="color: #007700">(</span><span style="color: #DD0000">''</span><span style="color: #007700">); </span><span style="color: #0000BB">?><?php </span><span style="color: #007700">if(</span><span style="color: #0000BB">wp_title</span><span style="color: #007700">(</span><span style="color: #DD0000">''</span><span style="color: #007700">, </span><span style="color: #0000BB">false</span><span style="color: #007700">)) { </span><span style="color: #0000BB">?></span> | <span style="color: #0000BB"><?php </span><span style="color: #007700">} </span><span style="color: #0000BB">?><?php bloginfo</span><span style="color: #007700">(</span><span style="color: #DD0000">'name'</span><span style="color: #007700">); </span><span style="color: #0000BB">?></span>

('version'); ?>" /> 

('stylesheet_url'); ?>" type="text/css" media="screen" />

('name'); ?> RSS Feed" href="('rss2_url'); ?>" />

('pingback_url'); ?>" />

(); ?>











echo get_option('home'); ?>/">('name'); ?>

('description'); ?>









if (is_home()): ?>

('url'); ?>">Home

('title_li=&depth=1'); ?>

else : ?>

('url'); ?>">Home

('title_li=&depth=1'); ?>

endif; ?>







		

		
		
	





Error with login script
sith717 — Sun, 08 Nov 2009 20:03:28 GMT
I am getting an error with my login script:



Error:


	Code:
	
Warning: Cannot modify header information - headers already sent by (output started at /home/bucket/public_html/inc/config.php:7) in /home/bucket/public_html/checklogin.php on line 24
checklogin.php


	PHP Code:
	
		
		
		
			
include "inc/config.php";
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM `admin` WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "accounts.php"
session_register("myusername");
session_register("mypassword");
header("location:accounts.php");
}
else 
{
header( 'Location: accounts-login.php' ) ;
}
?>


		
		
		
	
Does anyone spot the problem?




i cant login to my login php page
silverglade — Sun, 08 Nov 2009 14:47:19 GMT
hi, i cant login to my index page at http://oddnerdrum.info  here is the error i get on the page , any help greatly appreciated. thanks. derek





Warning:  mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /hermes/bosweb/web161/b1611/sl.brendansite2/public_html/index.php on line 6



Warning:  mysql_query() [function.mysql-query]: A link to the server could not be established in /hermes/bosweb/web161/b1611/sl.brendansite2/public_html/index.php on line 6



Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web161/b1611/sl.brendansite2/public_html/index.php on line 7



Warning:  session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /hermes/bosweb/web161/b1611/sl.brendansite2/public_html/index.php:6) in /hermes/bosweb/web161/b1611/sl.brendansite2/public_html/index.php on line 26




Adding dropdown pagination limit
sith717 — Sun, 08 Nov 2009 14:02:05 GMT
Im trying to add a pagination limit to my pagination script, so I can limit the amount.



I got this working when the page is loaded with a number at the end like:



http://www.example.com?limit=10



How  do I do it so it automatically sets the number to 5 when there is no variable?




	Code:
	













require_once("inc/config.php");

if (isset($_POST['del'])) 

{

  for ($count = 0;$count
    {

           $delete = $_POST[delchk][$count];

           $query = "DELETE FROM accounts WHERE id = '$delete'";

           $result = mysql_query($query);

           if (!$result) 

        {

            die("Error deleting accounts! Query: $query
Error: ".mysql_error());

        }

    }

}

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

if(mysql_num_rows($result) > 0)

{

  echo "


    

        

        

        

        

        

        

       

    

";

echo "";

$data = mysql_query("SELECT * FROM `accounts`") or die(mysql_error());

$rows = mysql_num_rows($data);
$page_rows = $_GET["limit"];

if(!isset($_GET['pagenum']))

{

$page = 1;

}

else

{

$page = (int) $_GET['pagenum'];

}

?>
I get this error when I try to load the page like: http://www.example.com


	Code:
	
Warning: Division by zero in /home/cherdak/public_html/accounts.php on line 310



Warning: Division by zero in /home/cherdak/public_html/accounts.php on line 311

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


but no error when I load the page like: http://www.example.com?limit=10



I made bold where the $_Get is.
nested foreach loop problem
wayz1229 — Sun, 08 Nov 2009 11:00:53 GMT
i need help with the code below.. the code does not get correct qid from table questions.

let say i enter 2 qtitle, and each qtitle has 3 atitle..

but once the data entered in database..

the error is like below:

 

(qid=1)qtitle1- i get 6 atitle (by right should be 3 atitle)

 

(qid=2)qtitle2- i get 12 atitle (by right should be 3 atitle)

 

anyone can help me to solve this problem.. i realy need some help.. the error is on the coding below..

 


	Code:
	

foreach ($_POST['questions'] as $q) {

        if (trim($q) != '') {

            $qtitles[] = $q;

        }

    }

 

foreach ($qtitles as $qtitle) {

        $query = "INSERT INTO questions (qtitle) VALUES ('$qtitle')";

        $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

 

    $qid = mysql_insert_id();

    unset($query);

    unset ($result);

 

foreach ($_POST['options'] as $o) {

        if (trim($o) != '') {

            $atitles[] = $o;

        }

    }

    foreach ($atitles as $atitle) {

        $query = "INSERT INTO answers (qid, atitle, acount) VALUES ('$qid', '$atitle', '0')";

        $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

    }

}

?>




need help-survey voting
wayz1229 — Sun, 08 Nov 2009 05:02:38 GMT
i'm a beginner and new to php. i'm having problem with survey script and voting function. can anyone please help me out.. the script only accept the last question's answer and update the database = acount+1.

 

script to display survey:




	Code:
	



echo "


Username Password Highscores Date IP Address Status Delete?












";



$query1 = "SELECT * FROM questions";

$result1 = mysql_query($query1)or die("ERROR: $query.".mysql_error());



$num_row=mysql_num_rows($result1);



$i=1;



while($i<$num_row){



while ($row1 = mysql_fetch_array($result1)) {



$qid = $row1['qid'];

$qtitle = $row1['qtitle'];



$query2 = "SELECT * FROM answers WHERE qid='$qid'";

$result2 = mysql_query($query2) or die("ERROR: $query.".mysql_error());



echo "

    

          ";

         

while ($row2 = mysql_fetch_array($result2)) {



$aid = $row2['aid'];

$atitle = $row2['atitle'];



echo "

    

          ";

}



echo "";

echo "
";

$i++;



}

}



echo "





".$i.". ".$qtitle."
".$atitle."




";



}

}

// close connection

mysql_close();



?>
 

voting script:


	Code:
	

if (isset($_COOKIE) && !empty($_COOKIE)) {

    if ($_COOKIE['lastpoll'] && $_COOKIE['lastpoll'] == $_POST['qid']) {

        echo '';

        echo '';

        exit();

    }

}

// set cookie

setCookie('lastpoll', $_POST['qid'], time() + 2592000);





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



    if (!isset($_POST['aid'])) {

                echo '';

                echo '';

    }

        else{

        

        require_once('config.php');

        

        $aid=$_POST['aid'];

        $qid=$_POST['qid'];

   

    // update vote counter

    $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid' AND qid = '$qid'";

    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());

        

        }



    // close connection

    mysql_close();





    // print success message    

        echo '';

        echo '';

}

else {

    echo '';

        echo '';

}



?>
please help... thanks in advance





How to use Session in php??
syaza — Sun, 08 Nov 2009 03:16:11 GMT
hai...please help me how to use session in php..I was create a page for register.In the register's page have NAMA and NOMBOR_ID..Now,i want to create the vote's page and in the vote's page have NOMBOR_ID,CALON and JURUSAN.I want to use the NOMBOR_ID has been register in the register's page only can vote...please help me how to do????




PHP mail() won't send to Gmail
werm82 — Sun, 08 Nov 2009 01:25:25 GMT
Has anyone else ever had this problem? I have a form that uses mail() to send form info to an email. It sends mail just fine to any email account I try except for my email domain that uses Google Apps. Does Gmail have something against HTML formatting from a php generated email?




Having trouble with SIMPLE PHP Contact form... HELP!
redline5th — Sun, 08 Nov 2009 01:14:40 GMT
Okay, so I am helping a non-profit company with their website. As of right now I've got a simple .php file sending the email to the owner. No database.



Right now I am in the testing phase.



Well, I get the success page when I fill it out and hit submit. But no E-mail.



I uploaded it to a different server and it worked GREAT... but in all of my fields it is chopping off one character.



1). What can I change to get the non-profit server to allow me to use the simple .php script to send an Email? Never had an issue with this script before, and like I said, it WORKS on a different server.



2). What would cause a php script to chop the last character off when it sends? Ex: Instead of "Test" I got "Tes".



Here's the PHP script:




	PHP Code:
	
		
		
		
			
// Receiving variables
@$pfw_ip= $_SERVER['REMOTE_ADDR'];
@$Send_product_literature = addslashes($_POST['Send_product_literature?']);
@$Send_company_literature = addslashes($_POST['Send_company_literature?']);
@$Have_a_salesperson_contact_me = addslashes($_POST['Have_a_salesperson_contact_me?']);
@$Name = addslashes($_POST['Name']);
@$Title = addslashes($_POST['Title']);
@$Company = addslashes($_POST['Company']);
@$Address = addslashes($_POST['Address']);
@$Phone = addslashes($_POST['Phone']);
@$Email = addslashes($_POST['Email']);

// Validation
//Sending Email to form owner
$pfw_header = "From: $Email\n"
  . "Reply-To: $Email\n";
$pfw_subject = "Online Information Request Form";
$pfw_email_to = "myemail@gmail.com";
$pfw_message = "Visitor's IP: $pfw_ip\n"
. "Send_product_literature: $Send_product_literature\n"
. "Send_company_literature: $Send_company_literature\n"
. "Have_a_salesperson_contact_me: $Have_a_salesperson_contact_me\n"
. "Name: $Name\n"
. "Title: $Title\n"
. "Company: $Company\n"
. "Address: $Address\n"
. "Phone: $Phone\n"
. "Email: $Email\n";
@mail($pfw_email_to, $pfw_subject ,$pfw_message ,$pfw_header ) ;

header("Location: ../success.php");

?>


		
		
		
	
Oh, and yeah, I'm kind of a newbie here. I do some non-profit work for schools and what not to help them along with what I can do to save them money.




Community - specific
MultiWeb — Sun, 08 Nov 2009 00:02:44 GMT
Hello :)



I'm looking after a social script, where the users can create a blog, where the admins can create a blog, webtv, write articels ....



I have tryed joomla and Boonex's dolphin, but that didn't worked out. I would like to get a script with most of these things, but if thats a problem. Then I will code the rest by myself.



Thanks :)




Update for every id
sith717 — Sat, 07 Nov 2009 18:57:07 GMT
I currently got this code, it updates the database when a form is submitted. It currently updates the row id 3 with this code:




	PHP Code:
	
		
		
		
			
$id = 3; 




		
		
		
	
and


	PHP Code:
	
		
		
		
			
   WHERE `id` = '".$id."' 




		
		
		
	
How do I do it so it automatically picks every single row that's there?




	PHP Code:
	
		
		
		
			
if (isset ($_POST['submit'])) // if the form was submitted, display their name
{
require_once ('inc/config.php');
$title = mysql_real_escape_string ($_POST['title']);
$url = mysql_real_escape_string ($_POST['url']);

$mainnewstitle = mysql_real_escape_string ($_POST['mainnewstitle']);
$mainnewsdate = mysql_real_escape_string ($_POST['mainnewsdate']);
$mainnewsimage = mysql_real_escape_string ($_POST['mainnewsimage']);
$mainnewsmessage = mysql_real_escape_string ($_POST['mainnewsmessage']);
$mainnewslink = mysql_real_escape_string ($_POST['mainnewslink']);

$firstnewstitle = mysql_real_escape_string ($_POST['firstnewstitle']);
$firstnewsdate = mysql_real_escape_string ($_POST['firstnewsdate']);
$firstnewsmessage = mysql_real_escape_string ($_POST['firstnewsmessage']);

$secondnewstitle = mysql_real_escape_string ($_POST['secondnewstitle']);
$secondnewsdate = mysql_real_escape_string ($_POST['secondnewsdate']);
$secondnewsmessage = mysql_real_escape_string ($_POST['secondnewsmessage']);

$thirdnewstitle = mysql_real_escape_string ($_POST['thirdnewstitle']);
$thirdnewsdate = mysql_real_escape_string ($_POST['thirdnewsdate']);
$thirdnewsmessage = mysql_real_escape_string ($_POST['thirdnewsmessage']);

$id = 3;  
$sql = mysql_query ("
   UPDATE `news` SET 
      `title` = '".$title."', 
      `url` = '".$url."',
 
      `mainnewstitle` = '".$mainnewstitle."',
      `mainnewsdate` = '".$mainnewsdate."',
      `mainnewsimage` = '".$mainnewsimage."',
      `mainnewsmessage` = '".$mainnewsmessage."',
      `mainnewslink` = '".$mainnewslink."',

      `firstnewstitle` = '".$firstnewstitle."',
      `firstnewsmessage` = '".$firstnewsmessage."',  
      `firstnewsdate` = '".$firstnewsdate."',
      
      `secondnewstitle` = '".$secondnewstitle."',
      `secondnewsmessage` = '".$secondnewsmessage."',      
      `secondnewsdate` = '".$secondnewsdate."',      

      `thirdnewstitle` = '".$thirdnewstitle."',
      `thirdnewsmessage` = '".$thirdnewsmessage."',
      `thirdnewsdate` = '".$thirdnewsdate."'    
   WHERE `id` = '".$id."'
")
OR die (mysql_error());
echo "Your website news have been updated. 
";
}

require_once ('inc/config.php');
$query = "SELECT * FROM `news`";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array ($result))
{
?>