Jump to content
Latest News: (loading..)

Search the Community

Showing results for tags 'mysql'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • News and Announcements
    • News and Announcements
    • Partner Announcements
    • Ambassadors
  • Commercial Support
    • Developer Feedback
  • osCommerce Online Merchant v2.x
    • General Support
    • Installation and Configuration
    • Upgrading from Earlier Versions (v2.x to v2.x)
    • Add-Ons
    • Tips and Tricks
    • Security
  • Development
    • osCommerce Online Merchant v2.4
    • osCommerce Online Merchant Community Bootstrap Edition
    • osCommerce Online Merchant v3.x
    • Development Proposals
  • General
    • Next Steps / Optimizations / Marketing
    • Live Shop Reviews
    • E-Commerce Laws
    • General Discussions
    • PHP / SQL / Web Design
  • Club osC's Announcements
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein
  • German Community's OSCOM v3.x

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name





Found 6 results

  1. Please help me #1812 - Tablespace is missing for table '(null)' mysql osCommerce `usu_cache` problem
  2. Hi all. I am working on an oscommerce app on my side. i need a lil help with Json and Java script. at this time oscommerce categories is fetch by a json php file and put in my drawer menu. (file attach to this post.) i want now create a webview in my mainActivity but i had some trouble to send my array in the webview. WebView must load an Url with the categories id referred by the Drawer Navigation. EX: webview.loadUrl(link/index.php?cPath=25); or uri.parse...... My source: https://github.com/gasse4life/Json_MySql-in-Dynamic-Nav-Drawer.git MainActivity.java -------------------------- package com.androidbelieve.navdrawer; import android.support.design.widget.NavigationView; import android.support.v4.widget.DrawerLayout; import android.support.v7.app.ActionBarDrawerToggle; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.support.v7.widget.Toolbar; import android.util.JsonReader; import android.util.Log; import android.view.Menu; import android.view.MenuItem; import java.io.InputStream; import java.io.InputStreamReader; import java.net.URL; import java.net.URLConnection; import java.util.ArrayList; public class MainActivity extends AppCompatActivity { @[member=Override] protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); /** * Setting up the DrawerLayout,NavigationView and Toolbar. */ final DrawerLayout drawerLayout = (DrawerLayout) findViewById(R.id.drawerLayout); NavigationView navigationView = (NavigationView) findViewById(R.id.navigationView); Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar); setSupportActionBar(toolbar); /** * Accessing the NavigationView menu. * The getMenu method returns menu resource used by navigationView. * Later,we will add items to this menu. */ Menu drawerMenu = navigationView.getMenu(); /** * Creating object of AsyncClass - 'PopulateMenuItems' to get items from the database. * Here,we pass the above menu so that after retrieving items we can add this to it. */ PopulateMenuItems populateMenuItems = new PopulateMenuItems(); populateMenuItems.execute(drawerMenu); /** * This is required to handle the onItemClick on Navigation Drawer Items. */ NavigationView.OnNavigationItemSelectedListener item_click_listener = new NavigationView.OnNavigationItemSelectedListener() { @[member=Override] public boolean onNavigationItemSelected(MenuItem item) { /** This a sample code to change fragments depending on the menu item. * * if(item.toString="someConditionalText") * { * FragmentManager mFragmentManager; * FragmentTransaction mFragmentTransaction; * * mFragmentManager = getSupportFragmentManager(); * mFragmentTransaction = mFragmentManager.beginTransaction(); * * mFragmentTransaction.replace(R.id.containerView,new TabFragment()).commit(); * } */ drawerLayout.closeDrawers(); return true; } }; /** * Attaching the above listener to NavigationView */ navigationView.setNavigationItemSelectedListener(item_click_listener); /** * Setting up Drawer Toggle for Toolbar. */ ActionBarDrawerToggle mDrawerToggle = new ActionBarDrawerToggle(this,drawerLayout, toolbar,R.string.app_name, R.string.app_name); drawerLayout.setDrawerListener(mDrawerToggle); mDrawerToggle.syncState(); } public class PopulateMenuItems extends android.os.AsyncTask<Menu,Void,Void>{ @[member=Override] protected Void doInBackground(final Menu... params) { try { /** *An arrayList to hold the items populated from database. */ final ArrayList menuItems = new ArrayList(); /** * Here, declare the URL. If on localhost, just write the localhost ip and add the path. * The url object parses the urlString and throws 'MalformedURLException' if URL could not be parsed. * OpenConnection returns a connection referred by URL. */ String urlString = "http://depanneur-virtuel.info/apk_getAllcat.php"; URL url = new URL(urlString); URLConnection urlConnection = url.openConnection(); /** * InputStream reads the response in bytes and by InputStreamReader it is converted into characters. */ InputStream inputStream = urlConnection.getInputStream(); InputStreamReader inputStreamReader = new InputStreamReader(inputStream,"UTF-8"); /** * JsonReader is used to parse the below output. * ["House Lannister","House Stark","House Targaryen","House Martell","House Tyrell","House Tully"] * In JSON , array stats with '['(Square Bracket) and object with '{'(Curly Bracket)). * More on JsonReader : http://developer.android.com/reference/android/util/JsonReader.html. */ JsonReader jsonReader = new JsonReader(inputStreamReader); jsonReader.beginArray(); while (jsonReader.hasNext()){ /** * Get the nextString of the JSON array and add it to the arrayList - 'menuItems'. */ String item = jsonReader.nextString(); menuItems.add(item); } jsonReader.endArray(); /** * runOnUiThread is used to update UI i.e Add Items to NavigationView Menu from this non-UI thread(AysncTask). */ runOnUiThread(new Runnable() { @[member=Override] public void run() { /** * params[0] refers to the first parameter passed to this method i.e a menu. * Add items to this menu by iterating the arrayList. */ Menu drawerMenu = params[0]; for (int temp=0;temp<=menuItems.size()-1;temp++){ Log.e("String",menuItems.get(temp).toString()); drawerMenu.add(menuItems.get(temp).toString()); } } }); } catch (Exception e){ Log.e("Exception",e.toString()); } return null; } } } apk_getAllcat.php
  3. I've been building some new interfaces on my shop, and have realized that I would like to use mysqli_fetch_all, so I added it into my database.php. It might be a useful function to have in osC. Just a proposal. function tep_db_fetch_all($db_query) { return mysqli_fetch_all($db_query, MYSQLI_ASSOC); }
  4. Hi, i have found the next messages which could be important: i have no information about changing of datetime format but many of updated shop probably need this change. more info here http://mysqlserverteam.com/upgrading-old-mysql-5-5-format-temporals-to-mysql-5-6-format-2/ i think this could be used in next releases ALTER TABLE t1 FORCE; Regards, Gergely
  5. I am looking to create a google feed for my instance of osCommerce. However, I have the ultimate SEO URL's 5 installed on my 2.3.1 instance. How do I get the product URL's for each product at they are not stored in the database in the products table? Any help would be appreciated.
  6. Native MySQL extension is slightly faster than the improved MySQLi extension, but the latest more stable and have more features. This addon simply replicate the default database function, so you don't have to worry that you need to edit many files. The installation process as easy as uploading a file (database_mysqli.php) and edit one line in application.top.php. As a bonus, this addon add new tep_db_multi_query function (see: mysqli.multi-query.php), so now you can make multi query in one call. Sample of using "tep_db_multi_query" can be found in the archive. Download it here: http://addons.oscommerce.com/info/8168 Best, @zaenal