I am hard coding my site title at the moment but want to make it dynamic as every page requires header.php so every page has the same title tag. I currently define it in the config file like this:

define('SITENAME', 'My Website');

Select all Open in new window

But for example, on the contact page I might want it to just say 'My site | Contact us'. Obviously this is a contrived example but I am trying to keep this simple.

Not sure if I should store page titles and meta description etc. in the database or just use a switch statement in the config file to say if the page is this then the title is this, or if the page is that then the title is that etc.

Any suggestions welcome!

Hi:
I am getting the error "Unknown column 'cr_tags.tag' in 'field list'" when executing the code.
I first built the code for two tables and I got the results that I expected; however, when I added the third table I got this result.
Any ideas why this is, and how to resolve 'cr_tags.tag' in the code?

MySQL version: 5.7.19
PHP version: 7.0.27
APACHE: 2.4.25

Table: cr_name
Columns: id (int 10), name (varchar 70)
Values:
id      name
---------------------
424     name 1
425     name 2
426     name 3
427     name 4
428     name 5
429     name 6

Table: cr_notes
Columns: id (int 10), notes (varchar 500)
Values:
id      notes
---------------------
424     notes 1
425     notes 2
426     notes 3
427     notes 4

Table: cr_tags
Columns: id (int 10), tag (varchar 30)
Values:
id      tag
------------------
424     tag 1
425     tag 2
426     tag 3
428     tag 5

Desired output:
id        name     notes        tag
--------------------------------------------
424     name 1
425     name 2  notes 2
426     name 3  notes 3     tag 3
427     name 4  notes 4
428     name 5                    tag 5
429     name 6

Actual output:
"Unknown column 'cr_tags.tag' in 'field list'"

$sel = "(SELECT cr_name.id AS rank, cr_name.name, cr_notes.notes, cr_tags.tag
FROM cr_name
LEFT JOIN cr_notes
ON cr_name.id = cr_notes.id
WHERE cr_name.id > 423)

UNION

(SELECT cr_name.id AS rank, cr_name.name, cr_notes.notes, cr_tags.tag
FROM cr_notes
RIGHT 

Select all Open in new window

…

<?php


if(!empty($_FILES)){
    
    //database configuration
    $company = $_GET['company'];
    $dbHost = 'localhost';
    $dbUsername = 'root';
    $dbPassword = 'billadmin2006';
    $dbName = 'inventas';
    //connect with the database
    $conn = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
    if($mysqli->connect_errno){
        echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
    }
    
    $targetDir = "uploads/";
    $fileName = $_FILES['file']['name'];
    $fileSize = $_FILES['file']['size'];
    $targetFile = $targetDir.$fileName;
    
    if(move_uploaded_file($_FILES['file']['tmp_name'],$targetFile)){
        //insert file information into db table
        $conn->query("INSERT INTO documents (companyName, f_name, d_date, f_size) VALUES('".$company."','".$fileName."','".date("Y-m-d H:i:s")."','".$fileSize."')");
    }
    
}
?>

Select all Open in new window

The $company = $_GET['company']; is just not getting added to my database. The url is fine - the GET value is correct. If I set the $company = 'test'; it works. I am only using GET to test - I would usually use POST
Could I use a session variable - if so how do I set a session variable that can be used in multiple pages as a variable for database input

I'm a few months away from starting to take on Freelancing gigs.

I was wondering how to do my books/bill clients.

I had a fantasy about using Laravel to create a separate site on a subdomain that would bill clients and export a CSV. But I've been thinking about using Freshbooks.

I will probably offer subscription services (hosting/maintenance) which I want to bill using the web.

My website will be WordPress.

I'm not sure how to handle billing, and I want to have a good system down when I start. I know that Freshbooks has an API.

What would be the best way to handle this?

I am trying to find an online software or API that I can use to create PDFs online

I need something server side. I have a base PDF to work with.
I am using PHP, but that can be negotiable.
I need to mail merge the fields and generate a completed PDF for my client to view.

Any suggestions on software out there?

I used form maker to create a form that pops up after 15 seconds on certain pages. The problem is when I click to close the box, it automatically take me to a page that says OOPs that page can't be found. It's directing it to a website that's in my footer link, after my domain. In other words my site is 101realestateinvesting.com but it redirects it to the link in my footer as part of my domain 101realestateinvesting.com/www.linkinfooter.com

I have hundreds of already uploaded photos and want to compress their size. Without having to download them all, compress them and upload them again, is there some way of compressing all images in a particular folder already on a live server?

Hi,

I am trying to make a submission via PHP Curl.

I need to submit a csv file as part of the body (using a bearer token for security)

I am having issues getting it to submit being told that my data has to be an array, -= Could anyone please advise where I am going wrong?

I did have an issue where I was getting a 0 status, returned, but once I encoded the variable $fielddata - I am now getting back an error from the API basically saying that I need to provide data in an array.  The only thing I can think of is the curl_file might be wrong?

basically I am just trying to submit the file that is in the same directory as the php file I am running.

$template = "Hi {{name}}! Click here {{url}} to enter our portal({{amount}}).";
$cfile = new CURLFile('meekimoney.csv','text/csv','meekimoney');
//$cfile = curl_file_create('meekimoney.csv','text/csv','meekimoney.csv');
// Assign POST data
echo "<br><br>";
$fielddata = array('file' => $cfile, 'name' => $nameofcampaign, 'template' => $template );
$data_json = json_encode($fielddata);
$headers = array();
$headers[] = "Authorization: Bearer ".$Bearer;
//$headers[] = "Cache-Control: no-cache";
//$headers[] = "Postman-Token: 202fee3b-9efd-48fe-9d98-483b7f9ebb64";
$headers[] = "Content-Type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW";
//$headers[] = "Content-Type: application/json; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW";
//boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW";
$ch = 

Select all Open in new window

…

I want to add a link in my footer but it prints out the <a href=""> in the footer. How can I add a link in my footer?

This is the contents of my footer.php file:

<?php
/**
 * The template for displaying the footer.
 *
 * Contains the closing of the #content div and all content after
 *
 * @package wpre
 */
?>

	</div><!-- #content -->

	<?php get_sidebar('footer'); ?>

	<footer id="colophon" class="site-footer" role="contentinfo">
		<div class="site-info container">
			
			<span class="sep">
                			<?php echo ( get_theme_mod('wpre_footer_text') == '' ) ? ('&copy; '.date_i18n(__('Y','wp-real-estate')).' '.get_bloginfo('name').__('. All Rights Reserved. ','wp-real-estate')) : esc_html( get_theme_mod('wpre_footer_text') ); ?>
            </span>
		</div><!-- .site-info -->
	</footer><!-- #colophon -->
	
</div><!-- #page -->


<?php wp_footer(); ?>

</body>
</html>

Select all Open in new window

How can I add a link in the file?

I have Magento 1.9 website with PHP 5.6.31 running on Windows IIS. Intermittently the website would have server 500 error, and more than 20 PHP CGI/FastCGI background processes running. The website will recover if its application pool restarted. I found there was Application Error in Event Viewer when the server 500 error first happened.

Faulting application name: php-cgi.exe, version: 5.6.31.0, time stamp: 0x595dca20
Faulting module name: php_wincache.dll, version: 1.3.7.12, time stamp: 0x58234af4
Exception code: 0xc0000005
Fault offset: 0x00015147
Faulting process id: 0x29d8
Faulting application start time: 0x01d432075ec736f9
Faulting application path: C:\Program Files (x86)\PHP\v5.6\php-cgi.exe
Faulting module path: C:\Program Files (x86)\PHP\v5.6\ext\php_wincache.dll
Report Id: 022fa75d-9dfd-11e8-80cb-000d3aa18ac6
Faulting package full name: 
Faulting package-relative application ID: 

Select all Open in new window

Could it be the Application Error is the issue that caused server 500 error? How to fix this issue?

This is a follow-on to this question - https://www.experts-exchange.com/questions/29113292/Need-To-Know-Syntax-To-Display-Attribute-On-Checkout-Page.html

I need to know how to make this show attributes dynamically to whatever is in the shopping cart on the checkout page.

Thanks,

Hi,

Could someone please help me.

What i need to do, is convert the below to a proper snippet I can use in my php to do the curl post and post up different field values as required.  I exported this from postman.


your help is very much appreciated!!

<?php

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => "http://someapi.com",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => "------WebKitFormBoundary7MA4YWxkTrZu0gW\r\nContent-Disposition: form-data; name=\"template\"\r\n\r\nHi {{name}}! Click here {{url}} to pay your outstanding account.\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW\r\nContent-Disposition: form-data; name=\"file\"; filename=\"C:\\xampp\\htdocs\\test.csv\"\r\nContent-Type: text/csv\r\n\r\n\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW\r\nContent-Disposition: form-data; name=\"name\"\r\n\r\nTESTUPLOAD-1\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW--",
  CURLOPT_HTTPHEADER => array(
    "Authorization: Bearer XYZ",
    "Cache-Control: no-cache",
    "Postman-Token: 137a61fa-24dc-493e-9686-5e455d4d8a78",
    "content-type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW"
  ),
));

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

Select all Open in new window

I'm looking for a PHP bootcamp but mostly I find Ruby. Is there any good online PHP bootcamps that arent Udemy or some other video-only school?