PHP - Simple Php Solution

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=349561.0

 Ok, well basically i'm not sure if this can be done or not.  Basically I have a IM type bar for my website similar to facebook.  It's from CometChat.com.  Anyway the place to edit the links to all the modules for the bar are done in the config.php file.  What I'm trying to do is put a link for users to click to go directly to their profile on the site.  To do this i get the user's ID, and reference it to the mysql database, get the nickname, pass it to a varaiable and plug the variable into the url in the config file.  The problem I'm having is when I run ANY mysql commands in the config file it kills the CometChat script from showing at all on the site.  I'm not sure why since the whole config file is in php... so i don't see how mysql statements would keep the script from showing.  Another Idea I thought about was running the mysql statements in another php file and somehow get that variable from a php code in the config.php file.. but i'm not really sure what code will run the mysql file and return the variable i need.  Any help is greatly appreciated.

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=356124.0

hey guys i wrote an quick and dirty anagram solver for a challenge on hts  which works great but i am more interested on feedback of how I could have written it better / more efficiently. anyone have there own version of writing this? thanks

Code: [Select]

$scramwords = array("htssboe","rtefcelh","vteevl","edsiyn","awloddno","dtey1d","kuedci","seellhy","sernin","acianro");
$unscramwords = array();
$filename = '../wordlist.txt';

// loop through scrambled words
foreach($scramwords as $scramword)
{
    // open the file
    if($fh = fopen($filename,'r')) do {
     
      // read line
      $line = fgets($fh);
     
      // see if line and scrambled word are same length
      if((strlen(trim($line))) == (strlen(trim($scramword))))
      {
          //if they are the same length split the line into and array and the scrambled word into an array
         
          $l = array();
          for($i=0;$i<strlen(trim($line));$i++){
              $l[$i] = substr(trim($line),$i,1);
          }
         
          $s = array();
          for($i=0;$i<strlen(trim($scramword));$i++){
             $s[$i] = substr(trim($scramword),$i,1);
          }
         
          $errors = 0;
          // see if the arrays are different
          $chk = array_diff($l,$s);
         
          if(!empty($chk)){
              $errors = 1;
             
          }
          // see if arrays are different in reverse order
          $chk2 = array_diff($s,$l);
         
          if(!empty($chk2)){
              $errors = 1;   
          }

          // found scrambled word
          if(!$errors)
          {
              array_push($unscramwords,$line);
          }
                 
      }
     
    }while(!feof($fh));

    fclose($fh);
}
// print out comma seperated un scrambled words
echo implode(",",$unscramwords);

Hi guys,

I have a simple INSERT code. It does not throw any errors and all seems ok but the data is just not appearing in the DB. I've spent ages looking over it but perhaps a 2nd set of eyes could help?

Thanks!

Code: [Select]
$con = mysql_connect("localhost","posturep","");

$tablename = 'product';

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
        //Form data sent

$product_name = $_POST['product_name']; 
$product_active = $_POST['product_active']; 
$product_cat = $_POST['product_cat']; 
$product_desc = $_POST['product_desc']; 
$prod_inoutdoor = $_POST['prod_inoutdoor'];
$prod_stackable = $_POST['prod_stackable'];
$prod_discounted = $_POST['prod_discounted']; 

echo $product_name;

$sql = "INSERT INTO $tablename (name) VALUES ($product_name)";

mysql_query($sql);
echo "<p>Product Saved!</p>";
echo $sql;
mysql_close($con);

I use a script for sharing links. Everything works ok, but checking for valid images can take a long time.
First through CURL method I parse certain tags (for description and title) then I use the following script to find images from the submited link:

Code: [Select]
$dom = new domDocument;
  @$dom->loadHTML('<?xml encoding="UTF-8">' . substr($content,0,35000));
  $dom->preserveWhiteSpace = false;
  $images = $dom->getElementsByTagName('img');

It sometimes happens that the images have not not a good path(depending on whether the link is permanent or not) and then use the getimagesize function that works well. But it can be very slow ...sometimes it takes 15-30 seconds.
Without function getimagesize process takes a few seconds.
Is there a better (faster) method to check whether the image is valid or not?

Hi all,

I would like to ask you if somebody could have a better idea to build this function.

The current one is working, but I feel this built a bit in an amateur manner.

Feel free to add your ideas so we can learn more about PHP and how to deal with arrays.

I have an array:

$arrayVideoSpecs = Array(
    Array(
        'aspect' => '4:3',
        'density' => '442368',
        'resolution' => '768x576'
    ),
    Array(
        'aspect' => '4:3',
        'density' => '307200',
        'resolution' => '640x480'
    ),
    Array(
        'aspect' => '16:9',
        'density' => '2073600',
        'resolution' => '1920x1080'
    ),
    Array(
        'aspect' => '16:9',
        'density' => '121600',
        'resolution' => '1280x720'
    )
);

and I want an array as output grouped by video aspect ratio where the key is the pixel density and the value is the video resolution, namely like that for aspect ratio 16:9 ...

Array
(
    [2073600] => 1920x1080
    [121600] => 1280x720
)

Then I coded this function which is working but seems amateur ...

    function groupAndExtractByAspect($array, $groupBy, $aspect, $density, $resolution)
    {
        $groupByAspect = Array();
        foreach ($array as $value)
        {
            $groupByAspect[$value[$aspect]][] = Array($value[$density], $value[$resolution]);
        }
	        $arrayClean = Array();
        foreach ($groupByAspect as $key => $value)
        {
            if ($key == $groupBy)
            {
                $arrayClean[$key] = $value;
            }
        }
	        foreach ($arrayClean as $aspectGroup)
        {
            $arrayOutput = Array();
            for ($i = 0; $i <= count($aspectGroup); $i++)
            {
                $densityIsValid = false;
                $resolutionIsValid = false;
                if (!empty($arrayClean[$groupBy][$i][0]))
                {
                    $density = $arrayClean[$groupBy][$i][0];
                    $densityIsValid = true;
                }
                if (!empty($arrayClean[$groupBy][$i][1]))
                {
                    $resolution = $arrayClean[$groupBy][$i][1];
                    $resolutionIsValid = true;
                }
                if (($densityIsValid === true) && ($resolutionIsValid === true))
                {
                    $arrayOutput[$density] = $resolution;
                }
            }
        }
        return $arrayOutput;
    }

The usage is as follow ...

$showArray = groupAndExtractByAspect($arrayVideoSpecs, '16:9', 'aspect', 'density', 'resolution');
echo '<pre>';
print_r($showArray);
echo '</pre>';

Thank you very much for your ideas!

Mapg

i want to make a forum that nobody can fill that through any software automatically
i make this one with java script authentications but some one also make a break of this and and he fill this software only in one click with automatic way
this one which i make
http://www.ebs-ads.com/advertising/forms.php?id=4&name=Abel

any better solutions using php or any other function that users must have to post every input field separately manually ..if yes Please suggest me thanks

hi

i am calling some text from a database with php and echoing it to flash. i have no idea the charset anything is in. all i can see is that calling the text from the database and placing into flash yields in some missing chars, but if echo the called text to the browser, copy it and echo that to flash, all characters appear. now, i kow this is not a flash forum, and im not going to ask for a flash solution because there's just too many different charsets and code i cannot control/ nor see so i was thinking of doing something along the line of having php creating a clone of the copied text that appears in the browser, and having it echo that text to flash. it there something php can do, similar to what i described?

regards

Hi all.

I am currently trying to build a site that will allow users to manage a self build house project.  This is my first php MySQL project but I am getting to grips with it ok.

I am currently building this for my own benefit at the moment as I am about to undertake a self build. 

I have a few questions to put to you guys.

This is where I am at the moment

I have a database table named materials which contains a list of materials , quantities, unit of measurement, id.

My site has a user control panel that has separate forms for each stage of the build where the user enters the quantities of the materials, and the data is displayed as an array for each stage.

So, heres question 1.

I want to take the data and use it to generate a form which will be completed by several merchants....

so it will display similar to the array but will be a form with a text box for price where the merchant will insert a price.

i.e

<?php 


mysql_connect ("localhost", "test", "test") or die ('I cannot connect to the database becuase: ' . mysql_error());

mysql_select_db ("matquant");

// query
$query = mysql_query("SELECT * FROM `quantites` ORDER BY `id` ASC"); 



// results
while ($row = mysql_fetch_array($query)) {
   
   echo  "<br />"   .$row ['id'].      "  "  .$row ['material'].       "     "    .$row['quantity'].  "   "    .$row['unit']. "<br />";}
echo mysql_error();
?>



I want to add a text input box form which will allow the merchant to add a price to each item that is added to the array. so there the merchant will be able to give me a price for all the items in my list.  Heres where I get stuck....  as I am constantly adding to the list I have no fixed amount of items so the form for the merchants needs to be built dynamically, ie each time I add a new material, I want the merchants form to get a new input.

I am not very good at describing my problems but I am hoping that someone can help me out from the information given.

Thats the first question.  i like to get issues sorted in small bites. 

the second is the next big bite,  I want to send the form above to several merchants, so I intend to have a user database with a user for each merchant, and link the tables so that each merchant can provide a price for each material, ideally the form would highlight the materials that have not had  a price yet.

I'm looking for advice on the best method of doing this basically but if I can get the first question sorted that would be great..

I have the test site local but can upload it it to the server if it will help you see what im trying to do.

Any help that anyone can give will be greatly appreciated.

hi all

i am looking for the quickest way to zip all files and folder of a website i am currently using the followning.

<?php
$date = date("F-j-Y-g-ia");

if(exec("cd /home/isd/public_html/bk/files;tar -cvpzf backup-$date.tar /home/isd/public_html")) {

echo "done";

 
 

}  

?>

This works but was just wondering if anyone can give me and insight on a better solution??

Thanks

hello,

I'm a beginner when it comes to PHP:
I'm working on a log in system but i keep on getting the same errors which makes my system unreliable.

this is the function I'm trying to use:
 if(pg_numrows($q) == 1){
                echo "<p>Someone took that username</p>";
                include "signup.php";
                exit;
        }
--> I'm using a postgresql database

this is the warning I keep on getting:
Code: [Select]
Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /var/ftpdirs/512544/PHP/login/adduser.php on line 13

I have the same problem when I try to look if an username is taken or not... when people try to register



this is my adduser.php file:
<?php
        session_start();
        include "connectie_db.php";
        $User_name = $_POST['user_name'] ;
        $User_pass = $_POST['user_pass'] ;
$User_pass2 = $_POST['user_pass2'] ;
    $checkUsername= "SELECT user_name from tovanu.users where user_name = '$User_name';";
        $q = $db->exec($checkUsername);
if(MDB2::isError($q)){
echo "code: ".$q->getUserInfo();
exit();
}
        if(pg_numrows($q) == 1){
                echo "<p>Someone took that username</p>";
                include "signup.php";
                exit;
        }
        If(strlen($User_name > 32)){
                echo "<p>The username is too long</p>";
                include "signup.php";
                exit;
        }
        if($User_pass != $User_pass2){
                echo "<p>Both passwords must be the same</p>";
                include "signup.php";
                exit;
        }
        $password = md5($User_pass);
        
        $add = "INSERT INTO tovanu.users
(user_name,user_pass,user_email,user_date,user_level,naam,adres,plaats,postcode)
VALUES ('$User_name','$password','email',current_date,1,'jef','jonhstraat','maaseik','3687')";
        
        $execute = $db->exec($add) ;
        
         if(MDB2::isError($execute)){
echo "code: ".$q->getUserInfo();
exit();
}

        $_SESSION['user'] = $username;
       
include "index.php";
        ?>
        


any help would be appreciated!!!!!!!!!!!

I'm trying to create an object oriented PHP poll. I know I'm close but I got stuck. If anyone can help me with this.

It's a radio button poll:
Code: [Select]
<html>
<head>
  <title>Polling</title>
<head>
<body>
<h1>Pop Poll</h1>
<p>Who will you vote for in the election?</p>
<form method=post action="show_poll.php">
<input type="radio" name="vote" value="John Smith">John Smith<br />
<input type="radio" name="vote" value="Mary Jones">Mary Jones<br />
<input type="radio" name="vote" value="Fred Bloggs">Fred Bloggs<br /><br />
<input type=submit value="Show results">
</form>
</body>
Here is the show_poll.php

<?php
/*******************************************
  Database query to get poll info
*******************************************/

// get vote from form
$vote=$_REQUEST['vote'];

// log in to database
if (!$db_conn = new mysqli('localhost', 'poll', 'poll', 'poll'))
{
  echo 'Could not connect to db<br />';
  exit;
}

if (!empty($vote))  // if they filled the form out, add their vote
{
  $vote = addslashes($vote);
  $query = "update poll_results
            set num_votes = num_votes + 1
            where candidate = '$vote'";
  if(!($result = @$db_conn->query($query)))//'@' means not showing error message.
  {
    echo 'Could not connect to db<br />';
    exit;
  }
} else {
echo 'You did not vote!<br />';
exit;
}
// get current results of poll, regardless of whether they voted
$query = 'select * from poll_results';
if(!($result = @$db_conn->query($query)))
{
  echo 'Could not connect to db<br />';
  exit;
}
$num_candidates = $result->num_rows;//how many candidates are =  the number of rows
// calculate total number of votes so far
$total_votes=0;
while ($row = $result->fetch_object())
{
    $total_votes +=  $row->num_votes;

}
$result->data_seek(0);  // reset result pointer



?>
<h2>Result:</h2>
<table>
<tr>
<td>John Smith:</td>
<td>
<img src="poll.gif"
width='<?php echo(100*($num_candidates/$total_votes)); ?>'
height='20'>
<?php echo(100*($num_candidates/$total_votes)); ?>%
</td>
</tr>
<tr>
<td>Mary Jones:</td>
<td>
<img src="poll.gif"
width='<?php echo(100*($num_candidates/$total_votes)); ?>'height='20'>
<?php echo(100*($num_candidates/$total_votes)); ?>%
</td>
</tr>
<tr>
<td>Fred Bloggs:</td>
<td>
<img src="poll.gif"
width='<?php echo(100*($num_candidates/$total_votes)); ?>'height='20'>
<?php echo(100*($num_candidates/$total_votes)); ?>%
</td>
</tr>
</table> 


the Problem::
When I click a candidate it increments the value in the database it gets recorded well but I have problem with showing the result. It doesn't show the result right. I know that the bug lays he Code: [Select]
100*($num_candidates/$total_votes)).
Instead of $num_candidates variable I need to come up with another variable that is the number of votes each candidate gets. I don't know how to come up with that. Any help    
Please help me with this I'd like to have an object oriented solution the point is that I don't want to use  "If else" statements.
Thanks any help a lot in advance

Hi guys. First of, English is not my spoken language so have patience

I've google it and done some reading regarding "hard refresh" but i cant find the information i'm looking for.
Lets say that i visit a website that i've visit 6 month earlier, and what if they done some changes that require a so called hard refresh. How should people know that the site require a ctrl+5?
I mean, i could be visit sites that looks different without my knowledge, that could been changed several month ago?

How does it work? Is it manage automatically or is it up to the webmaster to implate some codes like
Code: [Select]
<?php
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // Date in the past
?>
I dont know much about site development and i try to learn as much as i can. Is there no better way to handle this.

And my second question.
Where should i paste codes like this to solve the cache problem? In the header.php?