PHP - Moved: Best Method To Add Rounded Corners To A Div

 

My script has 3 classes (that are relevant to this discussion): DB, User and Validate. They are all in independent files and loaded automatically, when required, by an autoloader.
Both the User class and the Validate class have a private variable $_db which is instantiated by their class constructor: $this->_db = DB::getInstance();
At the top of the script I declare new instances: $user = new User(); and $validate = new Validate();
I then call a method in $user: $found = $user->findInUsers ( .... )
From within the findInUsers method I then want to call the query method in the DB class. My problem is that I can't find a way to do this that works.
I have tried $this->_db->query( ... ), $_db->query( ... ), but neither works.

The error messages I am getting a
An error occurred in script '/srv/http/classes/User.php' on line 42: Undefined variable $_db
Uncaught Error: Call to a member function query() on null in /srv/http/classes/User.php:42

Any pointers as to what I am doing wrong, or what I should be doing, would be most welcome.

Hey guys,

I use the code below to add a corners to an image and it works great but when i add a border to the image it add a square.... any ideas how i can add a border to the rounded image?

<?php
$image_file = $_GET['src'];
$corner_radius = isset($_GET['radius']) ? $_GET['radius'] : 20; // The default corner radius is set to 20px
$topleft = (isset($_GET['topleft']) and $_GET['topleft'] == "no") ? false : true; // Top-left rounded corner is shown by default
$bottomleft = (isset($_GET['bottomleft']) and $_GET['bottomleft'] == "no") ? false : true; // Bottom-left rounded corner is shown by default
$bottomright = (isset($_GET['bottomright']) and $_GET['bottomright'] == "no") ? false : true; // Bottom-right rounded corner is shown by default
$topright = (isset($_GET['topright']) and $_GET['topright'] == "no") ? false : true; // Top-right rounded corner is shown by default
$imagetype=strtolower($_GET['imagetype']);
$backcolor=$_GET['backcolor'];
$endsize=$corner_radius;
$startsize=$endsize*3-1;
$arcsize=$startsize*2+1;

if (($imagetype=='jpeg') or ($imagetype=='jpg')) {
$image = imagecreatefromjpeg($image_file);
} else {
if (($imagetype=='GIF') or ($imagetype=='gif')) {
$image = imagecreatefromgif($image_file);
} else {
$image = imagecreatefrompng($image_file);
}
}


$size = getimagesize($image_file);
// Top-left corner
$background = imagecreatetruecolor($size[0],$size[1]);
imagecopymerge($background, $image, 0, 0, 0, 0, $size[0], $size[1], 100);
$startx=$size[0]*2-1;
$starty=$size[1]*2-1;
$im_temp = imagecreatetruecolor($startx,$starty);
imagecopyresampled($im_temp, $background, 0, 0, 0, 0, $startx, $starty, $size[0], $size[1]);
$bg = imagecolorallocate($im_temp, hexdec(substr($backcolor,0,2)),hexdec(substr($backcolor,2,2)),hexdec(substr($backcolor,4,2)));
$fg = imagecolorallocate($im_temp, hexdec(substr($forecolor,0,2)),hexdec(substr($forecolor,2,2)),hexdec(substr($forecolor,4,2)));

if ($topleft == true) {
imagearc($im_temp, $startsize, $startsize, $arcsize, $arcsize, 180,270,$bg);
imagefilltoborder($im_temp,0,0,$bg,$bg);
}

// Bottom-left corner
if ($bottomleft == true) {
imagearc($im_temp, $startsize, $starty-$startsize,$arcsize, $arcsize, 90,180,$bg);
imagefilltoborder($im_temp,0,$starty,$bg,$bg);
}

// Bottom-right corner
if ($bottomright == true) {
imagearc($im_temp, $startx-$startsize, $starty-$startsize,$arcsize, $arcsize, 0,90,$bg);
imagefilltoborder($im_temp,$startx,$starty,$bg,$bg);
}

// Top-right corner
if ($topright == true) {
imagearc($im_temp, $startx-$startsize, $startsize,$arcsize, $arcsize, 270,360,$bg);
imagefilltoborder($im_temp,$startx,0,$bg,$bg);
}


$newimage = imagecreatetruecolor($size[0],$size[1]);
imagecopyresampled($image, $im_temp, 0, 0, 0, 0, $size[0],$size[1],$startx, $starty);

// Output final image
header("Content-type: image/png");
imagepng($image);
imagedestroy($image);
imagedestroy($background);
imagedestroy($im_temp);
?>

Hello,
I've had success creating a cool vanity QR code with rounded edges for my organization by generating a standard QR code, then applying a noise -> median effect in Photoshop to get the edges rounded among some other effects.



Photoshop is great, but I want to automate this. I found a great PHP library to generate QR codes. The part I don't get is the rounding of the hard edges.

I've seen other sites do it like this one.

So far google searches are yielding rounded corner tutorials. Any thoughts on how to do this with GD or ImageMagic?

Best regards,

Chris

The following query code works correctly, however, I'm trying to figure out which is best when working with themes, templates, content pages. My themes are my different versions of the main site designs. As of right now I have the following code plus the database structure.

site_themes - id, theme_name, status_id (only one theme can have a value of 1(active) at any given time)

site_templates - id, template_name, header_code, footer_code, status_id (any can have a value of 1(active) at any given time,

Code: [Select]
<?php

require("kowmanager/config/database.php");

$site_variables_query = "SELECT * FROM site_variables WHERE id = '1'";
$site_variables_result = mysqli_query($dbc, $site_variables_query);

$row = mysqli_fetch_array($site_variables_result, MYSQLI_ASSOC);

$site_theme_query = "SELECT * FROM site_themes WHERE status_id = '1'";
$site_theme_result = mysqli_query($dbc, $site_theme_query);

$row2 = mysqli_fetch_array($site_theme_result, MYSQLI_ASSOC);

if ($row['site_is_down'] == 'Yes') {
    
} else {
    echo "site is up";
}

?>

I am trying to insert the current Date/Time into mysql database using the following code.

I do not understand how $submitDate &  $submitTime are to be set.

Will this work as coded?

Code: [Select]

<?php
 
class SubmitDateRecord {

  const DB_TABLE = 'timesheet';
const DB_FIELD_SUBMIT_TIME = 'submit_time';

 
private $submitDate;
private $submitTime;

 
public function setSubmitDate($submitDate) {
    $this->submitDate = $submitDate;
}

public function getSubmitDate() {
    return $this->submitDate;
}

public function setSubmitTime($submitTime) {
    $this->submitTime = $submitTime;
}

public function getSubmitTime() {
    return $this->submitTime;
}

 

public function addRecord() {

    $insertTable = "`".self::DB_TABLE."`";
       
$insertFields[] = "`".self::DB_FIELD_SUBMIT_TIME."`";

$insertValues[] = "'{$this->submitDate} {$this->submitTime}'";
           

$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($insertTable, $insertValues, $insertFields);

$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);

if ($result) {
    return true;
} else {
    return false;
}

}


private function _buildRecordObjects($result) {

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

$submitdateObj = new SubmitDateRecord();

$submitdateObj->setAttendanceId($row['attendance_id']);
$submitdateObj->setEmployeeId($row['employee_id']);

/* $row['submit_time'] comes in '0000-00-00 00:00:00' format.
 * We want date in '0000-00-00' format and time in '00:00' format.
 */
$tmpArr = explode(' ', $row['submit_time']);
$submitdateObj->setSubmitDate($tmpArr[0]);
$submitdateObj->setSubmitTime(substr($tmpArr[1], 0, 5)); // Omiting 'seconds' part is ok since it is always zero








$submitdateObj->setStatus($row['status']);



$submitdateArr[] = $submitdateObj;

}

return $submitdateArr;

}

}

Hi,

I have a problem and can't seem to figure out how to do it..

Basically i have these 2 tables:

Quote

People
Pid
Pname
Pdateadded
Pdeleted


And..

Quote

Quote:
PeopleCon
PCid
Pid
PCorder
Pdateadded
Pdeleted


Now, currently i insert the data into a table "People".. like you guys have helped me with..

But what i need to do is, first check to see if the author already exists in the People table, if so then just INSERT into PeopleCon, ELSE INSERT into both People and PeopleCon...

Also if there are 4 authors, and 2 exist in People, and 2 do not. What needs to happen is the first 2 are simply inserted into PeopleCon, but the last 2 are INSERTED into both People and PeopleCon. When the authors are inserted into PeopleCon, the PCorder row needs to increment by the number of authors byt order of author.

So this is the logic:

Multiple authors are entered in textboxes Fire the script Check to see if author already exists in "People" table IF it does exist, INSERT into PeopleCon table ELSE do the insert into the People AND PeopleCon table, first it will INSERT into the People, and GET the MAX (ID) and insert into the PeopleCon
So i currently have this, but as 3 separate methods:


class People {

    public function checkNameExists(){

       $query = "SELECT * FROM People WHERE Pname = '". mysql_real_escape_string($_POST['author'])."'";

        $result = mysql_query($query);
        if(mysql_num_rows($result) > 0):
            $row = mysql_fetch_array($result);
            return true;
        else:
            return false;
        endif;
    }

    public function insertAuthor(){
        $callback = create_function('$author','return "(\'".mysql_real_escape_string($author)."\',NOW(),0)";');
        $sql = sprintf(
            'INSERT INTO People (Pname, Pdateadded, Pdeleted) VALUES %s'
            ,implode(',',array_map($callback,$_POST['author']))
        );
        $result = mysql_query($sql);
        return "Successfully added NEW author";
    }

    public function insertAuthorCon(){

        $sql = "INSERT INTO PeopleCon
                    (Pid, PCorder, PCdateadded, PCdeleted) VALUES
                    (
                    'MAX ID WILL GO HERE',
                    'INCREMENT OF ORDER GOES HERE',
                    now(),
                    0
                    )";
        $result = mysql_query($sql);
        return "Successfully added existing author";
    } 


But obviously i need to combine these together into one method to match what i am trying to achieve..

Can anyone point me in the right direction?

Thanks again...

Hi all,
What is the maximum size of data that we can pass through GET Method?
And can we increase its size ?

I know I'm posting this inside the PHP coding board but I'm curious on how most handle this situation. I have a page that uses php to retrieve data from my database and I want to have it place a | in between each of the returned data which it does but it still places one after the last returned row. I'm wondering if I should do this with jquery load and then have it place that character in between each of the data or if there's a way to do it with php or what? Any ideas?

Code: [Select]
<?php require ("../header.php"); ?>

<div id="titlehistory" class="content">
 
<h1 class="pageheading">Title History</h1>

<?php 
$titlesQuery ="
SELECT 
    titles.titleName, 
    titles.shortName
FROM
    titles
WHERE
    titles.statusID = 1 
ORDER BY      
    titles.ID";
$titlesResult = mysqli_query($dbc,$titlesQuery);

?>
     
    <p><span class="minilinks">
   
        <?php
        while ( $row = mysqli_fetch_array ( $titlesResult, MYSQLI_ASSOC ) ) {
            $fieldarray=array('titleName','shortName');     
            foreach ($fieldarray as $fieldlabel) {         
                ${$fieldlabel} = $row[$fieldlabel];     
            }
             
            echo '<a href="/titlehistory/'.$shortName.'">'.$titleName.'</a>&nbsp; |';
        }
        ?>
    </span></p>
   
    <p class="nohistory">Please select a title to view.</p>

</div>

<?php require ("../footer.php"); ?>

here is what i am trying to do. i have a url in my browser like this: http://localhost/jmla/index.php?option=com_content&view=article&id=1295:sovereign-a-country-risk-workshop

as usuall we get elements form the url using the $_GET method, but here when i try to get id from the above url. i can get 1295:sovereign-a-country-risk-workshop. whereas the id is only 1295 and the other part is alias which i want to get seperately.

is there a way to do so?

Hi There,

I am trying to implement a facebook plugin into my website. When the user posts a link to my site on their wall it will redirect them back to my page with some GET info in the URL eg. www.example.com/download.php?post_id=43221. I don't need to know the Post Id number, I just need to know if they went to the facebook page. So my question is, how would I make it s that if there is a Post ID number it displays the page and if not it directs them to another page?

Please help me with this, i'm totally stumped.

Thanks

George Bates 

Hi there,

I want to allow the ability for DJ's to turn on and off radio requests.

Now obviously I've encorporated a check box and submit button within a PHP login. But I was wanting to know if this can be done with PHP or is a database required as the option will need to be remembered for a period of time.

I'd probably look to do it by making it display on a page 'requests enabled' if enabled and a blank page if disabled. therefore I could encorporate:

<?php
if(!empty($requests))
{
//requests template
}
else  
{
//radio requests disabled template
}
?>

What's the best method for this?

Thanks

I have a restricted page for members of a website. This restricted area is within a directory called 'download.'

There is a login form on two pages (home and support pages, found in the main menu). These pages are on the site root directory. When the user successfully logs in they are taken inside the download directory to index.php.

This index.php has a different look to the site root design. I have since redesigned this page to have the same structure as the site root pages.

I would love for the user to able to navigate around the main site if they wanted, and when they clicked support in the menu they would have all the download files there on the page, instead of a login form.

My question is how would I implement this login so that when the user logs in the support page changes from the login page to the page with the files.

I don't want to to duplicate the site within the download directory, I was hoping for an efficient method, but I am unsure how to go about it. 

I have written a method that gathers data from several tables in my database and builds a ad out of the information then returns multidimensional array for each ad like this:


$ad[0]
$ad['title'][0]
$ad['price'][0]
$ad['description'][0]...etc


The method i have looks something like this:


function makeAd($id=null){
//if ad id is given then only get that ad
  if($id != NULL) {
    $where = "WHERE ad_id = $id";
  }
  else {$where = "";}
 
$sql = "SELECT * FROM ads $where";
$query = mysql_query($sql);

//use while loop to make ad
  while($ret_val = mysql_fetch_array($query, MYSQL_ASSOC)):
//get ads category, subcategory and images etc from other tables
  $cat_query = mysql_query("SELECT cat_name FROM categories WHERE $category_id = ".$ret_val['category_id']);
  $value = mysql_fetch_array($cat_query,MYSQL_ASSOC);
  $category = $value['cat_name'];

  $sub_query = mysql_query("SELECT sub_name FROM categories WHERE $subcategory_id = ".$ret_val['subcategory_id']);
  $value = mysql_fetch_array($sub_query,MYSQL_ASSOC);
  $category = $value['sub_name'];

  $cat_query = mysql_query("SELECT image_name FROM categories WHERE $ad_id = ".$ret_val['ad_id']);
  while($value = mysql_fetch_array($cat_query,MYSQL_ASSOC)): //loop to get all images for ad
    $image = $value['image_name'];
  endwhile;

//make ads array
  $ad = array(
   'tilte'=>$ret_val['title'],
   'price'=>$ret_val['price]',
   'desc'=>$ret_val['description'],
   'category'=>$category,
   'subcategory'=>$subcategory,
   'images'=>$image
  );
endwhile;
//return completes ad(s)
  return $ad;
}


Then I loop through the returned array like this...

include(myClass.php);
$class = new myClass();

$ads = $class->makeAd();

foreach($ads as $ad):
  echo '<ul>'
  echo '<li>'.$ad['title'].'</li>';
  echo '<ul><li>Price: '.$ad['price'].'</li>';
  echo '<li>Category: '.$ad['category'].'</li>';
  echo '<li>Subcategory: '.$ad['subcategory'].'</li>';
  echo '<li>Description: '.$ad['description'].'</li>';
  foreach($ads['images'] as $image):
    echo '<li>Image: '.$image['image_name'].'</li>';
  endforeach;
  echo '</ul></ul>';
endforeach;


I get no errors but I do not get correct results either just random letters and numbers for each item.  I am sure it has to do with how I have handled looping through the multidimensional array but can;t sort it out.  Any help/coding advice would be greatly appreciated.  Please also note that the html in the loop is only there for testing/development and is just thrown together.


Thanks.

Mike.

I have an error that I seem to find curious. Let me explain what I have. I have a Database class that has a function (the culprit) that is called fetchAll. It is suppose to call the mysqli method mysqli_result::fetch_all(). This method does exist, I have looked it up: The PHP Manual, however do note the last comment on the page, it describes my problem, but does not explain how I can fix it. Now, here is my error:

Quote

Fatal error: Call to undefined method mysqli_result::fetch_all() in /var/www/core/includes/Database.php on line 36


Here is line 36:
$row = $this->result->fetch_all($mode);

Here is the entire function, or is it called a method since it is in a class?

function fetchAll($mode = 'MYSQLI_ASSOC'){

$row = $this->result->fetch_all($mode);

return !empty($row) ? $row : array();//if not empty return row, else return an array?

}


I could post the entire class, but I think it might be irrelevant so I will spear you guys.

Do you guys think you might be able to help me out?

Thanks!

I have foreach method. This displays the choices that are selected and the value inside them as 1.  The method is shown below. I am printing these with the name(choice1, choice2, choice3, choic4) and the value. If there is a value then it prints 1.  Now my problem is I want to INSERT them into my database. if it prints choice1, choice2 then value 1 must be entered into choice1 and choice2 inside the database. I am not sure how to do this. can someone help me.
Code: [Select]
foreach ($_POST["choice"] as $question => $answer)
{

if($answer == NULL)
{
$val=0;
}
else{
$val = 1;
}

echo "choice id: $question. value: $val <br />";