| :: |
|
|
Oleg_Msk
Æèòåëü ôîðóìà
: 30.09.2004
: 1000
|
 : , 9, 2005 11:15am : MySQL-Front - òðàáëû... |
 |
|
ñòîèò MySQL è óñïåøíî ðàáîòàåò. ìîæíî ëîêàëüíî çàéòè ÷åðåç êîìàíäíóþ ñòðîêó, ñëóøàåò ïî ñåòè ïîðò 3306 - âîò è çàõîòåëîñü çàéòè íà íåãî ïî ñåòè ñ Windows-ìàøèíû ñ ïîìîùüþ MySQL-Front..íî âîò íåêîíåêòèòüñÿ....
êòî-íèáóäü ïðîáîâàë ñè¸ - èëè ýòà ïðîãðàììà âïðèíöèïå èãðóøêà è áàëîâñòâî.....íåò, åñòü phpMyAdmin...íî âîò èìåííî ñ âèíäîâñà õî÷ó( î÷åíü æåëàþ) ïîïàñòü â áàçó!!! |
|
| |
|
 |
White Owl
Øòàòíûé çàíóäà
: 10.03.2003
: 2452
: USA, New York City
|
| : , 9, 2005 4:05pm : |
|
|
| MySQL - äàâèòü. |
|
| |
|
|
Oleg_Msk
Æèòåëü ôîðóìà
: 30.09.2004
: 1000
|
| : , 9, 2005 4:07pm : |
|
|
| White Owl (): |
| MySQL - äàâèòü. |
 Îðàêë âîäðóçèòü? |
|
| |
|
|
White Owl
Øòàòíûé çàíóäà
: 10.03.2003
: 2452
: USA, New York City
|
| : , 9, 2005 4:13pm : |
|
|
| Oleg_Msk (): |
| White Owl (): |
| MySQL - äàâèòü. |
Îðàêë âîäðóçèòü? |
Ìîæíî Îðàêë, òåì áîëåå ÷òî îí òåïåðü áåñïëàòåí äëÿ äîìàøíåãî èñïîëüçîâàíèÿ. Ëè÷íî ÿ ïðåäïî÷èòàþ ASA.
À MySQL ýòî î÷åíü äóðíàÿ ñèñòåìà. Ìàëî ÷åì îòëè÷àþùàÿñÿ îò áàç äàííûõ ñ ôàéëîâûì òèïîì õðàíåíèÿ òàáëèö. Åñëè õî÷åòñÿ ñîâñåì áåñïëàòíîãî, âîçüìè óæ ëó÷øå PostgresSQL, âñå ïîâåñåëåå æèòü áóäåò. |
|
| |
|
|
Oleg_Msk
Æèòåëü ôîðóìà
: 30.09.2004
: 1000
|
| : , 5, 2006 7:39am : |
|
|
| White Owl (): |
| Oleg_Msk (): |
| White Owl (): |
| MySQL - äàâèòü. |
Îðàêë âîäðóçèòü? |
Ìîæíî Îðàêë, òåì áîëåå ÷òî îí òåïåðü áåñïëàòåí äëÿ äîìàøíåãî èñïîëüçîâàíèÿ. Ëè÷íî ÿ ïðåäïî÷èòàþ ASA.
À MySQL ýòî î÷åíü äóðíàÿ ñèñòåìà. Ìàëî ÷åì îòëè÷àþùàÿñÿ îò áàç äàííûõ ñ ôàéëîâûì òèïîì õðàíåíèÿ òàáëèö. Åñëè õî÷åòñÿ ñîâñåì áåñïëàòíîãî, âîçüìè óæ ëó÷øå PostgresSQL, âñå ïîâåñåëåå æèòü áóäåò. |
À ìîæíî ïðî ÀÑÀ ïîäðîáíåå ñ òî÷êè çðåíèÿ ïðîôè? |
|
| |
|
|
White Owl
Øòàòíûé çàíóäà
: 10.03.2003
: 2452
: USA, New York City
|
|
| |
|
|
Oleg_Msk
Æèòåëü ôîðóìà
: 30.09.2004
: 1000
|
| : , 6, 2006 6:57am : |
|
|
Î! Ñåíüêñ! |
|
| |
|
|
Andrew
Ãëàâíûé òðåïà÷
: 01.03.2003
: 10421
: Èðêóòñê, RU -> Los Angeles, US
|
| : , 5, 2007 7:25pm : Re: MySQL-Front - òðàáëû... |
|
|
Íà php + MySQL íóæíî ñäåëàòü ñëåäóþùåå: ïðè îáðàùåíèè ê áàçå äàííûõ, åñëè ââåäåííîãî çàïðîñà íå íàéäåíî – ÷òîáû âûâîäèëîñü ñîîáùåíèå, ãîâîðÿùåå î òîì, ÷òî äàííîãî çàïðîñà â áàçå äàííûõ íå íàéäåíî. Åñëè êòî çíàåò, êàê ñäåëàòü – ïîäåëèòåñü, ïîæàëóéñòà.
_________________
Àíäðåé Ãåðàñèìîâ  |
|
| |
|
|
White Owl
Øòàòíûé çàíóäà
: 10.03.2003
: 2452
: USA, New York City
|
| : , 6, 2007 1:56pm : Re: MySQL-Front - òðàáëû... |
|
|
| Andrew (): |
| Íà php + MySQL íóæíî ñäåëàòü ñëåäóþùåå: ïðè îáðàùåíèè ê áàçå äàííûõ, åñëè ââåäåííîãî çàïðîñà íå íàéäåíî – ÷òîáû âûâîäèëîñü ñîîáùåíèå, ãîâîðÿùåå î òîì, ÷òî äàííîãî çàïðîñà â áàçå äàííûõ íå íàéäåíî. Åñëè êòî çíàåò, êàê ñäåëàòü – ïîäåëèòåñü, ïîæàëóéñòà. |
×òî çíà÷èò "çàïðîñà íå íàéäåíî"??? Ìîæåò òû èìåë â âèäó çàïèñåé íå óäîâëåòâîðÿþùèõ óñëîâèþ íå íàéäåíî? Èëè çàïðîñ áûë ñ îøèáêîé è ÁÄ íå ìîæåò åãî âûïîëíèòü?
| : |
// Îòêðûâàåøü ðåçàëòñåò:
$resultset = odbc_do($connectionstring, $queryString);
// Ñíà÷àëà îáðàáàòûâàåøü âîçìîæíîñòü îøèáêè â çàïðîñå:
if($resultset == false) {
echo "<p>ODBC Error=", odbc_error($connectionstring), "<br>", odbc_errormsg($connectionstring);
echo "<p>$queryString";
echo "<p>Please contact IT department about this error";
exit;
}
// ïîòîì çàâîäèøü âñïîìîãàòåëüíóþ ïåðåìåííóþ
$totalRows = 0;
// è ÷èòàåøü ðåçàëòñåò, ôîðìèðóåøü html
while($row = odbc_fetch_array($resultset)) {
$totalRows++;
echo "<tr>", ......
}
// À åñëè ñòðîê íå áûëî, ðóãàåøüñÿ:
if($totalRows == 0) {
echo "<tr><td colspan=$countOfColumns>Sorry, no data</td></tr>";
} |
|
|
| |
|
|
Andrew
Ãëàâíûé òðåïà÷
: 01.03.2003
: 10421
: Èðêóòñê, RU -> Los Angeles, US
|
| : , 6, 2007 2:18pm : Re: MySQL-Front - òðàáëû... |
|
|
| White Owl (): |
| Ìîæåò òû èìåë â âèäó çàïèñåé íå óäîâëåòâîðÿþùèõ óñëîâèþ íå íàéäåíî? |
Èìåííî!
Ñïàñèáî áîëüøîå çà êîä!
_________________
Àíäðåé Ãåðàñèìîâ |
|
| |
|
|
Andrew
Ãëàâíûé òðåïà÷
: 01.03.2003
: 10421
: Èðêóòñê, RU -> Los Angeles, US
|
| : , 16, 2008 8:32pm : |
|
|
Äæîðäæ, ñíîâà íóæíà òâîÿ ïîìîùü
 áàçå äàííûõ åñòü ñëåäóþùàÿ èíôîðìàöèÿ:
750
831
920
970
982
Åñëè ñäåëàòü çàïðîñ íà âûâîä îäíîãî çíà÷åíèÿ (íàïðèìåð, 831) - êàê ïðè ýòîì óçíàòü, ÷òî â îáùåì ñïèñêå ýòî èìåííî âòîðîé ïî ïîðÿäêó íîìåð?
_________________
Àíäðåé Ãåðàñèìîâ |
|
| |
|
|
White Owl
Øòàòíûé çàíóäà
: 10.03.2003
: 2452
: USA, New York City
|
| : , 16, 2008 10:07pm : |
|
|
| Andrew (): |
Äæîðäæ, ñíîâà íóæíà òâîÿ ïîìîùü
 áàçå äàííûõ åñòü ñëåäóþùàÿ èíôîðìàöèÿ:
750
831
920
970
982
Åñëè ñäåëàòü çàïðîñ íà âûâîä îäíîãî çíà÷åíèÿ (íàïðèìåð, 831) - êàê ïðè ýòîì óçíàòü, ÷òî â îáùåì ñïèñêå ýòî èìåííî âòîðîé ïî ïîðÿäêó íîìåð? |
Ñïèñîê ñîðòèðîâàí ïî âîçðàñòàíèþ?
Íó ìîæíî âîñïîëüçîâàòüñÿ êàêîé-íèáóäü ôóíêöèåé òèïà number(*) åñëè îíà ñóùåñòâóåò â òâîåé áàçå äàííûõ. À ìîæíî ñäåëàòü ÷òî-òî òèïà:
| : |
| select t1.some_number, (select count(*) from sometable t2 where t2.some_number < t1.some_number) from sometable t1 order by some_number |
|
|
| |
|
|
Andrew
Ãëàâíûé òðåïà÷
: 01.03.2003
: 10421
: Èðêóòñê, RU -> Los Angeles, US
|
| : , 17, 2008 4:13pm : |
|
|
| White Owl (): |
| Ñïèñîê ñîðòèðîâàí ïî âîçðàñòàíèþ? |
Äà.
| White Owl (): |
| Íó ìîæíî âîñïîëüçîâàòüñÿ êàêîé-íèáóäü ôóíêöèåé òèïà number(*) åñëè îíà ñóùåñòâóåò â òâîåé áàçå äàííûõ. |
Áàçà äàííûõ íà MySQL. ß ïîñìîòðåë è íå íàøåë.
| White Owl (): |
À ìîæíî ñäåëàòü ÷òî-òî òèïà:
| : |
| select t1.some_number, (select count(*) from sometable t2 where t2.some_number < t1.some_number) from sometable t1 order by some_number |
|
Ñäåëàë, ýòî âûâîäèò âåñü ñïèñîê íîìåðîâ:
1
2
3
4
5
À íàäî, ÷òîáû ïî çàïðîñó ê "831" âûâîäèëñÿ íîìåð "3". ×òî äåëàþ íå òàê?
_________________
Àíäðåé Ãåðàñèìîâ |
|
| |
|
|
White Owl
Øòàòíûé çàíóäà
: 10.03.2003
: 2452
: USA, New York City
|
| : , 17, 2008 4:19pm : |
|
|
| Andrew (): |
| À íàäî, ÷òîáû ïî çàïðîñó ê "831" âûâîäèëñÿ íîìåð "3". ×òî äåëàþ íå òàê? |
Âîïðîñ çàäàåøü íå òàê. ×òî òû ñïðàøèâàë, íà òî ÿ è îòâåòèë.
À åñëè íàäî âñåãî-ëèøü óçíàòü ÷òî 831 ýòî òðåòèé (èëè âñå-æå âòîðîé?) ýëåìåíò â ñïèñêå, òî âñå íàìíîãî ïðîùå:
| : |
| select count(*) from some_table where some_field<=831 |
|
|
| |
|
|
Andrew
Ãëàâíûé òðåïà÷
: 01.03.2003
: 10421
: Èðêóòñê, RU -> Los Angeles, US
|
| : , 17, 2008 4:47pm : |
|
|
| White Owl (): |
| À åñëè íàäî âñåãî-ëèøü óçíàòü ÷òî 831 ýòî òðåòèé (èëè âñå-æå âòîðîé?) |
Òî÷íî, âòîðîé.
| White Owl (): |
âñå íàìíîãî ïðîùå:
| : |
| select count(*) from some_table where some_field<=831 |
|
×åðò, êàê âñå ïðîñòî... Äàæå ñòûäíî, ÷òî ñàì íå äîäóìàëñÿ 
Äæîðäæ, òû ãåíèé! 
Ñïàñèáî çà ïîìîùü!
_________________
Àíäðåé Ãåðàñèìîâ |
|
| |
|
|
|
FAQ
