Search:

Is it not possible to have multiple foreign keys referencing the same column in one table? I keep getting 'ERROR 1005: Can't create table (errno: 121)' on MySQL 5.5

For example:


CREATE TABLE...

Looking for a backup tool that runs in windows and can connect to a remote mysql server (linux) and preform regular, automated backups.

Sorry, I should have been more specific. I have the following:



ini_set('log_errors', TRUE);
ini_set('error_log', ROOT. 'logs/'. date('Y-m'). '.log');
ini_set('error_prepend_string',...

Is there anyway to get the directive error_prepend_string to output to the log file (upon an error) and not the screen?

My job requires the management of a couple of different offices each with a handful of computers. I'm tired of driving to the offices for simple fixes and am looking for ways to do it remotely.
...

It looks like there is a separation whenever there are 2+ spaces. It also appears there is no such thing as an empty column.

I'd start w/ trying something along the lines of:



$fileName =...

Are you specifying the "admin" directory in addition to the filename?



include_once( 'admin/admin_videos.php' );

Look at JavaScript - particularly image maps.

If done correctly, there should be a VERY low probability of a collision - even for a site that receives thousands of hits a month.



This also depends on the custom handler.

Please format your code in the future, eg:


<?php

if( !function_exists('findsysfolder'))
{
function findsysfolder($fld)
{
$fld1=dirname($fld);

that worked - thanks!

Have strings, such as:


$s = "name:example;param1:value;param2:value2;";


Want to get an array of the array[key] = value.

Here's what I'm trying to use:

Is there a PDO equiv?

There are all types of mysql-based geolocation scripts out there. You could easily set up your own server to receive a zip code and output the lat/long.

In my experience TCPDF is the best library to generate PDFs in PHP. But it isn't going to be good enough to convert just any url to pdf - you're going to have to convert all kinds of css/2 into html...

Yes, you would use mod_rewrite. Google for tutorials:

http://www.elated.com/articles/mod-rewrite-tutorial-for-absolute-beginners/
http://www.workingwith.me.uk/articles/scripting/mod_rewrite

Getting a blank page sounds like php is encountering an error that is being suppressed.

Add the following to the start of the script(s) and see if it shows anything:
...

Why are you regenerating the id upon every visit to a restricted page? Not only does it cause problems with AJAX calls but it creates havoc when opening pages in new tabs/windows.

I highly...

This should cut down on any stupid bots you may get submitting things to your page:

I'm assuming the referring page that POSTs is part of the same website. On the "contact us" (or whatever it's...

Error: The image is too wide. It must be <= 400 pixels in width.
Error: The image is too tall. It must be <= 200 pixels in height.

Why not offer a re-size?

I highly suggest using cURL. Something along the lines of:



function fetch_url( $url )
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_USERAGENT, USER_AGENT );
curl_setopt( $ch,...

http://www.vbulletin.com/forum/showthread.php?344035-Create-a-custom-PHP-page-in-vB-CMS

I use .htaccess to add "www." to the front of the domain name if it is not present, via:



# Add a leading www to domain if one is missing.
RewriteCond %{HTTP_HOST} !^www\.
RewriteRule ^(.*)$...

Simple answer: Yes, it can be done.

This is best done using AJAX - which is going to have a learning curve to it.

I recommend finding a javascript library (I recommend jQuery) that has strong...

I'm assuming you have mod_rewrite installed - see: http://articles.sitepoint.com/article/guide-url-rewriting

Something like:



<IfModule mod_rewrite.c>
RewriteEngine on
RewriteRule...