Search results

My first piece of advice is to use LINQ rather than writing out SQL queries. Heck, even ADO would be better. If you insist on writing the SQL statements yourself, at least use a prepared statement and parameterize the value for controller_name. For one thing, if there's a problem with the value...

Read (and follow) the following so you can write a question we'll be able to answer: "How to Ask Questions the smart way" "Writing the Perfect Question" "Short, Self-contained, Correct Example"

PHP doesn't have block scope (you enter a new local scope only on function invocation), so scope isn't an issue. MySQL authentication is based on three pieces of information which need to match what's on the server, so an "access denied" error has four potential causes: Wrong username. Wrong...

@wfarr_0817: search first, don't threadjack, don't revive long dead threads.

To extend the security of the script, you can generate a new key each time the cron job is run. Try: key=$RANDOM; echo $key > $HOME/.cron_key; wget -O - http://YOURSITE/cron.php?cron_key=$key >>$HOME/logs/cron_log.txt 2>&1 The PHP script would compare $_GET['cron_key'] to the contents of...

A thought occurs to me: try a different PHP executable. I see you're using the one at "/usr/bin/php". Try "/usr/local/bin/php" and post the results.

See the newly created cron job page in the X10 wiki for more. Feel free to contribute.

Spamming breaks the Acceptable Use Policy, which you agreed to when you signed up. Spamming falls under the zero tolerance policy, which means your access is cut off, no exceptions. You can appeal the suspension, though you must prove you weren't guilty. I'll escalate this so you can try to...

Since X10 isn't Alertpay, this isn't the place to ask. You should be checking the Alertpay documentation for information on how to use their service. After all, if you were renting a storefront, you wouldn't call the landlord for help with the cash register. You shouldn't store customer's...

Search the forums for more on the topic; it's been covered many times before. The old mysql extension is outdated. Use PDO, which is easier, more featureful and supports prepared statements. If you need a tutorial, try "Writing MySQL Scripts with PHP and PDO".

Did you read the tutorial I recommended before? There's not much to using PDO. You don't even have to understand OOP, you just have to use OOP syntax: new to create a PDO object rather than mysql_connect, -> to call methods. At lower and the highest levels (interpreter implementation and...

Columns in RDB tables should be simple, meaning a single value. This is the 1st normal form property. You should have a separate entry for each item in a cart. A practical reason for this is that joining using LIKE with a leading wildcard is incredibly inefficient. MySQL will need to scan the...

@horizonsit56: what does that have to do with Melissa's problem?

Note the line: RewriteRule ^generate_link /modules/generate_link.php [NC] The URL "http://[server name]/generate_link" (server name not specified, since you didn't give it) is serviced by the file ~[username]/public_html/modules/generate_link.php. A Not Found response prompts you to check that...

cPanel should show the PHP and MySQL versions in the "Stats" panel on the left. phpMyAdmin will show the MySQL version on its home page (the first page that loads), as well as web server information (though the web server that runs cPanel and phpMyAdmin is different from the one/s that serves/...

There's nothing special you have to do. However, unless you have a good reason to use both (and I've yet to hear one), it's best to stick to a single RDBMS so you can query any tables from all the databases simultaneously if need be, and to simplify administration.

W3Schools is outdated, inaccurate and incomplete, and that's not just my opinion. For better recommendations, see the threads "What should I learn?", "Want to learn to program...."

The time to start using PDO is now, before you start writing more code. You can go back and update existing code later. Note this is a URL, not an absolute path. It will. It's URLs that won't work. Most URLs are read-only, and the ones that aren't require authentication first, so any function...

No, because we have absolutely no clue what you're talking about. Read (in full) "How To Ask Questions The Smart Way" and "Writing the Perfect Question", because you've gone counter to the majority of the guidelines (meaningless, generic title; no sample code; no description of what you're...

Search first.