if you mean bulk insert, please follow the example given below. CREATE TABLE example ( example_id INT NOT NULL, name VARCHAR( 50 ) NOT NULL, value VARCHAR( 50 ) NOT NULL, other_value VARCHAR( 50 ) NOT NULL ) INSERT INTO example VALUES (100, ‘Name 1’, ‘Value 1’, ‘Other 1’), (101, ‘Name 2’, ‘Value 2’, ‘Other … Read more
Many ways to do this, here’s a functional one explicitly comparing the ‘id’ keys: $ids = array_map(function ($i) { return $i[‘id’]; }, $array2); $outarray = array_filter($array1, function ($i) use ($ids) { return !in_array($i[‘id’], $ids); }); More beginner friendly implementation, doing the same thing: $ids = array(); foreach ($array2 as $value) { $ids[] = $value[‘id’]; } … Read more
How about populating a div using javascript? Most users that will hack your theme/code won’t understand where its coming from. Try something like appending the div to your body tag so even the div isn’t written in html of your code. This might prevent a lot of efforts to remove the credits. What are you … Read more
If you already know Jquery You can use PHP Query : http://code.google.com/p/phpquery/ You can also find enough documantation there. 2 solved Disassemble the HTML code on the tag blocks with PHP [duplicate]
Well there is always the concept of passing a variable to the $_SESSION array, but it really depends on the case you need. For example if you need to keep information about the currently logged in user, you could save it as an object and assign it `$_SESSION[‘user’] = $user’. Otherwise, if you want to … Read more
You need to test if Title is actually set. That error occurred because no request with that data was sent. if(isset($_POST[‘Title’])) $Title = mysql_real_escape_string($_POST[‘Title’]); If it still doesn’t work, it means there is something wrong with how you are sending the data over solved Index Undefined in Second php code block [duplicate]
As per the wordpress documentation. This should get you started: <ul> <?php $args = array( ‘posts_per_page’ => 5, ‘offset’=> 1, ‘category’ => 1 ); $myposts = get_posts( $args ); foreach ( $myposts as $post ) : setup_postdata( $post ); ?> <li> <a href=”https://stackoverflow.com/questions/21582661/<?php the_permalink(); ?>”><?php the_title(); ?></a> </li> <?php endforeach; wp_reset_postdata();?> </ul> And for further … Read more
There are 2 parts you want to consider: Finding as much information as you can. about the script Actually exploiting it. Jihnesh was talking about the first part. In the example Jignesh gave, you find out that the script is using MySQL, information about the server / files, and that he doesn’t check the category … Read more
You can use this query SELECT t1.* FROM first_tbl AS t1 LEFT JOIN second_tbl AS t2 ON t1.order_number = t2.order_number WHERE t2.ID IS NULl And it will return only the 333333 record See this DB fiddle for example This is how it would look in CI: $this->db->select(“t1.*”) $this->db->from(“first_tbl AS t1”); $this->db->join(“second_tbl AS t2 “, “t1.order_number … Read more
Using foreach() you could do something like… foreach ( $phpObjekt->products as $product ) { //Speicherung der Daten in Variabeln $productId = $product->id; // … foreach ( $product->categories as $category ) { $categoryID = $category->id; // .. } } solved PHP Print all objects of an array in an array
/\s\–\s/ will find space dash space. Use that to replace it with a single space. solved How to remove dash between spaces using regex? [closed]
Have a look at the preg_match() PHP function in the manual. Quick Example: <?php // Check if the string is at least 8 chars long if (strlen($password) < 8) { // Password is too short } // Make the password “case insensitive” $password = strtolower($password); // Create the validation regex $regex = ‘/^[a-z][\w!@#$%]+\d$/i’; // Validate … Read more
You can accomplish the same with UPDATE query UPDATE tablename SET points = points + 5 WHERE email=”your_email_here” solved adding “5” to INT [closed]
use foreach foreach($arr as $element){ echo $element[0]; echo $element[1]; } 1 solved how i can browse a JSON object
Maybe you just wrong posting your data? Check what is in $_POST[‘number’]. echo $_POST[‘number’]; You can always check your whole $_POST array, maybe you just made a mistake in your variable name? If you want to do it: echo “<pre>”; print_r($_POST); echo “</pre>”; There is no input in your code with name=”number” You need something … Read more