You might want to check out some of the string functions: <?php for ($i = 5; $i > 0; $i–) { echo str_repeat(‘ ‘, 5 – $i).str_repeat(‘*’,$i).PHP_EOL; } for ($i = 5; $i > 0; $i–) { echo str_pad(str_repeat(‘*’,$i),5,’ ‘,STR_PAD_LEFT).PHP_EOL; } This runs on the command line, like so: php filename.php 0 solved Pyramid asterisk … Read more
If you need to update an existing table, check out this guide: http://www.w3schools.com/sql/sql_update.asp Edit: To update a table in SQL you would use a query that looks like this: UPDATE table_name SET column1=value1,column2=value2,… WHERE some_column=some_value; –This line is not necessary. –You can add this if you wish to only update certain rows –e.g WHERE Date … Read more
Your code checks, if value of key username of superglobal array SESSION isn’t empty, and if so, then it saves it’s value into variable $username. If you want to display it’s value, you can use echo($_SESSION[“username”]); to directly get it from SESSION or, when setting username from session to variable $username (as in your code) … Read more
You can’t include a PHP file in an HTML file. You need to change the extension of the HTML to PHP and use include(). <?php include ‘form2.php’; ?> That is the easiest way to do it. 3 solved Call PHP file inside an HTML without using input tag
As far as I know this MAPI extension is part of the Zafara Community Edition. You need to download the package for your distro, or the source package. I’m not sure how compatible this is with stock PHP, see the requirements in their manual. solved php mapi extension [closed]
Use the information_schema meta-DB: SELECT COLUMN_NAME FROM information_schema.TABLES WHERE (TABLE_SCHEMA=’Yourdb’) AND (TABLE_NAME = ‘Yourtablename’) solved Echo name of fields from MySQL table to web page [closed]
mkasberg provided the solution: $in = 72; $out = array(); $a = array_reverse(str_split((string)decbin($in))); foreach($a as $k => $v){ if ($v != “0”) array_push($out, pow(2,$k)); } 0 solved How do I return an integer array the sum of which equals to a given number in php? [closed]
create .htaccess file then copy the code below change ‘project_folder_name’ of the folder of your project if your project is in the root folder just put “https://stackoverflow.com/” <IfModule mod_rewrite.c> RewriteEngine On RewriteBase /project_folder_name # Removes index.php from ExpressionEngine URLs RewriteCond %{THE_REQUEST} ^GET.*index\.php [NC] RewriteCond %{REQUEST_URI} !/system/.* [NC] RewriteRule (.*?)index\.php/*(.*) /$1$2 [R=301,NE,L] # Directs all EE … Read more
You can json_decode that json string and then use array_filter method to filter regions $regions = json_decode(‘{“regions”: [ { “id”: 1, “name”: “Region 1”, “state_id”: 1, “areas” :[ { “id”: 1, “name”: “area 1”, “region_id”: 1 },{ “id”: 2, “name”: “area 2”, “region_id”: 1 }] },{ “id”: 2, “name”: “Region 2”, “state_id”: 1, “areas” :[{ … Read more
Using the variables into your example you can do this $i = 0; while ($i <= 3) { $varName=”var”.$i; if ($$varName > $var) { echo $$varName; } $i++; } But that is no right way to iterate over an array. There exists a million other ways to iterate over a bunch of variables and print … Read more
The error you see is a JS error, which means that either there’s a problem with your JS code (perhaps some other part of the front end code you’re not showing us is flawed). Alternatively, the PHP value is causing problems. The way to easily insert PHP values in JS is through JSON: var tmp … Read more
Probably best to do this as a single piece of SQL:- UPDATE stock a INNER JOIN order b ON a.part = b.part SET a.available = a.available – b.qty WHERE b.invoice` = ‘$order’ Watch out that you don’t just rerun this multiple times without some way of checking that an order hasn’t already been used to … Read more
I figured it out. Just use ob_start(), and loop through each user. Select the posts they’re subscribed to. Then inside the loop email it to each user. I used this query SELECT articles.* FROM articles INNER JOIN subscriptions ON articles.from_id = subscriptions.sub_to INNER JOIN users ON subscriptions.user_id = users.id WHERE users.email = :email 5 solved … Read more
select sum(case when Column2 = ‘somevalue’ then Column1 else 0 end) * 100 / sum(Column1) from NAMES; See this:- Select percentage of rows that have a certain value – SQL 0 solved SQL for calculating percentage of values for same column [closed]
As I said in my answer to your previous question, you can fix this easily by using single quotes on the inside. PHP Code <?php $eff=40; $pos=34; $i = ‘hello’; $line=exec(“tail $i.dssp -n $eff | awk -F’ ‘ -v var=$pos ‘{if ($2==var) print FNR}'”); print “$line\n”; ?> Sample Input (hello.dssp): foobar 34 Sample Output: 1 … Read more