Date: 04/16/05 (PHP Community)    Keywords: php, mysql, sql, web, linux, hosting, apache

I am currently hosting my web site with powweb, the problem is that I am outgrowing its feature set. I’m working on some applications that need the MySQL InnoDB table type, or at least would find it very useful. Does anyone know of a hosting provider that supports the following:

PHP 5.0x
MySQL 4.1.x With InnoDB
Apache (1.3 or 2.0 would be fine)

Ideally running linux or BSD

Source: http://www.livejournal.com/community/php/286793.html

Date: 04/18/05 (Web Hosts)    Keywords: php, mysql, database, sql, hosting

www.subnixus.com now has three easy ways to earn free hosting.

1. Being an active member of the forum. It's that simple, by posting on our forum you can earn free hosting. Read about it here: http://www.subnixus.com/forums/viewtopic.php?id=798

2. By signing up for one of our sponsers, such as DISH Network, you can earn one year of free hosting. Read about it here: http://www.subnixus.com/forums/viewtopic.php?id=799

3. By making a donation of $10 or more you will earn one year of free hosting. Read about that promotion here: http://www.subnixus.com/forums/viewtopic.php?id=802

Your hosting package will be reviewed and given on a case by case basis. The minimum package includes (but you could qualify for more):

www.yourname.com
125MB of Space
1G of bandwidth
1 MySQL Database
POP Email
Control Panel
FTP
(basically anything you need to get your site up and running)


This new program starts this week. All accounts that are earned between April 18 - 22 will be setup on Sat. the 23rd. Please visit www.subnixus.com for all of the details.

Source: http://www.livejournal.com/community/webhosts/26063.html

Date: 04/19/05 (PHP Community)    Keywords: php, mysql, database, sql

Greetings... Semi-novie with PHP here. Toyed with it years ago, and just started working on a project that is based in PHP. I'm getting some information from a MySQL database, and I've used str_replace to modify most of what I need, but I'm pulling a domain name from a sentence, so what string_replace leaves me with is 'domain.name.com.'

I'm trying to get rid of the trailing period, and I've tried using:

$text="domain.name.com.";

$newtext=rtrim($text, '.');

The . does not go away. I've tried with double quotes as well.

Any help would be most graciously appreciated!




EDIT: Got it... thanks for all your help!

Source: http://www.livejournal.com/community/php/288213.html

Date: 04/20/05 (PHP Community)    Keywords: php, mysql, browser, html, database, sql

Hi all,
I have a program that gets its images from a mysql database. I pass a string to the program that gets the picture inside an HTML image tag like this:

<*img src=\"show_image.php/thumbnails/$boxData[thum_id]/img.jpg\">

This is what the string looks like when it has been passed:

show_image.php/thumbnails/7678/img.jpg

This is the program show_image.php

$pic_id = get_pic_id($_SERVER['REQUEST_URI']);

$table_name = get_table_name($_SERVER['REQUEST_URI']);

$file_data = get_file_data($pic_id, $table_name);

header("Content-type: " . $file_data['type']);

echo $file_data['binary_data'];

Source: http://www.livejournal.com/community/php/288307.html

Date: 04/21/05 (MySQL Communtiy)    Keywords: mysql, sql

Ok, got an odd question. Is it possible, given a list of words to be matched against a FullText index...when you get the results...how can you know what word (or words) the result was actually matched against? I'm using a few tricks from the online MySQL manual to get a relevance score, but what I really want to know is which word(s) gave the strongest "reason" for returning any given result.

Source: http://www.livejournal.com/community/mysql/54662.html

Date: 04/22/05 (Computer Geeks)    Keywords: php, mysql, sql, web

you guys know of a program that can emulate a webserver where I can test PHP scripts and also has mysql? Thanks.

Source: http://www.livejournal.com/community/computergeeks/666412.html

Date: 04/23/05 (Web Hosts)    Keywords: php, mysql, sql, web, hosting

I manage two domains, each under 10MB. For the past two years, they've been hosted with dr2.net, but then service got spotty and then they merged with Mesopia and the reviews got worse.

So, I'm looking to switch both domains to a new shared host. After checking out webhostingjury.com, I like the features of the standard plan of u-hs.com but the price seems a tad too steep. Looking for something in the area of $10 to $25 a year. One of the domains I expect to migrate to PHP and MySQL in the next few months.

Suggestions?

Source: http://www.livejournal.com/community/webhosts/26292.html

Date: 04/25/05 (WebDesign)    Keywords: php, mysql, asp, sql, web, hosting

I just recently register my domain name, and now I'm asking for those that have domains with storage access what hosting company are you using ? I prefer for the hosting company to be in the USA, and if it's not at lease have payment options in USA dollars.

I would like for the hosting company to have the following for service
FTP Access
PHP
ASP
CGI-BIN
MYSQL
WEB MAIL
ALLOWS MULTIMEDIA (really important I've been searching around hosting sites,but the ones I'm finding doesn't allow it)
SUB DOMAIN

and a good amount of space and bandwidth

Source: http://www.livejournal.com/community/webdesign/863860.html

Date: 04/26/05 (WebDesign)    Keywords: php, mysql, html, sql, web

I'm looking for a good PHP search engine with full text indexing, the ability to crawl pages itself, preferably MySQL storage, and advanced search options. It'd also be nice if it rendered output in streamlined xhtml, or uses Smarty but not required.

Any suggestions?

Posted in:
php php_dev webdesign webdev
I apologize in advance to all the people that are members of one or more of these communities

Source: http://www.livejournal.com/community/webdesign/864449.html

Date: 04/26/05 (Web Development)    Keywords: php, mysql, html, sql, web

I'm looking for a good PHP search engine with full text indexing, the ability to crawl pages itself, preferably MySQL storage, and advanced search options. It'd also be nice if it rendered output in streamlined xhtml, or uses Smarty but not required.

Any suggestions?

Posted in:
php php_dev webdesign webdev
I apologize in advance to all the people that are members of one or more of these communities

Source: http://www.livejournal.com/community/webdev/192585.html

Date: 04/26/05 (PHP Community)    Keywords: php, mysql, html, sql, web

I'm looking for a good PHP search engine with full text indexing, the ability to crawl pages itself, preferably MySQL storage, and advanced search options. It'd also be nice if it rendered output in streamlined xhtml, or uses Smarty but not required.

Any suggestions?

Posted in:
php php_dev webdesign webdev

Source: http://www.livejournal.com/community/php/291689.html

Date: 04/26/05 (PHP Community)    Keywords: php, mysql, html, database, sql, web

I'm trying to do some really wacky stuff with a form.

Essentially, I'm reading in multiple columns from a table in a MySQL database (looping, obviously), and creating a form as I present the data. The challenge this presents is that for each loop, the form values have to have a unique identifier, so I'm trying to use variables. It's not working so well, but I'm using standard HTML to try to process the form. I've gleaned bits and pieces searching the web that PHP has its own method to handle form input.

So, I need a good book that has a lot of detail on how to work with forms. A good web resource would work too.

Thanks in advance!



This is a quick mockup of the code and how I'm presenting the form...

$count=0; while(list($name, $id, $message)= $result->fields) { echo "<input name=\"name$count\" value=\"Y\" type=\"checkbox\">$name<br>"; echo "<input name=\"id$count\" value=\"Y\" type=\"checkbox\">$id"<br>; echo "<input name="\msg$count\" value=\"$message\" type=\"hidden\">$message<br>"; $count++; $result->MoveNext(); }

So, in theory here, each loop should give a unique value to each form element. I just need to know how to process it. I'm writing selected data back into a seperate table, so I need to loop through the results and write them out.

Again, help is appreciated!

Source: http://www.livejournal.com/community/php/291348.html

Date: 04/26/05 (PHP Development)    Keywords: php, mysql, html, sql, web

I'm looking for a good PHP search engine with full text indexing, the ability to crawl pages itself, preferably MySQL storage, and advanced search options. It'd also be nice if it rendered output in streamlined xhtml, or uses Smarty but not required.

Any suggestions?

Posted in:
php php_dev webdesign webdev
I apologize in advance to all the people that are members of one or more of these communities

Source: http://www.livejournal.com/community/php_dev/55407.html

Date: 04/28/05 (PHP Community)    Keywords: mysql, rss, html, xml, database, sql

Alright, I'm having a bit of a problem.

I've set up a page to read and parse RSS feeds. It works for the most part. The feed names and addresses are pulled from a mysql database okay. The problem lies in putting them onscreen. At some point, variables are not being dropped or overwritten, and I'm getting the same results repeated, but with the count number of the second feed.

See what I mean?

This is the code:


-- Begin Code --



include (" [ sql stuff ]");

$sql = "SELECT * FROM rss_feeds";

$results = mysql_query($sql);

while ($myrow = mysql_fetch_array($results))
{


$feedtitle = $myrow['name'];
$feedurl = $myrow['url'];
$xfeed = $myrow["feed"];
$maxcount = $myrow['num_items'];


$xmlfile = fopen("$xfeed", "r");
if(!$xmlfile)die("This doesn't work");
$readfile = fread($xmlfile ,100000);
$searchfile = eregi("< item>(.*)< /item>", $readfile ,$arrayreg);
$filechunks = explode("< item>", $arrayreg[0]);
$count = count($filechunks);

if ($maxcount > $count)
{
$maxcount = $count;
}


echo "< a href=\"$feedurl\">$feedtitle< /a>< br>";


for($i=1 ; $i<=$maxcount ; $i++)
{


eregi("< title>(.*)< /title>",$filechunks[$i], $title);
eregi("< link>(.*)< /link>",$filechunks[$i], $link);
eregi("< pubDate>(.*)< /pubDate>",$filechunks[$i], $pubdate);
eregi("< description>(.*)< /description>",$filechunks[$i], $description);

$pubdate = "$pubdate[1]";
$xlink = "$link[1]";
$xtitle = "$title[1]";
$xdescription = "$description[1]";

$xdescription = html_entity_decode($xdescription);
$xdescription = strip_tags($xdescription);


$xday = substr($pubdate, 5, 2);
$xmonth = substr($pubdate, 8, 3);
$xyear = substr($pubdate, 12, 4);

$monthnames = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec");
$monthnumbers = array("01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12");

$ymonth = str_replace($monthnames, $monthnumbers, $xmonth);

$articledate = date("F jS, Y", mktime(0, 0, 0, $ymonth, $xday, $xyear));

echo "< span style=\"text-transform: capitalize;\">< a href =\"$xlink\" target=\"_blank\">$xtitle< /a>< /span>< br>";
echo "$articledate< br>";
echo "$xdescription< br>";

}

}


-- End Code --



Anyone have any idea what could be causing this?

NOTE: It looks now to be a problem with the one RSS feed itself, and not the code

Source: http://www.livejournal.com/community/php/292485.html

Date: 04/28/05 (PHP Community)    Keywords: php, mysql, database, sql, web, linux, hosting

I have a hosting company that runs Linux with PHP and MySQL through Plesk (a kind of server control panel) I can’t get into the control panel at work because I’m behind a firewall that blocks port 8443. I can, however use “my network places” in windows 200 to create an FTP connection to my server. The down side is: with FTP I can’t interface with the MySQL database… but, at least, I can upload and download files…Right?

Wrong.

This is the weirdest thing I’ve ever seen. The files I upload using FTP on my home computer or Plesk at home can be accessed from the web by typing the URL, but they do not appear in windows FTP flooder for the site. Yes, I have refreshed and restarted and connected and disconnected. They just don’t show up.

I can copy a file in to the FTP folder in windows… and it returns no error and appears to have uploaded correctly. But, if I type in the URL for the file the server says “file not found” I believe the upload is not working because when I go home and look in FTP on the other side of the firewall the file is not there! But, it appears to be there in windows. It was even there the next day. What on earth is going on!

Moreover, if I use a web-based FTP like http://01ftp.com/index.php it will show be a different set of files depending on what side of the firewall I’m on.

I can’t turn the firewall off but I’d like to, at least, understand why this is happening.

Why didn’t windows return an error when the file failed to upload? What if that file had been important? How can it show the file in the FTP folder for my site when it’s not really there? I think that’s a pretty scary and unreliable thing for an OS to do!

I think this might have something to do with actve and passive FTP... I'm reading up on it now... but honestly I don't have a clue.

The firewall is Mcaffe desktop firewall, and it's centrally controlled so no way to shut it off without being some kind of evil little haXX0r.

Source: http://www.livejournal.com/community/php/293012.html

Date: 04/30/05 (PHP Community)    Keywords: php, mysql, database, sql

I'm working on redesigning the layout of a site I created not long ago.  I'm using the same database and all the same funcions and whatnot, I'm just changing the layout.

Seems easy enough, right?  No.  The code that works fine and dandy on the old version of the site is causing errors on the new version.  All I did is copy the php files containing the code to connect to the database and the functions that I use to populate the main page (look at the old version, you'll see what I mean).

So how come on the new site, the code that worked fine before, gives me the following errors?


Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in [php file] on [line number]

Warning: mysql_query(): A link to the server could not be established in [php file] on [line number]
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

The two versions of the site are on the same server, in different folders.  Also, other parts of the new site that connect to the same database work fine.  It seems (so far) that the error is only when I call the function to populate the main page.

Any ideas?

Source: http://www.livejournal.com/community/php/293204.html

Date: 05/01/05 (PHP Community)    Keywords: mysql, sql

Code:

$TableNameADDR = "clients";

$Link = mysql_connect ($Host, $User, $Password);
$QueryADDR = "SELECT ClientFirst, ClientLast, PayorBillingAddress, PayorBillingAddress2, PayorBillingCity, PayorBillingState, PayorBillingZipCode, PayorBillingZipCodePlus4, InsCompany, InsAcctNum, service_notes, billing_notes, ClientRate, CGRate, dayrate from $TableNameADDR WHERE ClientID='$ClientID'";
$Result = mysql_db_query ($DBName, $QueryADDR, $Link);

if (!Result) {
print ("The Query could not be executed
\n");
echo 'Could not run query: ' . mysql_error() . "
$QueryADDR";
}

while ($ROW = mysql_fetch_array ($Result)) {

$CLIENTaddress2 = array_values($ROW);

$ClientRate = $ROW[ClientRate];
$CGRate = $ROW[CGRate];
$dayrate = $ROW[dayrate];

}//end while

mysql_close ($Link);

Why is the result for CLIENTaddress doubled? (every value is in the array twice). I verified its only going through the while loop once.

Array
(
    [0] => TEST DATA
    [1] => TEST DATA
    [2] => A_Curtis
    [3] => A_Curtis
    [4] => Market St
    [5] => Market St
    [6] => #321
    [7] => #321
    [8] => San Jose
    [9] => San Jose
    [10] => CA
    [11] => CA
    [12] => 95124
    [13] => 95124
    [14] => 3333
    [15] => 3333
    [16] => BandAid
    [17] => BandAid
    [18] => 1245
    [19] => 1245
    [20] => Testdata2
    [21] => Testdata2
    [22] => Testdata2
    [23] => Testdata2
    [24] => 40.00
    [25] => 40.00
    [26] => 20.00
    [27] => 20.00
    [28] => 
    [29] => 
)

Source: http://www.livejournal.com/community/php/293566.html

Date: 05/02/05 (MySQL Communtiy)    Keywords: mysql, sql

So I have a strange problem. I have a table with a column that is day of the week as an integer. (0-6) Is there any good way to map those back onto actual day names (Sunday, Monday etc) in Mysql. Also is there a way to do this with season names?

Source: http://www.livejournal.com/community/mysql/55260.html

Date: 05/03/05 (MySQL Communtiy)    Keywords: mysql, sql

Hi everyone,

I performed the following query to implement triggers. But error code 1064 occured.



create table distance(
edge_id varchar(20) NOT NULL,
source_node varchar(20),
dest_node varchar(20),
distance float(9,2),
parent_edge_id varchar(20),
road_condition int,
congestion1 int,
congestion2 int,
congestion3 int,
primary key(edge_id)
);


create table weight(
edge_id varchar(20) NOT NULL REFERENCES distance(edge_id),
weight1 float(9,2),
weight2 float(9,2),
weight3 float(9,2),
primary key(edge_id)
);


My Aim is to automatically insert rows into the weight table, upon insertion of any row in distance table.

So, I wrote the followin syntax:

create TRIGGER calculate
AFTER INSERT ON distance
INSERT INTO weight values(NEW.edge_id,NEW.congestion1,NEW.congestion2,NEW.congestion3);


Is the syntax correct for creating triggers? If it's not so, then please someone tell how to create triggers in MySQL...

Source: http://www.livejournal.com/community/mysql/55572.html

Date: 05/09/05 (Web Development)    Keywords: php, programming, mysql, sql

I need a script/app/whatever to just store credit card info, so they can be processed manually at a terminal later. What can I do about this? Any recommendations?

(I'm not a programmer myself and only have very basic knowledge of php/mysql so I'm hoping this won't need custom programming shit.)

Thanks a ton

Source: http://www.livejournal.com/community/webdev/196766.html