Archive for Mysql help
Breakpoints in VWD 2005?
Posted by: | CommentsOur FIRST robotics team is making a database for scouting, and our php is not working, we don’t know what’s wrong, because the “or die(mysql_error());” is not working. If we switch to a windows server and use ASP.NET / Microsoft SQL Server, will we be able to use breakpoints like the ones in visual basic to see what is going on during the running of the program? We only have Visual Studio Pro 2005, so 2008 tips won’t help.
Thanks,
Joe
I used to test many open source php /my sql scripts. But this local host started showing some problem in terms of connectivity to mysql server.
Problem:when I access to phpmyadmin; it is showing the error: Access denied. “phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.”
MySQL said: Cannot connect: invalid settings.
I would be grateful if any one can help me by giving simple understandable tips.
WordPress Plugin Help!?
Posted by: | CommentsI’ve been trying to solve this for three days now but no success and it’s getting stressing. It’s for WordPress plugin. I hope you guy out there can help me out and explain to me what is wrong with the code.
The code is to look for
[DATA:<- ID OF THE DATA IN MYSQL ->] on the content page and replace it with the ID’s title which was extracted from MYSQL.
eg: [DATA:2] = < b >This is info for ID 2 < /b >
Everything work perfectly until i added the codes with the Asterik ‘*’… and all I get is blank. No result, nothing… not even the [Data:2] tag.
Please help.
===============
function scannow ($content) {
$CODE = ‘/\[DATA\:(.*?)\]/is’;
$VALUE = ‘$1′;
* $result = mysql_query(“SELECT * FROM wp_datastructure WHERE option_id = ‘$VALUE’”);
* $row = mysql_fetch_array($result);
* $VALUE = $row['option_name'];
$content = preg_replace($CODE, $VALUE, $content);
return $content;
}
===============
note: I’ve tried using the tips in WordPress Codex but all give me nothing but errors. pls help!
Creating a website?
Posted by: | CommentsGuys, can you give me some tips on creating my own web site.
A few years ago, I spent time time leaning html 4.0, and was pretty good at doing some things but got frustrated trying to understand frames, and then I just couldn’t understand extra things like cascasding style sheets, and forget javascript!
I had dreamwever MX (still do) but was determined to learn from scratch.
Now, I want to actually deveop my own web site. Ideally it is going to have user log ins, could possibly be an Estore, with aotomatic paying right on line..or give the users the ability to make posts for things they have to offer..etc
Now, Are html, xhtml dreamweaver etc still considered the basic starting tools, or is all this stuff obsolete? I think I might need to have some sort of database…is mysql the right product?? Is PHP or SQL still used? Which one is easier to
use/learn as a programming language..PHP or SQL?
I’m not going to be able to host the site myself.
In what order should I install the following: mysql, php, apache, phpmyadmin?
Posted by: | CommentsThis is for local development on a windows xp (sp2) machine?
Can I use iis instead of apache? Which is recommended?
I ran into issues the first time I tried installing everything so I uninstalled everything and would like to try again.
Any tips/suggestions? For example, phpmyadmin and mysql user and password matching?
Looking for this to be as smooth as possible, the last time was not, thus my frustration.
Thx in advance for your time and effort!
