Hot Scripts Forums - PHP http://www.hotscripts.com/forums/ en Sun, 22 Nov 2009 20:27:46 GMT vBulletin 60 http://cdn.hotscripts.com/forums/hsforum/misc/rss.jpg Hot Scripts Forums - PHP http://www.hotscripts.com/forums/ plz help me http://www.hotscripts.com/forums/php/55947-plz-help-me.html Sat, 21 Nov 2009 15:17:51 GMT hi i m new to php.can anybosy tell me how to use php with xmlpost. can anybosy giveme some example so that i can understand or give me any book suggestions. plz asap hi
i m new to php.can anybosy tell me how to use php with xmlpost.

can anybosy giveme some example so that i can understand or give me any book suggestions.

plz asap ]]> PHP riya123 http://www.hotscripts.com/forums/php/55947-plz-help-me.html PHP4 to PHP5 issue help http://www.hotscripts.com/forums/php/55942-php4-php5-issue-help.html Fri, 20 Nov 2009 21:19:04 GMT i have a page with a switch statement

on php4 i was able to put this line of code in the add bar "video.php?viewby=job&&job=AI-5254"

and now on php 5 that doesnt work im not recieving any errors

any suggestions? ]]> PHP tc325 http://www.hotscripts.com/forums/php/55942-php4-php5-issue-help.html <![CDATA[[SOLVED] Random Id From table]]> http://www.hotscripts.com/forums/php/55936-random-id-table.html Thu, 19 Nov 2009 23:12:18 GMT Heya guys ok i have a table in my db called room under the table i have roomid and z the roomid can be anything from 1 - 1000 but the z will be the same if its the same area. now what i wanna do is select from roomid where id=300 that will then give the z from that table in this case 3 so... Heya guys

ok i have a table in my db called room under the table i have roomid and z the roomid can be anything from 1 - 1000 but the z will be the same if its the same area. now what i wanna do is select from roomid where id=300 that will then give the z from that table in this case 3

so right now i have z=3 ,what i now wanna do is get all the roomid's where z=3 and choose a random one, and display it as a variable

How can i do that ?

Cheers
Mike ]]> PHP smithygotlost http://www.hotscripts.com/forums/php/55936-random-id-table.html Php Sum() http://www.hotscripts.com/forums/php/55924-php-sum.html Wed, 18 Nov 2009 20:31:31 GMT Heya Guys Im not sure im doing something wrong or whats happening, But im trying to get the total of the field points, when i run PHP: --------- select sum(points) from user --------- in the database i get the total perfectly but when i make Heya Guys

Im not sure im doing something wrong or whats happening, But im trying to get the total of the field points, when i run

PHP Code:
select sum(points) from user 
in the database i get the total perfectly but when i make

PHP Code:
$adminpoints = mysql_query("select sum(points) from user"); 
I get an Resource id #68 error

Am i doing something wrong ?

Cheers
Mike ]]> PHP smithygotlost http://www.hotscripts.com/forums/php/55924-php-sum.html file get contents http://www.hotscripts.com/forums/php/55920-file-get-contents.html Wed, 18 Nov 2009 04:38:50 GMT hi all

PHP Code:

<?php
$article = file_get_contents('http://www.domain.com/article_eng.html');
$qry="insert into article_data (article) values('$aricle')";
$result=mysql_query($qry);
?>
with this function i can crawl my html page and fetch its content and add in database.

but i would like to know that my html page has

1) article title
2) author name
3) description

i dont want any images or any other data like nav, header, footer.

so how will i fetch these 3 things separately.

vineet ]]> PHP vinpkl http://www.hotscripts.com/forums/php/55920-file-get-contents.html mysql table... how big is too big? http://www.hotscripts.com/forums/php/55916-mysql-table-how-big-too-big.html Wed, 18 Nov 2009 01:10:43 GMT I'm making an application where users can save their own quizzes onto the system. At the moment I have a 'questions' table that stores all the questions from all the quizzes and users.

I was wondering if this is the best way to do it? I imagine if every user has 100 questions on average submitted, with hundreds of users, the amount of rows in the single table will be huge eventually.

Will this cause performance problems? My alternative is to give every user there own table, but I was wondering if this is entirely necessary? Can mysql handle huge amount of rows without a problem? ]]> PHP mjjwatson http://www.hotscripts.com/forums/php/55916-mysql-table-how-big-too-big.html Blocking domains with preg_match? http://www.hotscripts.com/forums/php/55915-blocking-domains-preg_match.html Wed, 18 Nov 2009 01:04:48 GMT I've been toying with the idea of using explode() and a preg_match to disallow all emails from .ru domains and gawab.com from registering on my site due to the fact that they are mainly used by spammers/hackers and bots.

However, I must be doing something wrong with the preg_match (lines 87 to 92). I currently have the preg_match commented out because it causes the website to not pull up, it just shows a white background. If I comment out the preg_match it works fine. I've been experimenting with the preg_match in RegexBuddy but I still can't quite get it to work.

Also, the "echo $domain[1]" code is there as a debug so I could make sure that the explode was working properly.

For now I'm only trying to disallow all .ru domains but I'd like to add gawab.com to the list as well at some point.

php Code:
  1. <?php
  2. include('../includes/constants.php');
  3. ?>
  4. <!DOCTYPE html>
  5. <html lang="en">
  6. <head>
  7. <meta charset="utf-8">
  8. <script type="text/javascript">  
  9. var RecaptchaOptions = {  
  10.    theme : 'clean'  
  11. };  
  12. </script>
  13. <title>Welcome to my Website!</title>
  14. </head>
  15. <body>
  16. We are hard at work getting the site up and running! We are hoping to get running around December or January.
  17. If you would like us to notify you when we get setup fill out the form below with your name and email address.
  18. <?php
  19. require_once('../reCAPTCHA/recaptchalib.php');
  20.  
  21. // Keys from [url]http://recaptcha.net/api/getkey[/url].
  22. $publickey = "[deleted]";
  23. $privatekey = "[deleted]";
  24.  
  25. # the response from reCAPTCHA 
  26. $resp = null;
  27. # the error code from reCAPTCHA, if any 
  28. $error = null;
  29.  
  30.     if (isset($_POST&#91;'submitted'])) {
  31.         require_once('../includes/sanitize.php');
  32.         
  33.         //Sanitize data before validation
  34.         $c_fname = sanitize(3, 15, $_POST&#91;'first_name']);
  35.         $c_lname = sanitize(3, 25, $_POST&#91;'last_name']);
  36.         $c_email = sanitize(5, 60, $_POST&#91;'email']);
  37.         $c_email_2 = sanitize(5, 60, $_POST&#91;'email_2']);
  38.         
  39.         ////////////////////////////////////////////////////
  40.         // BotScout.com "BotBuster" check
  41.         require_once('../includes/BotScout.php');
  42.         ////////////////////////////////////////////////////
  43.  
  44.         $resp = recaptcha_check_answer ($privatekey,
  45.                                         $_SERVER&#91;"REMOTE_ADDR"],
  46.                                         $_POST&#91;"recaptcha_challenge_field"],
  47.                                         $_POST&#91;"recaptcha_response_field"]);
  48.  
  49.         if ($resp->is_valid) {
  50.         require_once(MYSQL);
  51.                 
  52.         //Validate the first name
  53.         $fResult = preg_match("/^[a-zA-Z\.]{1,15}/", $c_fname);
  54.         if (!$fResult) /* If it didn't match okay. */
  55.          return false;
  56.             
  57.         //Validate last name
  58.         $lResult = preg_match("/^[a-zA-Z\-.]{1,25}/", $c_lname);
  59.         if (!$lResult) /* If it didn't match okay. */
  60.           return false;
  61.         
  62.         //Is the email valid and not empty?
  63.         if (empty($c_email_2)) {
  64.             echo '<p>Please go back and enter your email address in both fields.</p>';
  65.             exit();
  66.         } elseif ($c_email !== $c_email_2) {
  67.             echo '<p>The email fields do not match. Please go back and confirm them again.</p>';
  68.             exit();
  69.         } else {
  70.             function isValidEmail( $c_email = null ) {
  71.             $eResult = preg_match( "/^ 
  72.             [\d\w\/+!=#|$?%{^&}*`'~-] 
  73.             [\d\w\/\.+!=#|$?%{^&}*`'~-]*@ 
  74.             [A-Z0-9] 
  75.             [A-Z0-9.-]{1,60} 
  76.             [A-Z0-9]\. 
  77.             [A-Z]{2,6}/", $c_email);
  78.             if (!$eResult) /* If it didn't match okay. */
  79.               return false;
  80.                 }
  81.         }
  82.             /* This code doesn't quite work yet....
  83.             $domain = explode('@', $c_email);
  84.             
  85.             echo $domain[1];
  87.             $dResult = preg_match("/^[A-Z0-9]{1,60}\.ru$/", $domain[1]);
  88.             if ($dResult)
  89.                 return false;
  90.             echo "<p>An error has occurred, please try again.</p>";
  91.             exit();
  92.             */
  93.         if (!empty($c_email) && $c_email == $c_email_2) {
  94.             $access = "SELECT Email FROM customers WHERE Email='$c_email'";
  95.             $r = mysqli_query($dbc, $access) or trigger_error("Query: $access\n<br />MySQL error: " . mysqli_error($dbc));
  96.         }
  97.         
  98.         //Insert information if email is unique:
  99.         if (mysqli_num_rows($r) == 0) {
  100.             $access = "INSERT INTO customers (Email, First, Last) VALUES ('$c_email', '$c_fname', '$c_lname')";
  101.             $r = mysqli_query($dbc, $access) or trigger_error("Query: $access\n<br />MySQL error: " . mysqli_error($dbc));
  102.         } elseif (mysqli_num_rows($r) == 1) {
  103.             echo "<p>Your address has previously been recorded. We will notify you at $c_email when we are up and running.</p>";
  104.         } else {
  105.             echo '<p>Your email address could not be recorded due to an error, please try again.</p>';
  106.         }
  107.         
  108.         //If user fails reCAPTCHA.
  109.         } else {
  110.              # set the error code so that we can display it
  111.              $error = $resp->error;
  112. } // End reCAPTCHA else.
  113. mysqli_close($dbc);
  114. } // End Submit IF.
  115. ?>
  116. <form action="" method="post">
  117. <fieldset>
  118. <p><b>First name:</b> <input type="text" name="first_name" size="20" maxlength="15" value="<?php if(isset($c_fname)) echo $c_fname; ?>" /></p>
  119. <p><b>Last name:</b> <input type="text" name="last_name" size="20" maxlength="25" value="<?php if(isset($c_lname)) echo $c_lname; ?>" /></p>
  120. <p><b>Email Address:</b> <input type="text" name="email" size="30" maxlength="60" value="<?php if(isset($c_email)) echo $c_email; ?>" /> (Required)</p>
  121. <p><b>Confirm email address:</b> <input type="text" name="email_2" size="30" maxlength="60" value="<?php if(isset($c_email_2)) echo $c_email_2; ?>" /> (Required)</p>
  122. <?php echo recaptcha_get_html($publickey, $error); ?>
  123.  
  124. <br />
  125. </fieldset>
  126. <div class="center"><input type="submit" name="submit" value="Register" /></div>
  127. <input type="hidden" name="submitted" value="TRUE" />
  128. </form>
  129. </body>
  130. </html>
]]> PHP PopSmith http://www.hotscripts.com/forums/php/55915-blocking-domains-preg_match.html pagination within a html table http://www.hotscripts.com/forums/php/55914-pagination-within-html-table.html Tue, 17 Nov 2009 22:24:45 GMT Hi, im trying to insert this code within a html script but the Prev 1 2 3 4 next is not displayed and also the DESC is to responding. Any Ideas?
PHP Code:
<?php

include ("connect.php");


// max display per page

$per_page = 50;

// get start variable

$start = $_GET ['start'];

// count record

$record_count = mysql_num_rows (mysql_query("SELECT * FROM flats ORDER BY date_posted DESC")); 

//count max pages

$max_pages = $record_count / $per_page; // may come out as a decimal

if (!$start)

  $start = 0;

// display data
$get = mysql_query("SELECT * FROM flats LIMIT $start, $per_page");
 
   while ($row = mysql_fetch_assoc($get))
   
 {
 
  // get data 

   $select= $row['type'];
   $title= $row['title'];
   $location= $row['location'];
  

    echo "<div><b>$title</b></div>";
    echo "<br>";
    echo "$select";
    echo "<br>";
    echo "$rent";
    echo "<br>";
    echo "$location";
  

}

// setup the prev and next variables

$prev = $start - $per_page; 

$next = $start + $per_page;

//show prev button

if (!($start<=0)) 

  echo " <a href='londonfc_flats.php?start=$prev'> << Prev </a> ";

//show page numbers

// set variable for first page

$i=1;

for ($x=0;$x<$record_count;$x=$x+$per_page)
{

 if ($start!=$x)
   
  echo " <a href='londonfc_flats.php?start=$x'>$i |</a> ";

else 
  echo " <a href='londonfc_flats.php?start=$x'><b> $i|</b></a> ";

$i++;

}

//show next button

 if (!($start>=$record_count-$per_page))
 echo " <a href='londonfc_flats.php?start=$next'> Next >></a> "; 


?>
]]> PHP balamberas http://www.hotscripts.com/forums/php/55914-pagination-within-html-table.html PHP replies http://www.hotscripts.com/forums/php/55912-php-replies.html Tue, 17 Nov 2009 21:34:46 GMT I'm currently building a site which requires users to post replies.

I would like it so it takes note of the line breaks that the user has posted.

Eg. When some posts this:
Code:
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec vel dolor metus.

Aenean consectetur, magna sit amet volutpat fermentum, eros magna tincidunt est, et ultricies ipsum turpis in sem.

Nunc blandit, diam dictum bibendum dapibus, ligula nisl porttitor est, non feugiat enim neque eu sem.
It'll go in the database like this:

Code:
Lorem ipsum dolor sit amet, consectetur
adipiscing elit. Donec vel dolor metus.
 Aenean consectetur, magna sit amet
volutpat fermentum, eros magna
tincidunt est, et ultricies ipsum turpis in
sem. Nunc blandit, diam dictum bibendum
dapibus, ligula nisl porttitor est, non feugiat
enim neque eu sem.
So when I try to return it like this:
PHP Code:
$row['content']; 
It'll show like it is in the database. How can I get it to take note of the line breaks? ]]> PHP SniperTowers http://www.hotscripts.com/forums/php/55912-php-replies.html php sms http://www.hotscripts.com/forums/php/55908-php-sms.html Tue, 17 Nov 2009 12:02:45 GMT hi how many messages(Max num) can we send at a time using php hi

how many messages(Max num) can we send at a time using php ]]> PHP hemi http://www.hotscripts.com/forums/php/55908-php-sms.html Script Name? http://www.hotscripts.com/forums/php/55907-script-name.html Tue, 17 Nov 2009 09:51:19 GMT Hi all,
what's the name a script (filter with one click) on the left side?
Dell Laptops / Notebooks: Colorful laptops, small laptops, light weight laptops, gaming laptops | Dell

Many thanks for any help! ]]> PHP MrBird http://www.hotscripts.com/forums/php/55907-script-name.html define issues, I think http://www.hotscripts.com/forums/php/55905-define-issues-i-think.html Tue, 17 Nov 2009 07:06:30 GMT Ive been looking at the code for like an hour and then even started over to see if I messed something up, but I am getting the same result, and thats nothing. Most these pages are stolen from scripts that I have made before, but the defines are something I have changed... index.php PHP:... Ive been looking at the code for like an hour and then even started over to see if I messed something up, but I am getting the same result, and thats nothing. Most these pages are stolen from scripts that I have made before, but the defines are something I have changed...

index.php
PHP Code:
<?PHP
session_start();
define('__sn', 1);
include "config.php";
$layout->head();
if(isset($_SESSION['UINFOSTAFF'])){
    echo "hello";
}else{
    echo "hello";
}
$layout->foot();
?>
config.php
PHP Code:
<?PHP
defined('__sn') or die();
define('__sn', 1);
$CONF['__THEME']="opening";
$MYSQL['__HOST']="localhost";
$MYSQL['__DBAS']="XXXXXXXX";
$MYSQL['__USER']="XXXXXXXX";
$MYSQL['__PASS']="XXXXXXXXXXXX";
$SITE['__NAME']="SoldiersNet";
$SITE['__MAINURL']="http://soldiersnet.net/"; //Must include trailing "/"
###############################
# DO NOT EDIT BELOW THIS LINE #
###############################
$CONF['__VERSION']="1.0a";
include "includes/db.php";
    $db=new db($MYSQL['__HOST'],$MYSQL['__USER'],$MYSQL['__PASS'],$MYSQL['__DBAS']);
    $db->newconn();
include "includes/layout.php";
    $layout=new layout($db);
include "includes/functions.php";
    $user=new user($db);
    $app=new app($db);
?>
includes/db.php
PHP Code:
<?PHP
defined('__sn') or die(); 
class db{
    var $host      = "";
    var $user      = "";
    var $pass      = "";
..... too big of a file....
includes/layout.php
PHP Code:
<?PHP
defined('__sn') or die();
define('__sn', 1);
include "../config.php";
class layout{
    function layout($db){
        $this->db=$db;
    }
    function head(){
.... too big of a file....
includes/functions.php
PHP Code:
<?PHP
defined('__sn') or die();
class user {
    $db=0;
    function user($db){
        $this->db=$db;
    }
}
class app {
    $db=0;
    function app($db){
        $this->db=$db;
    }
    function userApps($ui){
        echo "<!-- APP LOADER: Loading Apps-->";
        $uinfo=explode("|",$ui);
        $this->db("SELECT * FROM users WHERE id='".$uinfo[0]."'");
        while($row=$this->db->fetch_array()){
            $uperm=explode(",",$row['permissions']);
            if($uperm=="(*)"){
                    
            }else{
                $permid=explode(",",$uperm);
                foreach($permid as $value){
                    $this->db->query("SELECT * FROM apps WHERE id='".$value."'");
                    while($rowa=$this->db->fetch_array()){
                        if (file_exists("<acronym title="JavaScript">js</acronym>/apps/".$rowa['location']."/index.<acronym title="JavaScript">js</acronym>.php")){
                            echo "
                            <!-- Loaded: ".$rowa['name']." -->";
                            echo "
                            <script type=\"text/javascript\" src=\"apps/".$rowa['location']."/index.<acronym title="JavaScript">js</acronym>.php\"></script>";
                        }else{
                            echo "
                            <!-- Error: ".$rowa['name']." does not exist! -->";
                        }
                    }
                }
            }
        }
        unset($uinfo,$row,$rowa,$uperm,$permid,$value);
    }
}
?>
]]> PHP connor http://www.hotscripts.com/forums/php/55905-define-issues-i-think.html Item Database Issues http://www.hotscripts.com/forums/php/55899-item-database-issues.html Tue, 17 Nov 2009 02:02:58 GMT Alright so I am building an item database; I am having some issues with codes and I figure I could get some help from the users here. You all have proven useful before. Wish I had my old account password. With my database I need to have my price checker to work with it as well. The code will... Alright so I am building an item database; I am having some issues with codes and I figure I could get some help from the users here. You all have proven useful before. Wish I had my old account password.

With my database I need to have my price checker to work with it as well. The code will have to be changed some to work in the database and I am not sure exactly what needs to be changed. If I can get some help it would be greatly appreciated.

Here is the current code:
PHP Code:
<?php
if($_GET['id'])
{
 $item = array(
               "min" => "",
               "mark" => "",
               "max" => "",
              );
 $curlh = curl_init();
 curl_setopt($curlh, CURLOPT_URL, 'http://itemdb-rs.runescape.com/viewitem.ws?obj=' . array_search(strtolower($_GET['id']),$item));
 curl_setopt($curlh, CURLOPT_RETURNTRANSFER, true);
 $src = curl_exec($curlh);
 curl_close($curlh);
 ereg('<b>Minimum price:</b> ([0-9\.km,]+)', $src, $item['min']);
 ereg('<b>Market price:</b> ([0-9\.km,]+)', $src, $item['mark']);
 ereg('<b>Maximum price:</b> ([0-9\.km,]+)', $src, $item['max']);
 ereg('<img id="item_image"[^<]+',$src,$image); 
 }

          
          
                echo $image[0] ;
                echo $_GET['id']; <br/> 
                 
    echo '
 <strong>Minumim:</strong> ' . $item['min'][1] . '<br />
 <strong>Market:</strong> ' . $item['mark'][1] . '<br />
 <strong>Maximum:</strong> ' . $item['max'][1] . '<br />';
?>
What I need it to do is to get its id from my database. The field id is "Ge_id". So it needs to get Ge_id and post it in the url. I then need it to curl the information and get the three prices.

I next need to store the prices in the database in their fields. "Ge_Minimum, Ge_Market, and Ge_Maximum". I need a timestamp to work somehow to where it checks the price from the database. If it has been less than 12 hours it gets the price from the database. If it has been more than 12 hours it gets the price again and stores it. Then it updates the timestamp. How would I do this?

I believe this is all I need help on for now. Let me know if you need any of my scripts to work to get this working. Thanks in advance. ]]> PHP The Knowing http://www.hotscripts.com/forums/php/55899-item-database-issues.html <![CDATA[[SOLVED] Php Loop :S]]> http://www.hotscripts.com/forums/php/55889-php-loop-s.html Mon, 16 Nov 2009 11:10:54 GMT Heya guys

Ok this is probally simple but ive been awake for nearly 48 hours and cant think about it and google isnt helping much either, Im gonna be posting a list of id's to a script for now called example.php what i want to do is get everyone of these id, and update a database field with it, however the ammount submitted will never be the same. could be between 1 - 100 id's.

Its to mass delete the message's in a message center from check boxes.

so heres what i got

on the message page

PHP Code:
<input name="list" id="4775" value="4775" type="checkbox"> 
when submitted it runs this

PHP Code:

if($_POST["submit"] == "delete"){
    echo" submitted";
$message_delete = mysql_query("select * from `messages` where `toid`='$players_id' and `deleted`='0'")or die(mysql_error());
    while($row=mysql_fetch_array($message_delete)){
        $messageid = $row["messageid"];
        $toname = $row["toname"];
        $deletedmessageid = safe($_POST["list"]);
        echo" $deletedmessageid";
            mysql_query("update `messages` set `deleted`='1' where `messageid`='$deletemessageid'")or die(mysql_error());
            $sucess = "Message id# $deletemessageid Deleted";
    }
} 
Now its echo'in the same Message id and i cant work out why, The values in the check boxes on the previous page are all right but this script seems to just not wanna work.

Any ideas ?

Cheers
Mike ]]> PHP smithygotlost http://www.hotscripts.com/forums/php/55889-php-loop-s.html Too many mail() function calls http://www.hotscripts.com/forums/php/55886-too-many-mail-function-calls.html Mon, 16 Nov 2009 08:52:34 GMT When I send newsletters from my CMS, many of them never get delivered even though mail() function returned 1. I'm just assuming that's server's anti-spam precaution which is only logical and most likely. How do I get around that, is it possible to create a cron job from my PHP script? Or is there an even better way?

Thanks. ]]> PHP 3Nex http://www.hotscripts.com/forums/php/55886-too-many-mail-function-calls.html