:: |
|
|
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 |
|
×åðò, êàê âñå ïðîñòî... Äàæå ñòûäíî, ÷òî ñàì íå äîäóìàëñÿ
Äæîðäæ, òû ãåíèé!
Ñïàñèáî çà ïîìîùü! _________________ Àíäðåé Ãåðàñèìîâ |
|
|
|
|
|