PHP - Wordpress Dynamic Template

This topic has been moved to PHP Applications.

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

This topic has been moved to PHP Applications.

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

I have a php tutorial that I followed for creating, inserting, selecting and updating a MySQL database with php.  Everything works fine so I wanted to put it into Wordpress.  I took the code and placed it into the wordpress page and everything worked just fine except the update function. 

Here is the tutorial I used. http://www.phpsimple.net/mysql_insert_record.html  It is also the part I am having trouble with.  I am able to create a record and I am also able to select a record but when I choose "update" the form doesn't load the data.  It will outside the website but not inside wordpress.  I am hoping this is not vague but because of my inexperience I am not sure what else to say.  I will be more than happy to provide any other information you need.

Folks,

I need help (Php code ) to generate a Dynamic Text on a Base Image. What i want to do is, to make this Image as header on my Site and to make this Header Specific to a Site, i want to Add the Domain Name on the Lower Left of the Image.

Got the Idea?

Here is the Image link:

Quote

http://img27.imageshack.us/i/shoppingheader1.jpg/


PHP Variable that holds the Domain name is:  $domain 

All i need the Dynamic PHP Codes that i can put on all my sites to generate this Text on Image (Header) Dynamically...

May Anyone Help me with this Please?

Cheers
Natasha T.

Hi all

I need to combine these two scripts:

Firstly, the following decides which out of the following list is selected based on its value in the mySQL table:

<select name="pack_choice">
<option value="Meters / Pack"<?php echo (($result['pack_choice']=="Meters / Pack") ? ' selected="selected"':'') ?>>Meters / Pack (m2)</option>
<option value="m3"<?php echo (($result['pack_choice']=="m3") ? ' selected="selected"':'') ?>>Meters / Pack (m3)</option>
<option value="Quantity"<?php echo (($result['pack_choice']=="Quantity") ? ' selected="selected"':'') ?>>Quantity</option>
</select>

Although this works OK, I need it also to show dynamic values like this:

select name="category">
<?php
$listCategories=mysql_query("SELECT * FROM `product_categories` ORDER BY id ASC");
while($categoryReturned=mysql_fetch_array($listCategories)) {
echo "<option value=\"".$categoryReturned['name']."\">".$categoryReturned['name']."</option>";
}
?>
</select>

I'm not sure if this is possible?

Many thanks for your help.

Pete

I've been trying to use an example I got off of this forum.
The PHP file works fine as a separate PHP file.
When it's adding into a wp page the following results occur;

Page will access db and display the list of people.
Columns can be sorted by either the id or name.
Existing names can be modified

However;
Can not add new players or delete players

ANY suggestions are appreciated!

<?php
/**** Dealing with the database ****/
// connect to db
$conn = mysql_connect('xxxxxxxxxx','yyyyyyyyyy','zzzzzzzzzzzzz') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('ddddddddddddd',$conn) or trigger_error("SQL", E_USER_ERROR);

// INSERT: if we have a name to add...
if($_GET['name']) {
   // little bit of cleaning...
   $name = mysql_real_escape_string($_GET['name']);
   // insert new name into table
   $sql = "INSERT INTO info (id, name) VALUES ('','$name')";
   $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
} // end if

// UPDATE: if we have name(s) to change...
if($_POST['cname']) {
   // for each name to change...
   foreach($_POST['cname'] as $cid => $cname) {
      // little bit of cleaning...
      $id = mysql_real_escape_string($cid);
      $name = mysql_real_escape_string($cname);
      // update name in the table 
      $sql = "UPDATE info SET name = '$name' WHERE id = '$id'";
      $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
   } // end foreach
} // end if
         
// DELETE: if we have a name to delete...
if($_GET['name']) {
   // little bit of cleaning...
   $name = mysql_real_escape_string($_GET['name']);
   // delete name from table
   $sql = "DELETE FROM info WHERE name = '$name'";
   $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
} // end if

// ORDERBY: if one of the links was clicked..
if ($_GET['orderby']) {
   // make an aray of allowed names
   $allowed = array('id','name');
   // bit of cleaning...
   $order = mysql_real_escape_string($_GET['orderby']);
   // is it a valid column name? yes: use it. no: default to 'id'
   $order = (in_array($order, $allowed))? $order : "id";
// if no link clicked, default to 'id'
} else {
   $order = "id";
} // end else

// SELECT: get the list of names from database
$sql = "SELECT id, name FROM info ORDER BY $order";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
/**** end deal with the database ****/

/**** list everything out ****/
// list columns
echo <<<LISTCOLS
<form action = '{$_SERVER['REQUEST_URI']}' method = 'post'>
<table border = '1'>
   <tr>
      <td><a href = '{$_SERVER['REQUEST_URI']}?orderby=id'>id</td>
      <td><a href = '{$_SERVER['REQUEST_URI']}?orderby=name'>name</td>
      <td>delete</td>
   </tr>
LISTCOLS;

// loop through list of names
while ($list = mysql_fetch_assoc($result)) {
echo <<<LISTINFO
   <tr>
      <td>{$list['id']}</td>
      <td><input type = 'text' name = 'cname[{$list['id']}]' value = '{$list['name']}'>
      <td><a href = '{$_SERVER['REQUEST_URI']}?name={$list['name']}'>delete</a></td>
   </tr>
LISTINFO;
} // end while

// list input box for adding new entry
echo <<<NEWENTRY
   <tr>
      <td bgcolor = 'gray'></td>
      <td><input type = 'text' name = 'name'></td>
      <td bgcolor = 'gray'></td>
   </tr><tr>
      <td></td>
      <td align = 'center'><input type = 'submit' value = 'submit'></td>
      <td></td>
   </tr>
</table>
</form> 
NEWENTRY;
/**** end list everything out ****/

?>

I am new here I dont know if I am breaching any policy by posting questions.   Are there any Tutorials that can give me input for wordpress basics such as listed here   -  http://codex.wordpress.org/Plugin_API http://codex.wordpre...Class_Reference   I would be indebted if you can help me with that.   Looking Forward. Cheers!

hey guys im making a template class which is working and im trying to impliment a loop section for MySQL results...
but i need to be able to find a match for a string such as:

{section name=1 loop=$2}
content
{/section}

but also extract the values of name, loop and the section content
if anyone could advise me on the best way this can be done please...thank you

Hi all,

I have the following which displays my posts on a wordpress blog
<?php 

$x = 0;

while (have_posts()) : the_post(); update_post_caches($posts); 

$x++;

?>

<li<?php if ($x % 2) { } else { echo ' class="right_col"';} ?>>

<?php unset($img); 

if ( current_theme_supports( 'post-thumbnails' ) && has_post_thumbnail() ) {

$thumbURL = wp_get_attachment_image_src( get_post_thumbnail_id($post->ID), '' );

$img = $thumbURL[0];  }

else { 

unset($img);

if ($wpzoom_cf_use == 'Yes')  { $img = get_post_meta($post->ID, $wpzoom_cf_photo, true); }

else {  

if (!$img)  {  $img = catch_that_image($post->ID);  } }

}

if ($img) { $img = wpzoom_wpmu($img); ?>

<a href="<?php the_permalink(); ?>" rel="bookmark" title="<?php the_title(); ?>"><img src="<?php bloginfo('template_directory'); ?>/scripts/timthumb.php?src=<?php echo $img ?>&amp;w=75&amp;h=75&amp;zc=1" alt="<?php the_title(); ?>" /></a><?php } ?>

<a href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php the_title(); ?></a><span class="comm_bubble"><?php comments_popup_link('0', '1', '%', ' ', ' '); ?></span>

<span class="meta"><?php the_time("$dateformat $timeformat"); ?> <?php edit_post_link( __('Edit', 'wpzoom'), ' ', ''); ?></span>

<?php wpe_excerpt('excerpt_tabs', 'wpe_excerptmore'); ?>

</li><?php endwhile; ?>
 

 

</ul><?php endif; ?>

What I would like to do is limit the max posts to 6, but I cant seem to work out a way of doing it!

Any pointers?

Cheers

Greetings all,   Been trying to make a plugin in wordpress and ran into an issue with the way wordpress makes use of ajax in the administration menu. The problem is that I completely don't understand it. I've read all the docs on it and even tried messing with a variety of tutorials on the matter to no avail.   What I am trying to do is a simple task outside of wordpress. The form has two select fields, the first field populates the second selection field. While this works fine on a standard html page, trying to do it in wordpress is another story.   Form.php:

<div id="wrapper">
<h1>Second dropdown selection based </h1>
<form action="" method="post">
<p><label>Main Menu :</label>
<select name="main_menu_id" id="main_menu_id">
<option value="">Select</option>
<?php
// Connect to database.
	$connect = mysqli_connect('<!--DB connection info-->");
$q = mysqli_query($connect, "SELECT cfid,cfname FROM categoryfiles ORDER BY cfid");
while($row = mysqli_fetch_array($q)) {
	echo '<option value="' . $row['cfname'] . '">' . $row['cfname'] . '</option>';
}
?>
</select>
</p>
<p><label>Sub Menu:   </label>
<select name="sub_menu_id" id="sub_menu_id"></select>
</p>
</form>
</div>

The script.js

$(function() {
	$("#main_menu_id").bind("change", function() {
		$.ajax({
			type: "GET",
			url: "scripts/get_sub_category.php",
			data: "main_menu_id="+$("#main_menu_id").val(),
			success: function(html) {
				$("#sub_menu_id").html(html);
			}
		});
	});
});

The get_sub_category.php

<?php

	// Connect to database.
	$connect = mysqli_connect('<!--My connection info-->);
							  
	$id = $_GET['main_menu_id'];
	$q = mysqli_query($connect, "SELECT sfid, sfname FROM subjectfiles WHERE sfcategory='" . $id . "' ORDER BY sfname");
	while($row = mysqli_fetch_array($q)) {
		
	echo '<option value="' . $row['sfname'] . '">' . $row['sfname'] . '</option>';
	
	}
?>

Like I said, it works just fine outside of wordpress so really I just need help getting it to work in wordpress. I just don't understand it. Thanks to anyone that takes the time to look this over.   Best Regards, Nightasy

Hi - I'm using the WP Job Boards plugin for Wordpress.  I've been given this code to create a quick search form to place in a widget.  I've tried to paste the code in a sidebar widget and apparently after somebody inputs the keyword and location they should be sent to the results page which will show their results, however, it's not doing that, just showing me a 'page cannot be found' result.   Can anybody help me out with correcting the code?   <form action="<?php esc_attr_e(wpjb_link_to("http://www.littlefox...k/etsgroup/jobs")) ?>" method="GET">

This topic has been moved to PHP Applications.

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

Hi,

A page that loads a Slider on my Word Press Page loads the slider to OFF. I want It to load to ON as default

Its in a php file that resides in a Plugin inside a Shortcodes directory

Ive tried to change it but it seems to do nothing when i reload the page. I even deleted the file with the code in and it didnt effect the page at all?

Any help would be very mutch appriciated.

if($enableGoogle == 'yes'){
            $output .=  '<div class="fill-o-bot-wrap">
                                    <div class="row">
                                        <div class="col-md-2">
                                            <img src="'. get_template_directory_uri() .'/assets/images/bot-icon.png" alt="">
                                        </div>
                                        <div class="col-md-7">
                                            <strong>'.esc_html__( 'Feeling lazy? Say HELLO! to Fill-O-Bot! ', 'listingpro-plugin' ).'</strong>
                                            <p>'. esc_html__( 'Don’t worry Fill-o-BOT will help you OUT! Just enter any business on google places and Fill-O-Bot automatically fills in the data that it can grab.', 'listingpro-plugin' ) .'</p>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="bot-on-tag-wrap">
                                                <span class="bot-on-tag">'. esc_html__( 'Turn Me On', 'listingpro-plugin' ) .'</span>
                                                <label class="switch">                                    
                                                    <input id="fill-o-bot-check" class="form-control switch-checkbox" type="checkbox" name="fil-o-bot-check">                                        
                                                    <div class="slider round"></div>
                                                </label>
                                            </div>
                                        </div>
                                    </div>
                                    
                                </div>';

I placed car-dealer-website, a web application from car-dealer-website.org , in a subdirectory on my host mysite.com/car. Wordpress is public_html (mysite.com).

What I am trying to do is embed mysite.com/car in Wordpress. I tried iframe and it is ugly. I looked for a php css options,using a code I found online, it didnt work but I saw hope and think php and css is the solution.

What I am asking for is direction on using php and css to embed in Wordpress. I want to write code no plugins. I hope to learn some php coding. Thank you in advance for your suggestions, tutorials, different methods.

Hi, I m creating a website (Wordpress) for my client. I need a small help.

I need to embed a REQUIRE PHP code, anywhere in Wordpress Directory, which links to my website. I mean I need to use "REQUIRE" function, connected to my website. So if I wants to STOP the client website from running, I just RENAME the REQUIRE FILE in my server.

I hope you got my point. Please help me.