[PHP] Validate CSV file With Table in Database!!
I need to compare a csv file to a table in the database but only one field in the database with one field in the CSV file! Comparing only one field will make it much easier! When there is any change in the Database compared to the CSV file , the database must then be updated or if there are no such a field it must be added to the table! I am new in php Please help! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Validate CSV file With Table in Database!!
This is the code i came up with! But it is not 100%
"") {
if (!copy($uFile, $move_to_dir."/".$uFile_name)) {
echo "No File Uploaded";
}
$curr = fopen($move_to_dir."/".$uFile_name, "r");
while ($currar = fgetcsv($curr, 1000, ",")) {
$CurrCode = $currar[0];
$Currency = $currar[1];
$From1 = $currar[2];
$To1 = $currar[3];
$ROEX = $currar[4];
$sqlcurr="SELECT * FROM CurrencyNetwork WHERE CNCurr =
'$Currency'";
$result = mysql_query($sqlcurr,$db_con);
if (mysql_fetch_array($result)) {
//Do Nothing
} else {
$sql="INSERT INTO CurrencyNetwork
(CNCode,CNCurr,CNAdBy,CNDtAd,CNROEX)
values ('$CurrCode', '$Currency', '$From1', '$To1',
'$ROEX')";
mysql_query($sql,$db_con);
}
}
mysql_close($db_con);
}
}
else
{
// No file uploaded, show the form
echo "";
echo "Upload this file: ";
echo "";
echo "";
}
?>
"David Robley" <[EMAIL PROTECTED]> wrote in message
01091317241109.14360@www">news:01091317241109.14360@www...
> On Thu, 13 Sep 2001 16:52, you wrote:
> > There is a very good reason !
> > The csv file contains world currency's
> > The system is updated with the changed currency's only !
> > The Master field contains all country currency's , this makes it
> > difficult because if i drop the master table and upload the csv there
> > will only be a few currency's!
> >
> > Thanks
> > Coenraad Steenkamp
> >
> >
> > - Original Message -
> > From: "David Robley" <[EMAIL PROTECTED]>
> > Newsgroups: php.general
> > To: "Coenraad Steenkamp" <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > Sent: Thursday, September 13, 2001 9:18 AM
> > Subject: Re: [PHP] Validate CSV file With Table in Database!!
> >
> > > On Thu, 13 Sep 2001 16:37, Coenraad Steenkamp wrote:
> > > > I need to compare a csv file to a table in the database but only
> > > > one field in the database with
> > > > one field in the CSV file! Comparing only one field will make it
> > > > much easier! When there is any change in the Database compared to
> > > > the CSV file , the database must then be updated or if there are no
> > > > such a field it must be added to the table!
> > > >
> > > > I am new in php Please help!
> > >
> > > That seems an awful lot of work, if you know that the csv is at least
> > > as up to date, if not more so, than the actual table. You might as
> > > well just drop the table and import the contents of the csv.
> > >
> > > Unless there's a good reason not to that you haven't mentioned?
>
> OK. So it sounds like you need to do something like:
>
> for each csv file line
> select record where table_key = csvfield_key
> if record found
> if table_other_value != csv_other_value
> update table with csv_value
> end if
> else (record not found)
> insert new record
> end if
> end for
>
> where the key might be perhaps the country name and the other value is
> the current currency.
>
> Am I on the right track? Does that help you any?
>
> --
> David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
> CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
>
>I am functioning within established parameters.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Get Info From Database Without Refreshing the Page! Pretty Neat!
I used a Microsoft Object Control to get data from the database and display it on the page without refreshing the page!This saves alot of browsing time ! Now there is a little bit of a problem ! I dont know if anyone have done this before exept me and microsoft. I did it in php microsoft did it in asp! Microsoft can get the data without refreshing the page and use next , previous buttons, I can't get the buttons thingy's to work ! If anyone know how to do this please leave some info! I know how to do it by refreshing the page but if i can do it without refreshing it would really kick some ass! Coenraad Steenkamp -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Get Info From Database Without Refreshing the Page! Pretty Neat!
It is a little something like this With datafields getting the return vallues from EA_Cone010.php3 "Ralph Guzman" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > What you are trying to do here sounds like it is done on the client end. I'd > be willing to bet this requires the use of Javascript/Jscript/VBScript and > DHTML. > > -Original Message- > From: Coenraad Steenkamp [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 13, 2001 2:29 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Get Info From Database Without Refreshing the Page! Pretty > Neat! > > I used a Microsoft Object Control to get data from the database and display > it on the page > without refreshing the page!This saves alot of browsing time ! > Now there is a little bit of a problem ! I dont know if anyone have done > this before exept me and microsoft. I did it in php microsoft did it in asp! > Microsoft can get the data without refreshing the page and use next , > previous buttons, I can't get the buttons thingy's to work ! > If anyone know how to do this please leave some info! > I know how to do it by refreshing the page but if i can do it without > refreshing it would really kick some ass! > > Coenraad Steenkamp > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Go and look at this shitt! The page does not refresh at all!
This is what i was talking about in my previous post! But now i need to get a way of using next and previous with it! http://www.dev.co.za/devtest/Example/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Anti Leech Script ??????? please
Does anyone know of a anti leech script and where i could get it! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Problem with dropdownboxes allways ontop of layers!!!!! Please Help!!!!!
begin 666 BigProb.jpg
M_]C_X `02D9)1@`!`0```0`!``#_VP!#``X*"PP+"0X,"PP0#PX1%2,7%1,3
M%2L?(1HC,RTV-3(M,3 X/U%%.#Q-/3 Q1F!'35166UQ;-T1C:F-8:E%96U?_
MVP!#`0\0$!42%2D7%RE7.C$Z5U=75U=75U=75U=75U=75U=75U=75U=75U=7
M5U=75U=75U=75U=75U=75U=75U=75U?_P `1" $N`JX#`2(``A$!`Q$!_\0`
M'P```04!`0$!`0$```$"`P0%!@<("0H+_\0`M1 ``@$#`P($`P4%
M! 0```%]`0(#``01!1(A,4$&$U%A!R)Q%#*!D:$((T*QP152T? D,V)R@@D*
M%A<8&1HE)B7J#A(6&AXB)BI*3E)66EYB9FJ*CI*6FIZBIJK*SM+6VM[BYNL+#Q,7&
MQ\C)RM+3U-76U]C9VN'BX^3EYN?HZ>KQ\O/T]?;W^/GZ_\0`'P$``P$!`0$!
M`0$!`0$"`P0%!@<("0H+_\0`M1$``@$"! 0#! <%! 0``0)W``$"
M`Q$$!2$Q!A)!40=A<1,B,H$(%$*1H;'!"2,S4O 58G+1"A8D-.$E\1<8&1HF
M)R@I*[EMAIL PROTECTED]$149'2$E*4U155E=865IC9&5F9VAI:G-T=79W>'EZ@H.$
MA8:'B(F*DI.4E9:7F)F:HJ.DI::GJ*FJLK.TM;:WN+FZPL/$Q<;'R,G*TM/4
MU=;7V-G:XN/DY>;GZ.GJ\O/T]?;W^/GZ_]H`# ,!``(1`Q$`/P#J8;A9I+A%
M# P.(V)'4E5;C\&I6G5;N.V(.^2-Y 0.,*5!S[_.*Q9(_.:2XEMI9+*6^$DB
M-$Q+QB ("8\;C^\`[=@<=#4(@B5K$W]G-+;!;D*@@=P%,JF-60`X&P<*1Q@<
M97B1G2T#J*K:FVB76[SUA02;CD[@HSD]SGO]?K5F@"&&=9I)XUR#!((V
M)'4E5;C\&J*WOXKF`20*[N8$N!%T8JX)4=0,G:1U]?Q@$AL;R\\R":7[3*)(
MO)C+AOD1-I('RG*]20,'KUQDMIS6UK?0?9B]S_8\<(DBB)$C!7!4-CDGY..I
M`'I18#H8[I9)I8HXW)AE\IF &!\@?/7I\P' Z^W-+#.EQ'#+""\,L>]9!TQQ
MC(/.3G/3MVK)DM7DU)P\!>%]0).Y/E9#:;<^XSQ]>*JV]K<_V38I9P2PRKI4
M\8 0Q%93Y?'/0E@QSWY/2G8#IJ*YRVMFGHRE+1U$`A3S#LVQ-"K#`Y$;BP%:W
MO89[RZM$+>;:LHD!&!AER#GN#_0^Q)9WT%Z;D0%C]GF:!R1CYP`3C\\?Y!K)
MNK:]6YO;FS5DN/M)C1V7.5>&-0>>U07*VUE#=6KK$D'VF/8LZ
MF0+&($4-Y>6(4=/8]SU;OGI64JL%U/0I99B*FMK>IZ(1^5%>
M>OJ%S)<_:GD4S@@K+L7>N.P.,@>PX.3DF><5/MXFW]CU^Z_KY'HE%>=?:YA',BL%$Z%)2% :4'KN.,L?]H\\GGDY
M5+VX2.2)9,1RD>8NT8B45Y]'J$J0^08X'MP
M^_R&C'EYP1C8.,9PSM1`UJKA68KM?:%4G(7&#P,X'H`!VH5
M:!G+*L2ME8TD)'3>A.3^%:L4\,ZEH)4D4'&Y&!&?2M$XO9G+4H5*7QJ
MP^BBBJL8AH :`&@!H !H :`%%%
M%&@!H &@!H`` !H`: &@!11
M11H`: &@!H :`&@!H : &@!H
M`: )OC_Y[P_]_5_QHWQ_\]X?^_J_XUYC]DO_`/H+W/\`WTW_`,51]DO_
M`/H+W/\`WTW_`,56W)3_`)B;L].WQ_\`/>'_`+^K_C2AD) 6:$D]`)%/]:\P
M^R7_`/T%[G_OIO\`XJKFD6MZ-8L2VJW#J+B/*DGGYA[T.$.C"YZ1]GE[J/\`
MOH?XT?9Y?[H_[Z'^-([OO8!B!DX`)Q3?,?\`O-^=9#'_`&>7^Z/^^A_C1]GE
M_NC_`+Z'^-,\Q_[S?G1YC_WF_.@8_P"SR_W1_P!]#_&C[/+_`'1_WT/\:9YC
M_P!YOSI1(^1\[?G2`=]GE_NC_OH?XU%7=06(^G0=ZRX;>^U:Z=HHWGE8Y9NPX[G@#I^F*V=*\.!Q
M#,D^W;@\^U=+!%';)LMXUB4G.(QM!/'.,5E&G*>LF=T\9A\
M(N2A%-]SE+7PEJ4I!N/+MT[AF#']#C]:WK/PU;6N_,0N"_\`SVVMC'I6CYC_
M`-YOSH\Q_P"\WYUM&E")YU;,*]96;LO(@_L6U_Y\+;_OA:/[%M?^?"V_[X6I
M_,?^\WYT>8_]YOSJ[+L8_]\_G4NG!]#6.,KQVFS"?PE9QC,D\JC/5I$']*@E\,V17$
M.H!']7=&'Z$56\8"YFNH8HKN6':F0RL?4@C\<#\JYO[)?_\`07N?^^F_^*K2
M-"DUJRO[0Q2>DC>VN%)P`)5#?4@G'Y&LZ&:ZL)_,B9H9<8''4?
MU%51:7__`$%[G_OIO_BJ0V5VQ!?4I7QT#@M_,UG+"T[7A([*6;S?NUU='5:?
MXF7;LOT.[( DC7@CW'K]/RK?ANK:XC62*YA93_TT`QP/4^_0_E7GOV=P@&\,
M<,G8[H2,$@X-8*I*#M(WE@L-BE>A*S['I6^/_GO#_P!_5_QHWQ_\
M]X?^_J_XUY<4NV;C5+I!VR['^M/%K?$9&KW)'^\W_P`57;#V4U=2/'KX>K0=
MIH].WQ_\]X?^_J_XT;X_^>\/_?U?\:\R^R7_`/T%[G_OIO\`XJD^R7__`$%[
MG_OIO_BJODI_S'/=GIV^/_GO#_W]7_&C?'_SWA_[^K_C7F/V2_\`^@O<_P#?
M3?\`Q5'V2_\`^@O<_P#?3?\`Q5')3_F"[/3M\?\`SWA_[^K_`(T;X_\`GO#_
M`-_5_P`:\Q^R7_\`T%[G_OIO_BJ/LE__`-!>Y_[Z;_XJCDI_S!=GIV^/_GO#
M_P!_5_QHWQ_\]X?^_J_XUYC]DO\`_H+W/_?3?_%4?9+_`/Z"]S_WTW_Q5')3
M_F"[/3M\?_/>'_OZO^-&^/\`Y[P_]_5_QKS'[)?_`/07N?\`OIO_`(JC[)?_
M`/07N?\`OIO_`(JCDI_S!=GIV^/_`)[P_P#?U?\`&C?'_P`]X?\`OZO^->8_
M9+__`*"]S_WTW_Q5'V2__P"@O<_]]-_\51R4_P"8+L].WQ_\]X?^_J_XT;X_
M^>\/_?U?\:\Q^R7_`/T%[G_OIO\`XJC[)?\`_07N?^^F_P#BJ.2G_,%V>G;X
M_P#GO#_W]7_&C?'_`,]X?^_J_P"->8_9+_\`Z"]S_P!]-_\`%4?9+_\`Z"]S
M_P!]-_\`%4'_`+^K_C1OC_Y[P_\`?U?\:\Q^R7__`$%[
MG_OIO_BJ/LE__P!!>Y_[Z;_XJCDI_P`P79Z=OC_Y[P_]_5_QHWQ_\]X?^_J_
MXUYC]DO_`/H+W/\`WTW_`,51]DO_`/H+W/\`WTW_`,51R4_Y@NST[?'_`,]X
M?^_J_P"-&^/_`)[P_P#?U?\`&O,?LE__`-!>Y_[Z;_XJC[)?_P#07N?^^F_^
M*HY*?\P79Z=OC_Y[P_\`?U?\:-\?_/>'_OZO^->8_9+_`/Z"]S_WTW_Q5'V2
M_P#^@O<_]]-_\51R4_Y@NST[?'_SWA_[^K_C1OC_`.>\/_?U?\:\Q^R7_P#T
M%[G_`+Z;_P"*H^R7_P#T%[G_`+Z;_P"*HY*?\P79Z=OC_P">\/\`W]7_`!HW
MQ_\`/>'_`+^K_C7F/V2__P"@O<_]]-_\51]DO_\`H+W/_?3?_%4'_OZO^-&^/_GO#_W]7_&O,?LE_P#]!>Y_[Z;_`.*H^R7_`/T%[G_O
MIO\`XJCDI_S!=GIV^/\`Y[P_]_5_QHWQ_P#/>'_OZO\`C7F/V2__`.@O<_\`
M?3?_`!5'V2__`.@O<_\`?3?_`!5')3_F"[/3M\?_`#WA_P"_J_XT;X_^>\/_
M`']7_&O,?LE__P!!>Y_[Z;_XJC[)?_\`07N?^^F_^*HY*?\`,%V>G;X_^>\/
M_?U?\:-\?_/>'_OZO^->8_9+_P#Z"]S_`-]-_P#%4?9+_P#Z"]S_`-]-_P#%
M4'_OZO\`C1OC_P">\/\`W]7_`!KS'[)?_P#07N?^^F_^
M*H^R7_\`T%[G_OIO_BJ.2G_,%V>G;X_^>\/_`']7_&C?'_SWA_[^K_C7F/V2
M_P#^@O<_]]-_\51]DO\`_H+W/_?3?_%4Y_P"^F_\`BJ/LE_\`]!>Y_P"^F_\`BJ.2G_,%V>G;
MX_\`GO#_`-_5_P`:-\?_`#WA_P"_J_XUYC]DO_\`H+W/_?3?_%4?9+__`*"]
MS_WTW_Q5')3_`)@NST[?'_SWA_[^K_C1OC_Y[P_]_5_QKS'[)?\`_07N?^^F
M_P#BJ/LE_P#]!>Y_[Z;_`.*HY*?\P79Z=OC_`.>\/_?U?\:-\?\`SWA_[^K_
M`(UYC]DO_P#H+W/_`'TW_P`51]DO_P#H+W/_`'TW_P`51R4_Y@NST[?'_P`]
MX?\`OZO^-&^/_GO#_P!_5_QKS'[)?_\`07N?^^F_^*H^R7__`$%[G_OIO_BJ
M.2G_`#!=GIV^/_GO#_W]7_&C?'_SWA_[^K_C7F/V2_\`^@O<_P#?3?\`Q5'V
M2_\`^@O<_P#?3?\`Q5')3_F"[/3M\?\`SWA_[^K_`(T;X_\`GO#_`-_5_P`:
M\Q^R7_\`T%[G_OIO_BJ/LE__`-!>Y_[Z;_XJCDI_S!=GIV^/_GO#_P!_5_QH
MWQ_\]X?^_J_XUYC]DO\`_H+W/
