Export large database to file without mysqldump, low memory footprint

I am exporting a large database and wanted to know the best way to make it have a low memory footprint.
I realize that I must do this in cycles that have a time limit and use low memory, fetching say 100 rows at a time and saving the information to the file then redirect to [...]

canvas toDataUrl() how to get base64 result into and out a msql blob field

Can someone help me
I want to store the canvas image into a blob field
on the serverside I receive a base64 encoded string from toDataUrl()

What do I have to do to get it into a blob field

And how do I display it again in an img tag

what code do I need to use?
the mysql page is [...]

PHP Swift mailer: Failed to authenticate on SMTP using 2 possible authenticators

When I send an email with the PHP Swift mailer to this server: smtp.exchange.example.com like this:
/ Load transport
$this->transport =
Swift_SmtpTransport::newInstance(
self::$config->hostname,
self::$config->port
)
->setUsername(self::$config->username)
->setPassword(self::$config->password);

// Load mailer
$this->mailer = Swift_Mailer::newInstance($this->transport);

// Initialize message
$this->message [...]

Reasons for using a javascript MVC framework over PHP Yii?

I’m starting to write a web site from scratch using PHP Yii maintained by me only. My main concern is maintainability.
What are the reasons for using a javascript MVC framework (like AngularJs or EmberJs or KnockoutJs) over PHP Yii?
I haven’t tried Yii MVC or any of those JS frameworks yet.

Struggling to display blob image with php

I am building a simple website, I want to allow the users to upload and change their avatars. At present I have been able to upload images to a mysql database, stored as blobs with the code as follows:
//connected to DB, userID fetched

$image = $FILES['fileToUpload']['tmp_name'];
$fp = fopen($image, ‘r’);
$content = fread($fp, filesize($image));
$content = addslashes($content);
fclose($fp);

$sql = “UPDATE [...]

In my Apache Server I can’t seem to be getting mod_rewrite to work for some reason

In Apache I have the following setup in the config file:
LoadModule rewrite_module modules/mod_rewrite.so

DocumentRoot “C:/mywebdev/apache/www”
RewriteEngine On
Include conf/extra/httpd-vhosts.conf

<Directory “C:/mywebdev/apache/www”>
Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from All
</Directory>

I have the following in my vhosts config
<Directory “C:/mywebdev/apache/www/test”>
Options [...]

Understandin PHP 404 redirection related to invalid get request

Ok, am using traditional php, no frameworks, nothing, I am using simple procedural way, now my question is I was searching for a while but am not getting an answer to my question, I am not using .htaccess files as of now, but I really need to understand how 404 error works? I am having [...]

PHP Equivalent to Authorized ASP.NET WebMethod (AJAX)?

It’s rare, but I have to pay MS a compliment: the ASP.NET WebMethod (AJAX) authorization is a dream, regarding my desire for security and laziness.
Encosia’s ASP.NET page methods are only as secure as you make them absolutely fits those needs. ASP.NET is actually workable for me now. Free at last! (From the noble [...]

Get data from a facebook page wall or group wall for use on personal website

I want to connect to public facebook page or group and list all entries from the wall on a personal website. I will use PHP on my server so that would be the best solution for me. Or javascript.
Could anyone explain or perhaps give a working code on how to do this? Or just all [...]

DirectoryIterator to RecursiveDirectoryIterator

I’m trying to create a simple file browser which I can do with DirectoryIterator, but that doesn’t tell me how many files are in each directory.
How can I convert the example below to use RecursiveDirectoryIterator, so I can output the total number of files within each linked directory?
define(‘ROOT’, ‘/path/to/somewhere’);
$cwd = ROOT;

if(isset($_GET['path']) && is_dir($cwd.$_GET['path'])) {
[...]

Hire Me
Follow Me!
Search
Most Popular Articles & Pages
Because your vote is Important
Sorry, there are no polls available at the moment.
Categories