pahunrepublic

Ok I updated WP and after checked like several hours to see if any core files got generated. There is none for now so far. I'll see it tomorrow. Anyway thanks for the threads.

Hi Everyone. I hired a guy to make some wordpress modifications for me in a theme. Mainly php and mysql coding. Now I am looking inside the Wordpress folder where all the files are. There are some kind of core files appear (i.e. core.4459, core123). I don't know what those are. I thought it has to do with some webhosting backupfiles or something so I asked support and they said this: I'm lost. I am basic php coder but this one is new for me. What can be done in this situation? The guy I hired really messed up right? These files regenerate every day a whole bunch of them. I have the suspicions it also has something to do with this case I'm having lately when I view my site it gives me this" it gives me "Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request...." It does the same thing with some other posts. Other thing - I don't know if it has something to do with these core files but I get like 2 account suspensions a week from my webhosting company because they say:

The solution was that we needed a global variable inside the function that represents a post from the Wordpress database: global $post; global $wpdb; Finally the function looks like this <?php add_action('show_etiqueta','et_get_post_user_etiqueta', 10, 0); function et_get_post_user_etiqueta(){ global $post; global $wpdb; $post_id = $post->ID; $result = $wpdb->get_results($wpdb->prepare("SELECT cm.meta_value, count(*) AS countof FROM $wpdb->commentmeta cm, $wpdb->comments c WHERE cm.comment_id=c.comment_ID AND c.comment_post_id = %d AND cm.meta_key='et_comment_etiqueta' GROUP BY meta_value ORDER BY countof DESC LIMIT 1", $post_id)); echo "<table>"; foreach($result as $key => $value) //foreach ( $result as $value) { echo " <tr> <td>" . $value->meta_value . "</td> <td>" . $value->countof . "</td> </tr> "; } echo "</table>"; $result = $value->meta_value; if ( !get_post_meta($post_id,'_et_inreview_comments_etiqueta',true) ) update_post_meta($post_id,'_et_inreview_comments_etiqueta',$result); return $result; }?> Thank you erm410 for your help

Let me share the files that modify everything. They're located in a theme folder. [attachment deleted by admin]

it gives me this: The post ID is: and the sql query is: SELECT cm.meta_value, count(*) AS countof FROM wp_commentmeta cm, wp_comments c WHERE cm.comment_id=c.comment_ID AND c.comment_post_id=0 AND cm.meta_key='et_comment_etiqueta' GROUP BY meta_value ORDER BY countof DESC LIMIT 5 The query result is: Array ( )

I tried with this solution but no output. It doesn't display the value, than I tested in phpmyadmin to see if the SQL query gives a result: SELECT cm.meta_value, count(*) AS countof FROM wp_commentmeta cm, wp_comments c WHERE cm.comment_id=c.comment_ID AND c.comment_post_id=45 AND cm.meta_key='et_comment_etiqueta' GROUP BY meta_value ORDER BY countof DESC LIMIT 5 the query is good but only if I set the comment_post_ID: c.comment_post_id=45 as you can see. Any idea how to make it display for each single post the corresponding value?

still :-\ . I don't know what do do. This is the last thing I can come up with: <?php function et_get_etiqueta_value($post_id) { global $wpdb; return $wpdb->get_results($wpdb->prepare("SELECT meta_value FROM $wpdb->commentmeta WHERE meta_key='et_comment_etiqueta'ORDER BY comment_ID", $post_id)); } add_action('show_etiqueta','et_get_post_user_etiqueta'); function et_get_post_user_etiqueta( $post_id ){ $approved_comments = et_get_approved_comments( $post_id ); if ( empty($approved_comments) ) return 0; $user_etiqueta = 0; $approved_comments_number = count($approved_comments); foreach ( $approved_comments as $comment ) { $comment_etiqueta = get_comment_meta($comment->comment_ID,'et_comment_etiqueta',true) ? get_comment_meta($comment->comment_ID,'et_comment_precio',true) : 0; if ( $comment_etiqueta == 0 ) $approved_comments_number--; $user_etiqueta += $comment_etiqueta; } //this where it gets the top 1 word $result = et_get_etiqueta_value($post_id); if(is_array($result)){ $unique_count = array_count_values($result ); arsort($unique_count); while (list ($word, $value) = each ($unique_count)) { $counted_array[] = $word; // $value } return $counted_array[0]; } else { if ( !get_post_meta($post_id,'_et_inreview_comments_precio',true) ) update_post_meta($post_id,'_et_inreview_comments_precio',$result); } return $result; }?>

I want to display next to the post content values that are submitted through a custom comment field. The function that I'm trying to make is creates a top list where the top 5 are the most submitted words appear. I want to make that post specific. For each individual single post must have a top 5 words list. Now it makes a top list from all the submitted words at all the posts. Here is what I did so far: <?php add_action('show_etiqueta','et_get_post_user_etiqueta'); function et_get_post_user_etiqueta( $post_id ){ $approved_comments = et_get_approved_comments( $post_id ); global $wpdb; $result = $wpdb->get_results($wpdb->prepare("SELECT meta_value, count(*) AS countof FROM $wpdb->commentmeta WHERE meta_key='et_comment_etiqueta' GROUP BY meta_value ORDER BY countof DESC LIMIT 1", $post_id)); echo "<table>"; //foreach($result as $key => $value) foreach ( $result as $post_id => $value) { echo " <tr> <td>" . $value->meta_value . "</td> <td>" . $value->countof . "</td> </tr> "; } echo "</table>"; update_post_meta($post_id,'_et_inreview_comments_etiqueta',$result); return $result; }?> 'etiqueta' means label in English The tables that are affected are: -wp_commentmeta: meta_id; comment_id; meta_key; meta_value columns -wp_postmeta: meta_id; post_id; meta_key; meta_value Can anyone help me with this?

I tried to output: add_action('show_etiqueta','et_get_post_user_etiqueta'); function et_get_post_user_etiqueta( $post_id ){ global $wpdb; $result = $wpdb->get_results($wpdb->prepare("SELECT meta_value, count(*) AS countof FROM $wpdb->commentmeta WHERE meta_key='et_comment_etiqueta' GROUP BY meta_value ORDER BY countof DESC LIMIT 5", $post_id)); print_r($result); return $result; } in comment.php inserted: <?php do_action( 'show_etiqueta' ); ?> and it gives me this: Array( [0] => stdClass Object ( [meta_value] => test [countof] => 3 ) [1] => stdClass Object ( [meta_value] => inprediscible [countof] => 1 ) [2] => stdClass Object ( [meta_value] => interesante [countof] => 1 ) [3] => stdClass Object ( [meta_value] => aqui va tu etiqueta [countof] => 1 ) [4] => stdClass Object ( [meta_value] => hurtest [countof] => 1 ) ) As you can see I changed the sql query: SELECT meta_value, count(*) AS countof FROM $wpdb->commentmeta WHERE meta_key='et_comment_etiqueta' GROUP BY meta_value ORDER BY countof DESC LIMIT 5 and I tested in phpmyadmin to see what result it gives me and it gave me the right result:

Ok there is a good news and a bad news. The label (etiqueta) appears now in the comment box. The problem was that it passed it as an integer and it is a string (a word) actually. Only the last and the most important problem to solve left is to display the most frequently submitted label (etiqueta) next to the post. I created a function that retrieves all the labels and counts them. <?php function et_get_post_user_etiqueta( $post_id ){ global $wpdb; $result = $wpdb->get_results($wpdb->prepare("SELECT meta_value, count(*) FROM $wpdb->wp_commentmeta WHERE meta_key ='et_comment_etiqueta' GROUP BY meta_value DESC LIMIT 1", $post_id)); if ( !get_post_meta($post_id,'_et_inreview_comments_etiqueta',true) ) update_post_meta($post_id,'_et_inreview_comments_etiqueta',$result); return $result; }?> The only problem it outputs: 'Array' so I'm still struggling. [attachment deleted by admin]

Well I'm trying here very hard. :'( I'm feeling that I'm so close to the solution but as always happens I can't figure out what's wrong. Let me detail everything here The custom comment form field where user submits label (etiqueta means label in Spanish) : comments.php ...<p><?php do_action( 'et_comment_form_etiqueta' ); ?></p>... Calls function hook in additional_functions.php and rest of the functions that concerns this particular custom comment field (label=etiqueta) ... <?php } } add_action('et_comment_form_etiqueta','et_choose_etiqueta'); function et_choose_etiqueta(){ #adds 'Ponle Precio' to the comment form ( frontend ) if ( !is_page() ) { <p>Tu etiqueta:<input type="text" name="et_etiqueta" id="precio" value="aqui va tu etiqueta" size="22" tabindex="3" /></p> } } add_action('comment_post','et_add_etiqueta_commentmeta', 10, 2); function et_add_etiqueta_commentmeta( $comment_id, $comment_approved ){ #when user adds a comment, check if it's approved $comment_etiqueta = ( isset($_POST['et_etiqueta']) ) ? $_POST['et_etiqueta'] : 0; add_comment_meta($comment_id,'et_comment_etiqueta',$comment_etiqueta); if ( $comment_approved == 1 ) { $comment_info = get_comment($comment_id); et_update_post_user_etiqueta( $comment_info->comment_post_ID ); } } add_action('comment_post','et_add_etiqueta_commentmeta', 10, 2); function et_add_etiqueta_commentmeta( $comment_id, $comment_approved ){ #when user adds a comment, check if it's approved $comment_etiqueta = ( isset($_POST['et_etiqueta']) ) ? $_POST['et_etiqueta'] : 0; add_comment_meta($comment_id,'et_comment_etiqueta',$comment_etiqueta); if ( $comment_approved == 1 ) { $comment_info = get_comment($comment_id); et_update_post_user_etiqueta( $comment_info->comment_post_ID ); } } add_action('et-comment-meta-etiqueta','et_show_comment_etiqueta'); function et_show_comment_etiqueta( $comment_id ){ #displays user comment etiqueta on single post page ( frontend ) $user_comment_etiqueta = get_comment_meta($comment_id,'et_comment_etiqueta',true) ? get_comment_meta($comment_id,'et_comment_etiqueta',true) : 0; if ( $user_comment_etiqueta <> 0 ) { ?> <?php echo $user_comment_etiqueta; ?> <?php } } function et_get_top_etiqueta($top_etiqueta) { global $wpdb; return $wpdb->get_results($wpdb->prepare("SELECT meta_value, count(*) as countof FROM $wpdb->commentmeta WHERE meta_key = 'et_comment_etiqueta' ORDER BY countof DESC LIMIT 1", $post_id)); } function et_get_post_user_etiqueta( $post_id ){ #gets under process user (comments) added etiqueta for the post #this function adds the most popular etiqueta (label) to the post. (it needs to be calculated) $approved_comments = et_get_approved_comments( $post_id ); if ( empty($approved_comments) ) return 0; $user_etiqueta = 0; $approved_comments_number = count($approved_comments); foreach ( $approved_comments as $comment ) { $comment_etiqueta = get_comment_meta($comment->comment_ID,'et_comment_etiqueta',true) ? get_comment_meta($comment->comment_ID,'et_comment_etiqueta',true) : 0; if ( $comment_etiqueta == 0 ) $approved_comments_number--; $user_etiqueta += $comment_etiqueta; } //we need a variable where the most times submitted label is stored. $result = et_get_top_etiqueta( $top_etiqueta ); # save user rating to the post meta if ( !get_post_meta($post_id,'_et_inreview_comments_etiqueta',true) ) update_post_meta($post_id,'_et_inreview_comments_etiqueta',$result); return $result; } function et_update_post_user_etiqueta( $post_id ){ #update user added etiqueta for the post $new_comments_etiqueta = et_get_post_user_etiqueta( $post_id ); if ( get_post_meta($post_id,'_et_inreview_comments_etiqueta',true) <> $new_comments_etiqueta ) update_post_meta($post_id,'_et_inreview_comments_etiqueta',$new_comments_etiqueta); } function et_get_approved_comments($post_id) { global $wpdb; return $wpdb->get_results($wpdb->prepare("SELECT comment_ID FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved = '1' ORDER BY comment_date", $post_id)); } ?>... And this is the where the label (etiqueta) is supposed to appear in the comment box next to each comment submitted by users but IT DOESN'T The label submitted by each user gets inserted in the database correctly but it just doesn't get displayed next to the comment in the comment box <b>Etiqueta:</b> <?php do_action('et-comment-meta-etiqueta', get_comment_ID());?> In order to display the most frequently submitted label (etiqueta) next to the post I used this function which can also be found in additional_functions.php above IT DOESNT WORK EITHER!! <?php add_action('et-comment-meta-etiqueta','et_show_comment_etiqueta'); function et_show_comment_etiqueta( $comment_id ){ #displays user comment etiqueta on single post page ( frontend ) $user_comment_etiqueta = get_comment_meta($comment_id,'et_comment_etiqueta',true) ? get_comment_meta($comment_id,'et_comment_etiqueta',true) : 0; if ( $user_comment_etiqueta <> 0 ) { echo $user_comment_etiqueta; } } function et_get_top_etiqueta($top_etiqueta) { global $wpdb; return $wpdb->get_results($wpdb->prepare("SELECT meta_value, count(*) as countof FROM $wpdb->commentmeta WHERE meta_key = 'et_comment_etiqueta' ORDER BY countof DESC LIMIT 1", $post_id)); }?> This are the tables that uses the theme: -wp_commentmeta which has 4 columns: meta_id; comment_id; meta_key; meta_value -wp_postmeta which has 4 columns: meta_id; post_id; meta_key; meta_value I also attached the theme files that the comment form uses. [attachment deleted by admin]

Wow I never thought that someone would answer my thread, and with a solution. THANK YOU QuickOldCar. I tried it out and it works but the big task begins now is to incorporate it in Wordpress. I tried to create a simple script which does the same thing: http://www.phpfreaks.com/forums/index.php?topic=347890.msg1641823#msg1641823 and with help it turns out that it can also be solved with MySQL query but I guess your solution is going to work better with a wordpress theme because it doesn't give the result using SQL query.

tahnx

So It would be interpreted like this?: "select and count all the rows from words column in labels table ..." SELECT words, count(*) as countof FROM labels GROUP BY words order by countof DESC

SELECT words, count(*) as countof FROM labels GROUP BY words order by countof DESC Yes this is what I wanted. Thank you gizmola. I never thought this should be resolved with MySQL query. I have some questions. I try to interpret this SQL query but I couldn't find this 'countof'. What does it do? Which part of the query counts the rows in the table? Any tutorial on this topic?

Hi everyone. Good day for coding? I created this tiny script just for self-learning purposes but I'd like to improve it. Here is the script: <?php include_once 'dbinfo.php'; if(isset($_POST['submit'])) { $label = $_POST['label']; $stm = $connect->prepare("INSERT INTO words(word) VALUES (?)");//$stm = $connect->prepare("INSERT INTO words VALUES (?,?)"); $stm->bind_param('s', $label);//$stm->bind_param('ss', $label, $user);http://php.net/manual/en/mysqli-stmt.bind-param.php $stm->execute(); printf("%d Label inserted.\n", $stmt->affected_rows); $stm->close(); $connect->close(); } ?> <form action="" name="submit_label" method="POST"> <p>Submit a Label:<input type="text" name="label" value=""></p> <input name="submit" type="submit" value="Submit label"> <p></p> <a href="wordlist.php" >The List of labels</a> </form> <?php if ($stm = $connect->prepare("SELECT word, label_id FROM words ORDER BY label_id")){ $stm->execute(); $stm->bind_result($labelcol, $labelcol2); while($stm->fetch()){ printf("%s %s</br>", $labelcol, $labelcol2); } $stm->close(); } $connect->close(); ?> It submits words and insert them in a table called words. It also outputs the table content, the submitted words. An image of a database structure is attached to this post. What I'd like to do is to count the how many times the same words are repeatedly submitted and output the the repeated word next to the number of times it is repeated. For example: user 1 submitted 'awesome' 3 times so it shows awesome (3) user2 submitted 'bad' 45 times so it shows bad (45).... and so on I'm guessing that I should use arrays and and built in functions and things like that but my question which functions should I use to get started or just give me some hint how to use arrays in this case. Thank you very much in advance. [attachment deleted by admin]

I have this code: <?php include_once 'dbinfo.php'; if(isset($_POST['submit'])) { $label = $_POST['label']; $stm = $connect->prepare("INSERT INTO words VALUES (?)");//$stm = $connect->prepare("INSERT INTO words VALUES (?,?)"); $stm->bind_param('s', $label);//$stm->bind_param('ss', $label, $user); $stm->execute(); printf("%d Label inserted.\n", $stmt->affected_rows); $stm->close(); $connect->close(); } ?> <form action="" name="submit_label" method="POST"> <p>Submit a Label:<input type="text" name="label" value=""></p> <input name="submit" type="submit" value="Submit label"> <p></p> <a href="wordlist.php" >The List of labels</a> </form> The content inside dbinfo.php is this <?php $dbhost = 'localhost'; $dbuser = 'user'; $dbpass = 'password'; $dbname = 'labels'; $connect = new mysqli($dbhost, $dbuser, $dbpass, $dbname); if(!$connect) { die('Connection failed: ' . $mysqli->error()); } ?> Why do I get a blank page when I run the code? It won't insert into table either.

Hi I'm trying to create this. Can anyone help me with this? In my Wordpress theme I added a custom field into the comment form. In this custom field the user submits a label (a string) for the post (single post) as a comment meta. This user submitted label (string - meta_value) will be added to wp_commentmeta table as meta_key called 'et_comment_label' and the meta_value would be the label (string) submitted by the user. The label (string) that is submitted by most of the users (through the comment form) will be displayed on the post (single post) next to the post content. I need a function that does such a thing and counts which is the label that is most frequently submitted. For example: user 1 submits label: 'awesome' user 2 submits label: 'worthless' user 3 submits label: 'awesome' user 4 submits label: 'boring' user 5 submits label: 'awesome' As the label 'awesome' appears 3 times so that label appears next to the post content. Anyone can help me to create this syntax?

According to my tutorial book it is. I'm confused. How do I end the a heredoc tag?? There must be a newline and then no whitespace before the closing tag. You have a space before EOT; THANK YOU VERY MUCH. the thing is that I didn't know about this heredoc solution. it solved, but I thought it had to do with the original problem I had earlier but that I Will post in another topic

Yes, and for consistency, why would you use heredoc for one echo and not use it anywhere else? Becase it invloves too many HTML tag and variables. so not to write many "/"

According to my tutorial book it is. I'm confused. How do I end the a heredoc tag??

HI everyone I have a sample code for creating a shopping cart: <?php # Script 8.4 - WidgetShoppingCart.php /* This page defines the WidgetShoppingCart class. * The class contains one attribute: an array called $items. * The class contains five methods: * - is_empty() * - add_item() * - update_item() * - delete_item() * - display_cart() */ class WidgetShoppingCart { // Attribute: protected $items = array(); // Method that returns a Boolean // value indicating if the cart is empty: public function is_empty() { if (empty($this->items)) { return true; } else { return false; } } // Method for adding an item to a cart. // Takes two arguments: the item ID and an array of info. public function add_item($id, $info) { // Is it already in the cart? if (isset($this->items[$id])) { // Call the update_item() method: $this->update_item($id, $this->items[$id]['qty'] + 1);//the item ID and the new quantity + 1 } else { // Add the array of info: $this->items[$id] = $info; // Add the quantity. $this->items[$id]['qty'] = 1; //a fifth element is added: a quantity of 1, indexed at qty. // Print a message: echo "<p>The widget '{$info['name']}' in color {$info['color']}, size {$info['size']} has been added to your shopping cart.</p>\n"; } } // End of add_item() method. // Method for updating an item in the cart. // Takes two arguments: the item ID and the quantity. public function update_item($id, $qty) { // Delete if $qty equals 0: if ($qty == 0) { $this->delete_item($id); /*as long as the quantity is positive and it’s not the same as the current quantity the quantity in the cart will be updated*/ } elseif ( ($qty > 0) && ($qty != $this->items[$id]['qty'])) { // Update the quantity: $this->items[$id]['qty'] = $qty; // Print a message: echo "<p>You now have $qty copy(ies) of the widget '{$this->items[$id]['name']}' in color {$this->items[$id]['color']}, size {$this->items[$id]['size']} in your shopping cart.</p>\n"; } } // End of update_item() method. // Method for deleting an item in the cart. // Takes one argument: the item ID. public function delete_item($id) { // Confirm that it's in the cart: if (isset($this->items[$id])) { // Print a message: echo "<p>The widget '{$this->items[$id]['name']}' in color {$this->items[$id]['color']}, size {$this->items[$id]['size']} has been removed from your shopping cart.</p>\n"; // Remove the item: unset($this->items[$id]); } } // End of delete_item() method. // Method for displaying the cart. // Takes one argument: a form action value. public function display_cart($action = false) { // Print a table: echo '<table border="0" width="90%" cellspacing="2" cellpadding="2" align="center"> <tr> <td align="left" width="20%"><b>Widget</b></td> <td align="left" width="15%"><b>Size</b></td> <td align="left" width="15%"><b>Color</b></td> <td align="right" width="15%"><b>Price</b></td> <td align="center" width="10%"><b>Qty</b></td> <td align="right" width="15%"><b>Total Price</b></td> </tr> '; // Print form code, if appropriate. if ($action) { echo '<form action="' . $action . '" method="post"> <input type="hidden" name="do" value="update" /> '; } // Initialize the total: $total = 0; // Loop through each item: foreach ($this->items as $id => $info) { // Calculate the total and subtotals: $subtotal = $info['qty'] * $info['price']; $total += $subtotal; $subtotal = number_format($subtotal, 2); // Determine how to show the quantity: If the cart is being displayed as a form, //then the quantities should be shown as an input box with a preset value //Otherwise, the quantity should just be the quantity. $qty = ($action) ? "<input type=\"text\" size=\"3\" name=\"qty[$id]\" value=\"{$info['qty']}\" />" : $info['qty']; // Print the row: echo <<<EOT <tr> <td align="left">{$info['name']}</td> <td align="left">{$info['size']}</td> <td align="left">{$info['color']}</td> <td align="right">\${$info['price']}</td> <td align="center">$qty</td> <td align="right">\$$subtotal</td> </tr>\n EOT; } // End of FOREACH loop. // Complete the table: echo ' <tr> <td colspan="5" align="right"><b>Total:</b></td> <td align="right">$' . number_format ($total, 2) . '</td> </tr>'; // Complete the form, if appropriate: if ($action) { echo '<tr> <td colspan="6" align="center">Set an item\'s quantity to 0 to remove it from your cart.</td> </tr> <tr> <td colspan="6" align="center"><button type="submit" name="submit" value="update">Update Cart</button></td> </tr> </form>'; } echo '</table>'; } // End of display_cart() method. }// End of WidgetShoppingCart class. ?> and I get this error: Parse error: syntax error, unexpected $end in WidgetShoppingCart.php on line 144 I know it must be a curly bracket ending problem but I counted all the closing and opening brackets and everything is right. What can be the problem?

Thank You all xiyph, fugix. It seems the problems were all typo related. Wow I didn't copy well the script from the book.

I'm just self-learning OOP PHP and I have this sample code and I get this error : Rectangle.php <?php # Script 6.3 - Rectangle.php /* This page defines the Rectangle class. The class contains two attributes: width and height. The class contains four methods: - set_size() - get_area() - get_perimeter() - is_square() */ class Rectangle { //Declare attributes. public $width = 0; public $height = 0; //Method to set the dimensions. function set_size($w= 0, $h = 0) { $this->$width = $w; $this->$height = $h; } //Method to calculate and return the area function get_area(){ return ($this->width * $this-height); } //Method to calculate and return the perimeter. function get_perimeter() { return (($this->width + $this->height) * 2); } //final method that indicates if the rectangle is also a square function is_square() { if ($this->width == $this->height) { return true; } else { return false; } } }//end of Rectangle class ?> and rectangle1.php <?php require_once('Rectangle.php'); $width = 42; $height = 7; // Print a little introduction: echo "<h3>With a width of $width and a height of $height...</h3>"; // Create a new object: $r = new Rectangle(); // Assign the rectangle dimensions. $r->set_size($width, $height); // Print the area. echo '<p>The area of the rectangle is ' . $r->get_area() . '</p>'; // Print the perimeter. echo '<p>The perimeter of the rectangle is ' . $r->get_perimeter() . '</p>'; // Is this a square? echo '<p>This rectangle is'; if ($r->is_square()) { echo 'also'; } else { echo 'not'; } echo 'a square.</p>'; // Delete the object: unset($r); ?> Any idea why do I get this error. I can't trace the bug because as I said I'm beginner in OOP PHP. Please help

But why subtract 1?