[C] MySQL @ Slo-Tech

Forum » Programiranje »
[C] MySQL

[C] MySQL

SodVina :: 11. nov 2003, 10:03

A kdo ve, kako se priklopiti na mysql bazo v c-ju (linux). poskusil sem ze mysql++ in mysql C api, pa dobim error: undefined refference za vse funkcije, ki jih klicem iz mysql.h

potreboval bi enostaven priklop na bazo s standardnimi c funkcijami, saj potrebujem le priklop in izvrsitev enega query-ja

ce kdo ve odgovor, mu bom zanj hvalezen,
cav

spremenilo: snow (5. okt 2006 ob 16:34)

Vesoljc :: 11. nov 2003, 10:20

headerji ponavadi rabijo ali source (v *.cpp) ali pa že skompajlano kljižnico *.lib ali *.dll. si jih povezal zraven?

Abnormal behavior of abnormal brain makes me normal...

SodVina :: 11. nov 2003, 10:59

dobil sem rpm, s headerji in knjiznjicami.
pa vseeno...
knjiznice pa majo koncnico a

vse naj bi bilo na pravih imenikih, poskusil sem tudi dodati knjiznice na isti imenik, kot so headerji, pa tudi ni pomagalo

BigWhale :: 11. nov 2003, 15:25

Banzai!

Tako fscking tezko je malo ampak res samo MALO prebrati dokumentacijo...

Link!

PS:
slabe volje sem...

edit moderator: Sedaj sem tudi jaz.

Zgodovina sprememb…

spremenilo: CCfly (8. okt 2006 ob 20:02)

SodVina :: 12. nov 2003, 09:18

Res je!!
pozabil (sem (ne vem kako) parameter -lm.
zdaj zadeva dela!!
hvala, ker si me spomnil, kaksen bedak sem!!
upam da ti bom lahko kdaj vrnil
lp

BigWhale :: 12. nov 2003, 09:34

-lm nima nobene veze s MySQLom...

fx :: 16. feb 2006, 10:28

A je možno s C++ v Win pisati podatke v MySQL. Bazo imam narejeno sedaj bi samo rad samo vnašal podatke v mysql bazo. Vem da bi lahko uporabil php samo php koliko jaz vem ne omogoča brati iz com porta ali pa iz omrežne kartice, če se motim glede php mi povejte.

Lp,

CWIZO :: 16. feb 2006, 14:04

Da se.
Oboje.

hancic.info
I can't uninstall it, there seems to be some kind of "Uninstall Shield"...

fx :: 12. jul 2006, 21:14

Odločil sem se da bom uporabil naslednjo možnost:
Com port (v prihodnisti bo LAN povezava) -> MySQL in obratno samo vse skupaj bo vodil program v C++ kot vez med prvim in drugim. A to se tudi da? Prvi del programa imam da mi program prebere iz comporta a za vpis v MySql bazo pa se mi niti ne sanja kako bi to rešo in kako bi se k temu spravo (uporabo google pa ne vem kaj je prav). Delam pa za windowse.

Hvala za vsako pomoč.

Lp,

sverde21 :: 13. jul 2006, 07:28

Kaj imaš pa na COM port priključen? Računalnik. Če ga imaš, lahko v win (z Linux nism še probval) narediš "mrežo", in se potem povezuješ na port 3306 (default MySQL port) ali pa dostopaš na server z PHP, ki je povezan preko localhosta na MySQL.

Stvar sm preizkusil tudi sam sicer preko LPT kabla (na obeh compih Win XP) ampak presenetljivo deluje

<?php echo `w`; ?>

fx :: 13. jul 2006, 09:17

Ne, naredil bom svojo elektroniko. Samo povezav je povezava in je vseeno kaj ti gor priključiš (vsaj jaz tako mislim) in če lahko uporabim za to php je toliko boljše. Bom prvo probla tvoje in če bo to kakor jaz želim potem OK. Hvala za nasvet.

Lp,

sid_dabster :: 13. jul 2006, 09:33

Za COM port (cisto kratek povzetek - sinhrono branje in pisanje):

HANDLE com_port = CreateFile(  "COM1",  GENERIC_READ | GENERIC_WRITE, 0, NULL, OPEN_EXISTING, 0, NULL);
DCB params;
params.BaudRate = ...;
params.ByteSize = ...;
params.Parity   = ...;
params.StopBits = ...;
params.fParity = ...;
SetCommState(com_port, &params);

#define BUF_SIZE ...pac neki

//...

//Pol pa za branje:
char buf[BUF_SIZE];
DWORD bytes_read;
ReadFile(com_port, buf, BUF_SIZE, &bytes_read, NULL);

//...

//...Pa za pisanje:
char buf[BUF_SIZE];
DWORD bytes_written;
WriteFile(com_port, buf, BUF_SIZE, &bytes_written, NULL);

//...

//...pa na koncu se zapri port
CloseHandle(com_port);

Za mysql c-api knjiznico si pa poglej link, ki ga je poslal bigwhale. Vse ostalo je samo se kuckanje. Mislim, da ti ne bo problem zloziti skupaj taksnega programcka.

Pa kr v c-ju nared, sploh ce bos s com portom delal.

Fallen beyond all grace deeper and deeper
The sound of her own blood dripping
Like sacred tears from a bleeding rose...( Embraced, Within)

BigWhale :: 13. jul 2006, 10:14

Uporabi Qt za Mysql, bo precej lazje.

fx :: 16. sep 2006, 16:47

MySQLpp.cpp:1:26: error: mysql++/util.h: No such file or directory
In file included from /usr/local/include/mysql++/connection.h:40,
                 from /usr/local/include/mysql++/mysql++.h:52,
                 from MySQLpp.cpp:2:
/usr/local/include/mysql++/defs.h:34:19: error: mysql.h: No such file or directory
/usr/local/include/mysql++/defs.h:66: error: &#8216;MYSQL_FIELD&#8217; does not name a type
/usr/local/include/mysql++/connection.h:146: error: &#8216;my_bool&#8217; has not been declared
/usr/local/include/mysql++/connection.h:163: error: &#8216;my_bool&#8217; has not been declared
/usr/local/include/mysql++/connection.h:360: error: &#8216;st_mysql_options&#8217; does not name a type
/usr/local/include/mysql++/connection.h:427: error: &#8216;my_ulonglong&#8217; does not name a type
/usr/local/include/mysql++/connection.h:438: error: &#8216;my_ulonglong&#8217; does not name a type
/usr/local/include/mysql++/connection.h:488: error: &#8216;mysql_option&#8217; has not been declared
/usr/local/include/mysql++/connection.h:545: error: &#8216;MYSQL&#8217; does not name a type
/usr/local/include/mysql++/connection.h: In member function &#8216;void mysqlpp::Connection::close()&#8217;:
/usr/local/include/mysql++/connection.h:171: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:171: error: &#8216;mysql_close&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;const char* mysqlpp::Connection::error()&#8217;:
/usr/local/include/mysql++/connection.h:228: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:228: error: &#8216;mysql_error&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;int mysqlpp::Connection::errnum()&#8217;:
/usr/local/include/mysql++/connection.h:235: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:235: error: &#8216;mysql_errno&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;int mysqlpp::Connection::refresh(unsigned int)&#8217;:
/usr/local/include/mysql++/connection.h:247: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:247: error: &#8216;mysql_refresh&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;int mysqlpp::Connection::kill(long unsigned int)&#8217;:
/usr/local/include/mysql++/connection.h:270: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:270: error: &#8216;mysql_kill&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;std::string mysqlpp::Connection::client_info()&#8217;:
/usr/local/include/mysql++/connection.h:278: error: &#8216;mysql_get_client_info&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;std::string mysqlpp::Connection::host_info()&#8217;:
/usr/local/include/mysql++/connection.h:289: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:289: error: &#8216;mysql_get_host_info&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;int mysqlpp::Connection::proto_info()&#8217;:
/usr/local/include/mysql++/connection.h:298: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:298: error: &#8216;mysql_get_proto_info&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;std::string mysqlpp::Connection::server_info()&#8217;:
/usr/local/include/mysql++/connection.h:306: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:306: error: &#8216;mysql_get_server_info&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h: In member function &#8216;std::string mysqlpp::Connection::stat()&#8217;:
/usr/local/include/mysql++/connection.h:317: error: &#8216;mysql_&#8217; was not declared in this scope
/usr/local/include/mysql++/connection.h:317: error: &#8216;mysql_stat&#8217; was not declared in this scope
/usr/local/include/mysql++/fields.h: At global scope:
/usr/local/include/mysql++/fields.h:41: error: &#8216;Field&#8217; was not declared in this scope
/usr/local/include/mysql++/fields.h:41: error: template argument 2 is invalid
/usr/local/include/mysql++/fields.h:41: error: template argument 3 is invalid
/usr/local/include/mysql++/fields.h:54: error: expected &#8216;;&#8217; before &#8216;&&#8217; token
/usr/local/include/mysql++/fields.h:57: error: expected &#8216;;&#8217; before &#8216;&&#8217; token
/usr/local/include/mysql++/fields.h:62: error: expected `;' before &#8216;size_type&#8217;
/usr/local/include/mysql++/fields.h:62: error: &#8216;size_type&#8217; does not name a type
/usr/local/include/mysql++/type_info.h:142: error: expected `)' before &#8216;t&#8217;
/usr/local/include/mysql++/type_info.h:148: error: expected &#8216;,&#8217; or &#8216;...&#8217; before &#8216;&&#8217; token
/usr/local/include/mysql++/type_info.h:299: error: &#8216;enum_field_types&#8217; has not been declared
/usr/local/include/mysql++/type_info.h:340: error: expected `)' before &#8216;t&#8217;
/usr/local/include/mysql++/type_info.h:346: error: expected &#8216;,&#8217; or &#8216;...&#8217; before &#8216;&&#8217; token
/usr/local/include/mysql++/type_info.h: In constructor &#8216;mysqlpp::mysql_type_info::mysql_type_info(int)&#8217;:
/usr/local/include/mysql++/type_info.h:348: error: &#8216;f&#8217; was not declared in this scope
/usr/local/include/mysql++/type_info.h:348: error: &#8216;UNSIGNED_FLAG&#8217; was not declared in this scope
/usr/local/include/mysql++/type_info.h:349: error: &#8216;NOT_NULL_FLAG&#8217; was not declared in this scope
/usr/local/include/mysql++/row.h: At global scope:
/usr/local/include/mysql++/row.h:66: error: expected &#8216;,&#8217; or &#8216;...&#8217; before &#8216;&&#8217; token
/usr/local/include/mysql++/result.h:77: error: expected `)' before &#8216;*&#8217; token
/usr/local/include/mysql++/result.h:95: error: expected &#8216;;&#8217; before &#8216;*&#8217; token
/usr/local/include/mysql++/result.h:104: error: expected `;' before &#8216;Row&#8217;
/usr/local/include/mysql++/result.h:134: error: expected &#8216;;&#8217; before &#8216;&&#8217; token
/usr/local/include/mysql++/result.h:140: error: expected `;' before &#8216;void&#8217;
/usr/local/include/mysql++/result.h:296: error: expected &#8216;;&#8217; before &#8216;&&#8217; token
/usr/local/include/mysql++/result.h:306: error: expected `;' before &#8216;bool&#8217;
/usr/local/include/mysql++/result.h:320: error: expected &#8216;;&#8217; before &#8216;*&#8217; token
/usr/local/include/mysql++/result.h: In constructor &#8216;mysqlpp::ResUse::ResUse()&#8217;:
/usr/local/include/mysql++/result.h:68: error: class &#8216;mysqlpp::ResUse&#8217; does not have any field named &#8216;result_&#8217;
/usr/local/include/mysql++/result.h: In copy constructor &#8216;mysqlpp::ResUse::ResUse(const mysqlpp::ResUse&)&#8217;:
/usr/local/include/mysql++/result.h:85: error: &#8216;const class mysqlpp::ResUse&#8217; has no member named &#8216;result_&#8217;
/usr/local/include/mysql++/result.h: In member function &#8216;mysqlpp::Row mysqlpp::ResUse::fetch_row()&#8217;:
/usr/local/include/mysql++/result.h:106: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:114: error: &#8216;MYSQL_ROW&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:114: error: expected `;' before &#8216;row&#8217;
/usr/local/include/mysql++/result.h:115: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:115: error: &#8216;mysql_fetch_lengths&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:116: error: &#8216;row&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:124: error: &#8216;row&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;long unsigned int* mysqlpp::ResUse::fetch_lengths() const&#8217;:
/usr/local/include/mysql++/result.h:130: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:130: error: &#8216;mysql_fetch_lengths&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;void mysqlpp::ResUse::field_seek(int)&#8217;:
/usr/local/include/mysql++/result.h:142: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:142: error: &#8216;mysql_field_seek&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;int mysqlpp::ResUse::num_fields() const&#8217;:
/usr/local/include/mysql++/result.h:148: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:148: error: &#8216;mysql_num_fields&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;void mysqlpp::ResUse::purge()&#8217;:
/usr/local/include/mysql++/result.h:164: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:165: error: &#8216;mysql_free_result&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;mysqlpp::ResUse::operator bool() const&#8217;:
/usr/local/include/mysql++/result.h:193: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;bool mysqlpp::ResUse::operator==(const mysqlpp::ResUse&) const&#8217;:
/usr/local/include/mysql++/result.h:308: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:308: error: &#8216;const class mysqlpp::ResUse&#8217; has no member named &#8216;result_&#8217;
/usr/local/include/mysql++/result.h: In member function &#8216;bool mysqlpp::ResUse::operator!=(const mysqlpp::ResUse&) const&#8217;:
/usr/local/include/mysql++/result.h:315: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:315: error: &#8216;const class mysqlpp::ResUse&#8217; has no member named &#8216;result_&#8217;
/usr/local/include/mysql++/result.h: At global scope:
/usr/local/include/mysql++/result.h:356: error: expected `)' before &#8216;*&#8217; token
/usr/local/include/mysql++/result.h:401: error: &#8216;my_ulonglong&#8217; does not name a type
/usr/local/include/mysql++/result.h: In member function &#8216;const mysqlpp::Row mysqlpp::Result::fetch_row() const&#8217;:
/usr/local/include/mysql++/result.h:379: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:387: error: &#8216;MYSQL_ROW&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:387: error: expected `;' before &#8216;row&#8217;
/usr/local/include/mysql++/result.h:388: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:388: error: &#8216;mysql_fetch_lengths&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:389: error: &#8216;row&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:397: error: &#8216;row&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;void mysqlpp::Result::data_seek(mysqlpp::uint) const&#8217;:
/usr/local/include/mysql++/result.h:412: error: &#8216;result_&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h:412: error: &#8216;mysql_data_seek&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;virtual unsigned int mysqlpp::Result::size() const&#8217;:
/usr/local/include/mysql++/result.h:418: error: &#8216;num_rows&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: In member function &#8216;unsigned int mysqlpp::Result::rows() const&#8217;:
/usr/local/include/mysql++/result.h:424: error: &#8216;num_rows&#8217; was not declared in this scope
/usr/local/include/mysql++/result.h: At global scope:
/usr/local/include/mysql++/result.h:458: error: &#8216;my_ulonglong&#8217; does not name a type
/usr/local/include/mysql++/result.h:459: error: &#8216;my_ulonglong&#8217; does not name a type
/usr/local/include/mysql++/result.h: In member function &#8216;mysqlpp::ResUse& mysqlpp::ResUse::operator=(const mysqlpp::ResUse&)&#8217;:
/usr/local/include/mysql++/result.h:628: error: &#8216;const class mysqlpp::ResUse&#8217; has no member named &#8216;result_&#8217;
/usr/local/include/mysql++/query.h: At global scope:
/usr/local/include/mysql++/query.h:639: error: &#8216;my_ulonglong&#8217; does not name a type
/usr/local/include/mysql++/query.h:640: error: &#8216;my_ulonglong&#8217; does not name a type
/usr/local/include/mysql++/query.h: In member function &#8216;void mysqlpp::Query::storein_sequence(Sequence&, const char*)&#8217;:
/usr/local/include/mysql++/query.h:671: error: &#8216;MYSQL_ROW&#8217; was not declared in this scope
/usr/local/include/mysql++/query.h:671: error: expected `;' before &#8216;d&#8217;
/usr/local/include/mysql++/query.h:672: error: &#8216;d&#8217; was not declared in this scope
/usr/local/include/mysql++/query.h:674: error: &#8216;d&#8217; was not declared in this scope
/usr/local/include/mysql++/query.h:674: error: &#8216;class mysqlpp::ResUse&#8217; has no member named &#8216;raw_result&#8217;
/usr/local/include/mysql++/query.h:674: error: there are no arguments to &#8216;mysql_fetch_lengths&#8217; that depend on a template parameter, so a declaration of &#8216;mysql_fetch_lengths&#8217; must be available
/usr/local/include/mysql++/query.h:674: error: (if you use &#8216;-fpermissive&#8217;, G++ will accept your code, but allowing the use of an undeclared name is deprecated)
/usr/local/include/mysql++/query.h: In member function &#8216;void mysqlpp::Query::storein_set(Set&, const char*)&#8217;:
/usr/local/include/mysql++/query.h:696: error: &#8216;MYSQL_ROW&#8217; was not declared in this scope
/usr/local/include/mysql++/query.h:696: error: expected `;' before &#8216;d&#8217;
/usr/local/include/mysql++/query.h:697: error: &#8216;d&#8217; was not declared in this scope
/usr/local/include/mysql++/query.h:699: error: &#8216;d&#8217; was not declared in this scope
/usr/local/include/mysql++/query.h:699: error: &#8216;class mysqlpp::ResUse&#8217; has no member named &#8216;raw_result&#8217;
/usr/local/include/mysql++/query.h:699: error: there are no arguments to &#8216;mysql_fetch_lengths&#8217; that depend on a template parameter, so a declaration of &#8216;mysql_fetch_lengths&#8217; must be available

Zakaj mi to prevajalnik vrne vse to, če sem mysql++ namestil kot sem prebral tu. V konzolo pa napišem g++ MySQLpp.cpp -o MySQLpp.o v MySQLpp.cpp pa imam samo napisano int main(){return 0;};

Lp,

fx :: 2. okt 2006, 23:35

Našel sem to :

CFG=/usr/local/mysql/bin/mysql_config
sh -c "g++ -o progam_name `$CFG --cflags` progam_name.cpp `$CFG --libs`"

zadeva deluje sem jo preizkusil s to kodo:

#include <iostream>
#include <mysql.h>
int main()
{
    MYSQL mysql;
    mysql_init(&mysql);
    if (!mysql_real_connect(&mysql,"localhost","root","new_password","tuncek",0,NULL,0))
    {
        std::cout << "Napaka ! : "  << mysql_error(&mysql);
    }
    char *query = "select * from table";
    mysql_real_query(&mysql,query,strlen(query));
    MYSQL_RES *res = mysql_store_result(&mysql);
    MYSQL_ROW row;
    while ((row = mysql_fetch_row(res)))
    {
            std::cout << row[0] << " " << row[1] << std::endl;
    }
    mysql_close(&mysql);
    return 0;
}

Samo ko poženem mi program javi naslednje: Segmentation fault

Kaj to pomeni, ker res ne vem.

Lp,

BigWhale :: 3. okt 2006, 09:54

Poglej moj post pred tvojim. ;)

Gundolf :: 3. okt 2006, 10:15

Ne veš kaj je segmentation fault? To pomeni da ti program dostopa do nekega kosa pomnilnika, katerega si ne lasti. Vzroki so torej recimo dostopanje do podakov na katere kaže NULL pointer, prevellik ali premajhen index pri dostopanju do tabel, dostopanje do deletanih pointerjev itd.

fx :: 4. okt 2006, 00:19

Kako pa se z Qt dela, ker dosedaj sem vendo uporabljaj konzolo tako za C/C++ in tudi za PHP.

Lp,

BigWhale :: 4. okt 2006, 16:28

Qt je skupek knjiznjic. :) www.trolltech.com

fx :: 5. okt 2006, 11:04

Program katerega pišem bo pozneje deloval s mysql v textovnem načinu, ker podatke ki jih bom vpisoval v podatkovno bazo bodo prihajali iz serijskih vrat. Potrebujem pa samo to da se podatki vpišejo v bazo in da se za vsaki dan ustvari nova podatkovna baza. To pa je vse kar potrebujem.

V linuxu in win so ti baze datoteke in me sedaj zanima če jaz lahko bi ti pisal direkto v datoteko ali tega mysql ne dovoli, ali pa je prezapleten sistem zapisavanja direktov v datoteko. Samo spršuje če kdo ve.

Lp,

BigWhale :: 6. okt 2006, 09:16

Potem je Qt, kot nalasc zate! ;)

Resnicno, Qt je skupek knjiznjic in omogoca tudi delo z mysql bazo podatkov. V bistvu omogoca delo s precej bazami in ima svoj abstraction layer za dostop do baz, tako, da lahko (ce malo pazis pri pisanju programov) bazo zamenjas in notime.

Pa tudi console only aplikacijo lahko napises brez nekih vecjih tezav. :)

IMO, precej hitreje naredis en tak program s Qtjem, kot, ce bi delal direktno z mysqlom.

fx :: 8. okt 2006, 19:58

Pa mi je uspelo

Koda ime_programa.cpp

#include <iostream>
#include <cstdio>
#include <sys/time.h>
#include <mysql.h>

int main()
{
  MYSQL *conn;
  MYSQL_RES *res;
  MYSQL_ROW row;

  char *server = "localhost";
  char *user = "root";
  char *password = "novo_geslo";
  char *db = "Tuncek";

  char *sqlquery;
  conn = mysql_init(NULL);

  if (!mysql_real_connect(conn, server, user, password, db , 0, NULL, 0)) {
    std::cout << mysql_error(conn) << std::endl;
    return 0;
  }
  else{
    std::cout << "Povezan si na podatkovno bazo " << db << std::endl;
    sqlquery = "SELECT * FROM leto2006";
    if(mysql_query(conn,sqlquery)){
      std::cout << mysql_error(conn);
      return 0;
    }
    res = mysql_use_result(conn);
    while ((row = mysql_fetch_row(res)) != NULL){
      std::cout << row[0] << " " << row[1] << " " << row[3] << " " << row[4] << " " << row[5] << std::endl;
    }
  }
  mysql_free_result(res);
  mysql_close(conn);
  std::cout << "Povezava prekinjena s podatkovno bazo " << db << std::endl;
  return 0;
}

Sedaj kaj morate narediti je to da v konzolo vtipake tole:
g++ -c -I /usr/local/mysql/include/mysql/ ime_programa.cpp
g++ -o izhodni_program ime_programa.o -L /usr/local/mysql/lib/mysql -lmysqlclient
./izhodni_program

/usr/local/mysql/include/mysql/ spremenite po potrebi, odvisno kje se nahaja mysql.h.

in povem da dela. Podobno je za win, kar si tukaj ogledate jaz sem vso zadevo samo priredil za linux.

Pa vseeno ni težko.

Lp,

fx :: 8. okt 2006, 22:40

Sedaj pa še pisanje v bazo :

#include <iostream>
#include <cstdio>
#include <sys/time.h>
#include <mysql.h>
#include <ctime>
#include <cstring>
#include <sstream>

std::string itos(int i){ //Integer preTvOri v String
  std::stringstream s;
  s << i;
  return s.str();
}

int main(){
  time_t rawtime;
  tm * cas;
  time ( &rawtime );
  cas = gmtime ( &rawtime );
  MYSQL *conn;
  MYSQL_RES *res;
  MYSQL_ROW row;
  char *server = "localhost";
  char *user = "root";
  char *password = "novo_geslo";
  char *db = "Tuncek";
  const char *sqlquery;
  conn = mysql_init(NULL);

  if (!mysql_real_connect(conn, server, user, password, db , 0, NULL, 0)) {
    std::cout << mysql_error(conn) << std::endl;
    return 0;
  }
  else{
    ura = itos(cas -> tm_hour + 2) + ":" + itos(cas -> tm_min) + ":" + itos(cas -> tm_sec);
    datum = itos(cas -> tm_mday) + "." + itos(cas -> tm_mon + 1) + "." + itos(cas -> tm_year + 1900);
    std::cin >> data1 >> data2 >> data3 >> data4;
    data = "INSERT into leto2006 (datum, ura, data1, data2, data3, data4) VALUES ('"+datum+"','"+ura+"','"+data1+"','"+data2+"','"+data3+"','"+data4+"')";
    sqlquery = data.c_str();
    if(mysql_query(conn,sqlquery)){
      std::cout << mysql_error(conn);
      return 0;
    }
  }
  mysql_free_result(res);
  mysql_close(conn);

  return 0;
}

Koda deluje uspešno na linux za win pa mislim da je potrebno dodati winshoc.h ali nekaj podobnega za oba primera.

Lp,

fx :: 9. okt 2006, 22:36

Ne veš kaj je segmentation fault? To pomeni da ti program dostopa do nekega kosa pomnilnika, katerega si ne lasti. Vzroki so torej recimo dostopanje do podakov na katere kaže NULL pointer, prevellik ali premajhen index pri dostopanju do tabel, dostopanje do deletanih pointerjev itd.

Kako naj jaz sedaj ugotovim kje mi program dostopa do kosa pomnilinka, katerega si ne lasti, ker sedaj sem združil oba programa tako za branje iz serijskih vrat in pisanje v mysql bazo in se mi zopet to pojavi. En niz preberega ga uspešno shrani v mysql bazo nato pa ven vrže segmentation fault in se program zaključi.
Če poženem vsaki program posamezno pa zadeva deluje lepo, brez kakršnih napak.

Lp,

Gundolf :: 9. okt 2006, 23:31

Očitno si jih slabo združil. Sem ti prejšnjič napisal kje se lokacije za segmentation fault (če odštejemo možnost, da se napaka zgodi v knjižnici, ki jo uporabljaš). Za začetek lahko program debugiraš tako, da greš step by step, in ugotoviš kje ti program štekne.

Če pa ne znaš nobenega debuggerja uporabljat imaš pa dve možnosti
- da se enega naučiš,
- da debugiraš ročno: na ključnih mestih v programu narediš en izpis (cout << "ccc" << endl;), pri katerem bodi pozoren da ga flushas (to ti stori endl). Napaka bo med zadnjim izpisanim in prvim neizpisanim zapisom.

fx :: 10. okt 2006, 01:21

Logika programa je bila na psu zato mu ni šlo vse skupaj, sedaj pa dela kot mora.

Lp,

fx :: 20. okt 2006, 18:49

Zadeva je lepo delovala pod Linux SuSE 10.1 v grafičnem načinu.

Danes pa sem namnestil Pingo Linux 2.0 naložil strežnik namestil apacha, mysql, php vse brez kakršnih večjih problemov potem sem prevedel moj program tudi uspešno in v koncolo napišem ./program

in dobim pozdrav

./program:error while loadnig shared liberaris : libmysqlclient.so.15: cannot open shared object file: No such file or directoriy

Program sem prevedel na ta način:

g++ -c -I /usr/local/mysql/include/mysql/ ime_programa.cpp
g++ -o izhodni_program ime_programa.o -L /usr/local/mysql/lib/mysql -lmysqlclient

Kaj je lahko narobe.

Lp,

Gundolf :: 21. okt 2006, 09:31

Problem je da ti tega fajla ne najde: libmysqlclient.so.15
Ta fajl je dinamična knjižnjica (ekvivalent dll) od mysqla. ki jo mora program v runtimeu naložit. Zakaj je pa ti nimaš / jo program ne najde se mi pa sanja ne.

Tutankhamun :: 3. nov 2006, 18:47

Ok še js eno uprašanje.

Sm tut js naložu mySQL.

Ampak ko dam #include "mysql.h" mi Visual studio 2005 ko prtisnem compile vrže vn to:
e:\program files\microsoft visual studio 8\vc\include\mysql\mysql_com.h(184) : error C2146: syntax error : missing ';' before identifier 'fd'
e:\program files\microsoft visual studio 8\vc\include\mysql\mysql_com.h(184) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
e:\program files\microsoft visual studio 8\vc\include\mysql\mysql_com.h(184) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
e:\program files\microsoft visual studio 8\vc\include\mysql\mysql_com.h(354) : error C2065: 'SOCKET' : undeclared identifier
e:\program files\microsoft visual studio 8\vc\include\mysql\mysql_com.h(354) : error C2146: syntax error : missing ')' before identifier 's'
e:\program files\microsoft visual studio 8\vc\include\mysql\mysql_com.h(355) : error C2059: syntax error : ')'

Nikol nevem kaj morem še narest :(.

Hvala za odgovore

AMD Phenom QUAD 9950 Black Edition, 8GB

Zgodovina sprememb…

spremenil: Tutankhamun (3. nov 2006 ob 18:47)

Tutankhamun :: 3. nov 2006, 19:02

Ok sm najdu, ni treba pomagat, sm na netu najdu enga k ma čist ista uprašanja tko da use špila.
Useen hvala

AMD Phenom QUAD 9950 Black Edition, 8GB

Vredno ogleda ...

	Tema	Sporočila	Ogledi	Zadnje sporočilo
	Tema	Sporočila	Ogledi	Zadnje sporočilo
»	Pomoč C++ samo111 Oddelek: Pomoč in nasveti	7	1366 (1085)	samo111 23. jan 2016 14:39:17
»	[Code:Blocks, c++] Program ne najde knjižnice gtu Oddelek: Programiranje	11	1373 (1152)	gtu 3. jun 2015 15:28:30
»	[C++ & Linux & G++ prevljalnik]Kako dodati knjižnico? balocom Oddelek: Programiranje	9	1329 (1329)	balocom 29. okt 2007 11:00:34
»	problem z phpjem zdobersek Oddelek: Izdelava spletišč	30	4268 (3681)	snow 13. sep 2006 08:35:46
»	Gentoo Linux & nov KDE problem! Tarzan Oddelek: Pomoč in nasveti	10	1249 (1189)	Tarzan 24. avg 2004 09:33:39

Več podobnih tem

Forum » Programiranje » [C] MySQL

[C] MySQL

[C] MySQL

SodVina :: 11. nov 2003, 10:03

Vesoljc :: 11. nov 2003, 10:20

SodVina :: 11. nov 2003, 10:59

BigWhale :: 11. nov 2003, 15:25

SodVina :: 12. nov 2003, 09:18

BigWhale :: 12. nov 2003, 09:34

fx :: 16. feb 2006, 10:28

CWIZO :: 16. feb 2006, 14:04

fx :: 12. jul 2006, 21:14

sverde21 :: 13. jul 2006, 07:28

fx :: 13. jul 2006, 09:17

sid_dabster :: 13. jul 2006, 09:33

BigWhale :: 13. jul 2006, 10:14

fx :: 16. sep 2006, 16:47

fx :: 2. okt 2006, 23:35

BigWhale :: 3. okt 2006, 09:54

Gundolf :: 3. okt 2006, 10:15

fx :: 4. okt 2006, 00:19

BigWhale :: 4. okt 2006, 16:28

fx :: 5. okt 2006, 11:04

BigWhale :: 6. okt 2006, 09:16

fx :: 8. okt 2006, 19:58

fx :: 8. okt 2006, 22:40

fx :: 9. okt 2006, 22:36

Gundolf :: 9. okt 2006, 23:31

fx :: 10. okt 2006, 01:21

fx :: 20. okt 2006, 18:49

Gundolf :: 21. okt 2006, 09:31

Tutankhamun :: 3. nov 2006, 18:47

Tutankhamun :: 3. nov 2006, 19:02

Vredno ogleda ...

Forum » Programiranje »
[C] MySQL