Menu

How I can import/export data from MySQL

Help
Laurynas
2004-05-25
2013-04-09
  • Laurynas

    Laurynas - 2004-05-25

    How I can import/export data from MySQL in aynHTML editor? Server MySQL+PHP.

     
    • Dan Kinchen

      Dan Kinchen - 2004-10-09

      let me see if I can help, I loaded it with coldfusion. I have other things to fix before I put it back.

      Anyways, I created a new file in my programming language. Example;

      modify.cfm

      Then I ran my database query;

      then I put the in the snippet of code to run the editor with the settings I wanted. Here is the example;

      ------------- Start Code -------------------

      <cfquery name="qinfo" datasource="yourDSN" username="username" password="password">
          SELECT info_id, bio
          FROM info
          WHERE info_id='1'
      </cfquery>
      <html xmlns:AI>
      <head><?import namespace="AI" implementation="aiEditor.htc" />
      </head>
      <body>
      <AI:aiEditor id="aiEditor"
      path=""
      hide_btn="open"
      stylesheet="external.css"
      pic_get="support/images.xml"
      link_get="support/links.xml"
      font_size="8,9,10,11,12,13,14,16,20,24,48"
      palette="web, system"
      pic_put="support/upload.cfm"
      height="400"
      width="600"
      save_method="custom"><cfoutput query="qinfo">#bio#</cfoutput>
      </AI:aiEditor>
      </body>
      </html>

      ------------- End Code -------------------

      Did you see this save_method = "custom"> between this tag and the </AI:aiEditor> you put in your custom text. In your case you variables in php and or the code the excutes it.

      I hope I have helped. What was really hard was pulling all my image paths from the database and then build a script to turn the results into xml and saving it back to the server. I accomplished it, but then found another script to display all contents of my image directory which was better. Then turn that list into a XML file. I cannot help you with that unless you use coldfusion.

       

Log in to post a comment.

MongoDB Logo MongoDB