PHP - Adding Custom Background

I am in the process of learning MySQL and PHP.

I have a real-world application that I would like to develop for someone using MySQL and PHP, provided I can end up with the necessary user interface for the application.

The user will be launching a web browser to start the application.

The application will be developed for two purposes:
to record employee information (name, contact info, category of worker such as: cook, dishwasher, server, host)
to record the hours worked by each worker for each day and then generate a report that can be sent to the accountant by email or fax

Since the interaction will take place in a web browser, what are the possibilities as far as having customization for the text fields (controllable size of text field, larger than the form element), having start and end times with the colon symbol inserted automatically, to name a few.

When a text field is inserted via HTML, the rectangle is rather small.  Can the default sizes of form elements be enlarged?

Hi Everyone.

I'm trying to generate a non standard PK in the form of 000111-YU, where 0001 refers to the record number, the 11 refers to the year and the -YU is a set of random letters / numbers. The 0001 can increment throughout the year, but once 2012 occurs, the counter needs to be reset back to 0001.

I need this number to be generated and inserted into the table, but I also need to have form fields inserted into the db. for eg. FirstName and LastName are names of textboxes in a form.

this is what i have so far, but i keep receiving 'error, insert query failed.'
<?php

$db="db";
$link = mysql_connect('localhost', 'root', 'pw');

if (! $link) die(mysql_error());
mysql_select_db($db , $link) or die("Couldn't open $db: ".mysql_error());

$query = "INSERT INTO records (IDNumber, FirstName, LastName)
SELECT * FROM (
    SELECT
        # id
        CONCAT(
            # Sequential number, incremented, zero-padded
            LPAD((SUBSTR(COALESCE(MAX(IDNumber), '0'), 1, 4) + 1), 4, '0'),
            # Two-digit year
            DATE_FORMAT(CURRENT_DATE, '%y'),
            # Literal hyphen
            '-',
            # Two random letters (AA-ZZ)
            CHAR(
                FLOOR(65 + RAND() * 26),
                FLOOR(65 + RAND() * 26)
            )
        )
       
    FROM
        records
    WHERE
        IDNumber LIKE CONCAT('____', DATE_FORMAT(CURRENT_DATE, '%y'), '-__')
) ";

mysql_query($query) or die('Error, insert query failed');

?>

Hi.  I was just wondering if it is possible to write custom mysql errors.  I have hunted around for some but cant find any.  Currently I write my errors like...


or die (mysql_error());


How ever I see this as a problem!  As Im not the best coder there are bound to be errors in my code.  I dont want somebody who knows what they are doing to cause an error and then doing it (mysql_error()) will point them in the right direction to what I have missed.

I would rather have my own error saying what line the issue is with.  I have tried.....



or die (mysql_error(My personal error here))


However this does not work.

Please help.  Thank you

Hi all,

I'm new here, I just require a (most likely simple for you lot) little help with editing some PHP code...

I am editing a WordPress child themes functions.php file, basically I want to get the logo image alt text to be generated per page by the pages title, I have sucessfully achieved this on some other sites with different themes but am having issues here.

This works in some themes:

 

alt="<?php echo the_title(); ?> keyword keyword"/>

 

So I need to include this:

alt="<?php echo the_title(); ?> keyword keyword"/>

 

Or this:

[show_post_categories show=”title”]

 

Into this, replacing the site_title in the alt= parts:

    // LOGO CODE FOR SORTING ALT TEXT
<!-- Header logo -->
<a href="<?php echo esc_url( home_url( '/' ) ); ?>" title="<?php echo esc_attr( get_bloginfo( 'name', 'display' ) ); ?><?php echo get_bloginfo( 'name' ) && get_bloginfo( 'description' ) ? ' - ' : ''; ?><?php bloginfo( 'description' ); ?>" rel="home">
    <?php if(flatsome_option('site_logo')){
      $logo_height = get_theme_mod('header_height',90);
      $logo_width = get_theme_mod('logo_width', 200);
      $site_title = esc_attr( get_bloginfo( 'name', 'display' ) );
      if(get_theme_mod('site_logo_sticky')) echo '<img width="'.$logo_width.'" height="'.$logo_height.'" src="'.get_theme_mod('site_logo_sticky').'" class="header-logo-sticky" alt="'.$site_title.'"/>';
      echo '<img width="'.$logo_width.'" height="'.$logo_height.'" src="'.flatsome_option('site_logo').'" class="header_logo header-logo" alt="'.$site_title.'"/>';
      if(!get_theme_mod('site_logo_dark')) echo '<img  width="'.$logo_width.'" height="'.$logo_height.'" src="'.flatsome_option('site_logo').'" class="header-logo-dark" alt="'.$site_title.'"/>';
      if(get_theme_mod('site_logo_dark')) echo '<img  width="'.$logo_width.'" height="'.$logo_height.'" src="'.get_theme_mod('site_logo_dark').'" class="header-logo-dark" alt="'.$site_title.'"/>';
    } else {
    bloginfo( 'name' );
      }
  ?>
</a>
<?php
if(get_theme_mod('site_logo_slogan')){
    echo '<p class="logo-tagline">'.get_bloginfo('description').'</p>';
}
?>

 

THIS IS THE WHOLE FUNCTIONS.PHP FILE IN MY CHILD THEME:

<?php
// Add custom Theme Functions here
/**
* Change text strings
*
* @link http://codex.wordpress.org/Plugin_API/Filter_Reference/gettext
*/
function custom_related_products_text( $translated_text, $text, $domain ) {
  switch ( $translated_text ) {
    case 'Related products' :
      $translated_text = __( 'More fire & security systems you may like', 'woocommerce' );
      break;
  }
  return $translated_text;
}
add_filter( 'gettext', 'custom_related_products_text', 20, 3 );
/* USE SHORTCODES IN WIDGET TITLES AND PAGE TITLES !! */
add_filter('the_title', 'do_shortcode');
add_filter('widget_title', 'do_shortcode');
/* NOT SURE WHY I HAD THIS HERE??... <?php echo do_shortcode("[shortcode]"); ?> */
/* ADD ALT TAG TO GRAVATAR - BLOG-AUTHOR-IMAGE - IMAGES */
function crunchify_gravatar_alt($crunchifyGravatar) {
    if (have_comments()) {
        $alt = get_comment_author();
    }
    else {
        $alt = get_the_author_meta('display_name');
    }
    $crunchifyGravatar = str_replace('alt=\'\'', 'alt=\'Avatar for ' . $alt . '\' title=\'Gravatar for ' . $alt . '\'', $crunchifyGravatar);
    return $crunchifyGravatar;
}
add_filter('get_avatar', 'crunchify_gravatar_alt');
    // LOGO CODE FOR SORTING ALT TEXT
<!-- Header logo -->
<a href="<?php echo esc_url( home_url( '/' ) ); ?>" title="<?php echo esc_attr( get_bloginfo( 'name', 'display' ) ); ?><?php echo get_bloginfo( 'name' ) && get_bloginfo( 'description' ) ? ' - ' : ''; ?><?php bloginfo( 'description' ); ?>" rel="home">
    <?php if(flatsome_option('site_logo')){
      $logo_height = get_theme_mod('header_height',90);
      $logo_width = get_theme_mod('logo_width', 200);
      $site_title = esc_attr( get_bloginfo( 'name', 'display' ) );
      if(get_theme_mod('site_logo_sticky')) echo '<img width="'.$logo_width.'" height="'.$logo_height.'" src="'.get_theme_mod('site_logo_sticky').'" class="header-logo-sticky" alt="'.$site_title.'"/>';
      echo '<img width="'.$logo_width.'" height="'.$logo_height.'" src="'.flatsome_option('site_logo').'" class="header_logo header-logo" alt="'.$site_title.'"/>';
      if(!get_theme_mod('site_logo_dark')) echo '<img  width="'.$logo_width.'" height="'.$logo_height.'" src="'.flatsome_option('site_logo').'" class="header-logo-dark" alt="'.$site_title.'"/>';
      if(get_theme_mod('site_logo_dark')) echo '<img  width="'.$logo_width.'" height="'.$logo_height.'" src="'.get_theme_mod('site_logo_dark').'" class="header-logo-dark" alt="'.$site_title.'"/>';
    } else {
    bloginfo( 'name' );
      }
  ?>
</a>
<?php
if(get_theme_mod('site_logo_slogan')){
    echo '<p class="logo-tagline">'.get_bloginfo('description').'</p>';
}
?>

I just can't get it to work, keeps throwing errors on save :(

I know this is just a silly newbies error - any assistance would be greatly appreciated.

When a user clicks on a topic they are transfered to its post, which is retrieved by the name of the topic as given by the url value. up to now i have just used urlencode. But its trickier when a user adds slashes and dots into the mix. for example the title of the post is testing/testing. The url will go to www.asimpleforum.co.uk/t/testing/testing. How would i get around this since url encode doesnt do the job? I could replace slashes and dots with their own unique symbol but that produces the problem when someone uses one of those symbols that i use to replace in their topic title. I know one site in particular that replaces all dots and slashes with a hyphen (-), but how would you know what to turn the hyphen into when you query the database for that topic? Anyone have any ideas?

I'm gonna be perfectly honest, I have no idea what's wrong with this code, I'm not even entirely sure what it all means, I just need to make it work. -.-

I get this error:  Parse error: syntax error, unexpected '}' in Z:\www\cms\includes\functions.php on line 25

From this code:
Code: [Select]
<html>
<body>
<?php

include('includes/dbvars.php');

function displayVideos($dbc){

mysqli_connect('DB_HOST', 'DB_USER', 'DB_PW', 'DB_NAME');

//Query
$query = "SELECT * FROM videos";

//Execute
$result = mysqli_query($dbc, $query) or die ("Error querying database.");

While ($row = mysqli_fetch_assoc($result)) {
echo '<h2>' . $row['Title'] . '</h2>';
echo '<b>Director</b>:' . $row['Director'] . '<br />';
echo '<b>Description</b>:<br />' . $row['Description'];
echo '<hr>';
}

mysqli_close($dbc)
}

?>
</body>
</html>


Any help very much appreciated

Hello.

I am currently working on a new site (http://sa.cx) that is basically a free domain like this: (example.sa.cx). My main goal is to allow users to set the the full MX, CNAME, A and SOA records.

Any ideas on how I could go about this using php?

My initial thought would be via cURL.

hi
i am new in here and php coding.

i got the following code frm my friend for making a name, address, passout of student searching database.

<?php


// TAKE THE INFORMATION FROM FORM.



$search = $_GET['search'];



// IF THERE IS NOT A KEYWORD GIVE A MISTAKE.



if (!$search)



echo "You didn't enter a keyword."."$text Back to Search Again <a href=searchform.php>Search</a>";

else



{



echo "<td>You searched for: <strong>$search </strong></td>";



mysql_connect('sql servername','sql server username','password');



mysql_select_db('database name');



$id=@$_GET['id'];



//QUERY IS THE CODE WHICH WILL MAKE THE SEARCH IN YOUR DATABASE.



//I WROTE AN EXPLANATION ABOUT IT AFTER THE CODE.



$query="SELECT * FROM searchform WHERE MATCH(Name, Address, Pass) AGAINST('%$search%' IN BOOLEAN MODE)";



$result1 = MySQL_query($query);



if(!$result1) {



echo MySQL_error()."<br>$query<br>";



}



if(MySQL_num_rows($result1) > 0) {



echo "<table width='480' align='center' border='1' cellspacing='0' cellpadding='0'>";



while($result2 = MySQL_fetch_array($result1)) {



//A short description from category.



$description = $result2['category'];



$searchPosition = strpos($description, $search);



$shortDescription = substr($description, $searchPosition, 150);



// I added a link to results which will send the user to your display page.



echo "<tr><td>Name</td><td>Address</td><td>Pass</td></tr>";



echo "<tr><td>{$result2['Name']}</td><td>{$result2['Address']}</td><td>{$result2['Pass']}</td></tr>";



}



echo "</table>";



}else {



echo "No Results were found.<br>"."$text Back to Search Again <a href=searchform.php>Search</a>";



}echo "<br>";



}



?>

every thing is working fine as i wanted.

my database structure is below
|NAME||ADDRESS||YEAR|
|ABC|abc|1980|
|XYZ||xyz||1980|

but there is a small problem of showing the output result.

when i search with 1980
it show 4 column
1st column is showing NAME, ADDRESS, YEAR
2nd column is showing |ABC|abc|1980|
again
3rd column is showing NAME, ADDRESS, YEAR
4th column is showing |XYZ||xyz||1980|

how i solve to not showing every column the NAME, ADDRESS, YEAR (3rd column)

Hi all   I have the following in my .htaccess file RewriteRule ^([^/]+)/ /$1.php?q=$1 [L,QSA]   and this is great because any PHP page I create, such as 'about.php' can be rewritten as '/about/' - so that is all good.   the problem is, I also want to let users create their own custom URL's for their profiles in the root of the site, such as '/david-jones/' but because 'david-jones' is not actually a real PHP page (but rather a database entry), I cant use a rewrite rule as far as I can see.   Would the best solution be to piggy back the error 404 rewrite rule, so that if an actual PHP page isn't found, it takes them to the 404 error page which actually contains a script to lookup the users details, if the user details are not found, i'd show a "the page cannot be found" message.   Or is there a more elegant way to do this?   Thanks

Hi guys, i have a ipn paypal setup where users can buy items from my custom made shop, however in original ipn code, the logged in users should have the same email with paypal to call on ipn which user has bought what, so I have decided to pass a custome variable as

<input type="hidden" name="custom" value="<?php echo "$username";">


the hard part is in my ipn how im i going to recieve the username variable? what should i put in my ipn. In ipn code I have example code:


$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];


but now, can u help me to recieve the username so i can match my mysql query which user has bought what?

thanks in advance

Hello,

I am wondering how to create a counter that has 5 digits and counts the results from a db field (not just the returned results but the numeric SUM of the values in the field) for display.

i.e. if the sum of the field = 347 the counter would read 00347 
I have created images for the numbers 0-9 and named them 0.png, 1.png, 2.png etc

Also, I may have to sum a value that is stored in the db as serialized data (part of an array). If so how can I do that??

Is there a way to use PHP to edit html without having to store it in my DB?

For example I would like someone to be able to edit a paragraph on the page, its wrapped in a <div class="editable"> now is there a way to have PHP detect that div and have an textarea to edit it directly without having to store anything in a DB?

I hope that makes sense if it doesn't let me know!

Thanks

Hi all

I wonder if people can help me out here.

It's a "bespoke" vs "framework" question, so not sure its belongs in here, but I didn't want to post it in the ZEND group, as it may have many more "pro ZEND fans" who read it, and I wanted a general thought.

This is all based on the fact that I have a big project coming up and I want to know if I should be sticking with a custom job, or if something like ZEND is the way to go.

Basically I have been developing PHP for about 2 years now and I have always thought a custom site written from scratch was the best way to go, not only does it allow you to have the minimal code needed to run the site, therefore reducing load, space and bandwidth, but it also allows you to know exactly how the system works, I guess the downside is that you have to spend more time doing the coding.

But I have a few friends who use frameworks, ZEND has been coming up more and more, it's not really my ideal system to use as I prefer coding from scratch (not sure why),  but they swear by it, and always tell me its great, its winning awards and none of them code from scratch, one of them even quoted that it "will become the standard for development" - is this true?

Apart from being massively bulky and containing tons of files with scripts and functions that you might never ever use, what do people see as a downside to ZEND, If any?

Is it best to code from scratch, and if so, why? Or does using something like ZEND much better?

I guess if you always use ZEND, then you never really enhance your skill as a coder and never really learn anything new, plus I always think it's kind of cheeky using a pre-built system.

Is there a good argument that would say using ZEND is not really a good idea? Or is the general feeling toward ZEND being a good thing?

Surely if people know ZEND, they know how to play the security of the site to there advantage and therefore can break the security of other ZEND systems, or at least cause some hacks to a site.

Any thoughts would be great

Thanks everyone

In php number format function works like.... 

number_format("1000000",2); // 1,000,000.00

is there a way to format numbers like... 10,00,00,000 (from right. No decimal. First comma after 3 digits and then commas after every 2 digits)

I'm having real problems with a rss box that I'm trying to incorporate onto the homepage of our website... The code I'm using as a basis I got from here -
http://www.dynamicdrive.com/dynamicindex18/rssdisplaybox/index.htm

It worked okay displaying title, date and content, however, we wanted it to display the first image of the blog entry as well. In the outputbody.php (the file that dictates what is shown in the rss box) I incorporated this code (shown in bold EDIT: with the bold tags around it! ) -


Code: [Select]
<?php
//Function for ouputting the body of each RSS item displayed (inside loop)- DynamicDrive.com
//For syntax pf bpdu, see: http://simplepie.org/docs/installation/from-scratch/ and http://simplepie.org/docs/reference/
//Function by default defines 3 different body outputs (templates). Modify or add additional templates as desired



    [b]  function get_image($text)
{
 
$imageurl="";
preg_match('/<\s*img [^\>]*src\s*=\s*[\""\']?([^\""\'>]*)/i' ,  $text, $matches);
$imageurl=$matches[1];
 
if (!$imageurl)
{
 preg_match("/([a-zA-Z0-9\-\_]+\.|)youtube\.com\/watch(\?v\=|\/v\/)([a-zA-Z0-9\-\_]{11})([^<\s]*)/", $text, $matches2);
 $youtubeurl = $matches2[0];
 if ($youtubeurl)
    $imageurl = "http://i.ytimg.com/vi/{$matches2[3]}/1.jpg"; 
 }
return $imageurl;
}[/b]

function shortencontent($content, $len=40){
if(strlen($content) > $len){
return substr($content, 0, $len - 6) . ' . . .';
} else {
return $content;
}
}

function outputbody($item, $template=""){
if ($template=="" || $template=="default"){ //DEFAULT TEMPLATE
?>
<div class="rsscontainer">
<div class="rsstitle"><a href="<?php echo $item->get_permalink(); ?>"><?php echo $item->get_title(); ?></a></div>

<div class="rssdate"><?php echo $item->get_date('d M Y g:i a'); ?></div>     

<div class="rssdescription"><?php echo shortencontent($item->get_description(), 400); ?></div>

   
    [b]<div class="rssimage"><?php echo get_image(); ?></div>[/b]
</div>
<?php
} //end default template
else if ($template=="titles"){ //"TITLES" TEMPLATE
?>
<div class="rsscontainer">
<div class="rsstitle"><a href="<?php echo $item->get_permalink(); ?>" target="_new"><?php echo $item->get_title(); ?></a></div>
<div>Category: <?php echo $item->get_category(); ?></div>
</div>
<?php
} //end titles template
else if ($template=="titlesdates"){ //"TITLESDATES" TEMPLATE
?>
<div class="rsscontainer">
<span class="rsstitle"><a href="<?php echo $item->get_permalink(); ?>"><?php echo $item->get_title(); ?></a></span>
<span class="rssdate"><?php echo $item->get_date('m/d/y g:i a'); ?></span>
</div>
<?php
} //end titlesdates template
else if ($template=="mytemplatename"){ //"mytemplatename" TEMPLATE
?>
//DEFINE ADDITIONAL CUSTOM TEMPLATE(s) USING SAME LOGIC STRUCTURE AS ABOVE
//For syntax of template body, see SimplePie docs: http://simplepie.org/docs/installation/from-scratch/ and http://simplepie.org/docs/reference/
<?php
}




else
die ("No template exists with such name!");
} //Closing function bracket
?>
While it creates an imagebox nothing is shown and when you open the empty image box in the browser it displays the following URL -

http://www.oururl.%20.%20.%20.</div>%20%20%20%20%20%20%20%20<div%20class=

I have little PHP knowledge but don't really know where to start with this... please can anyone help or point me in the right direction. I appreciate that it is frustrating dealing with someone with limited knowledge but please have a little patience with me...

Cheers people!