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
  • oscBooks and oscTemplates's Announcements
  • Mini Template System's Announcements
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements

Found 8 results

  1. Hi guys and girls, enthusiasts, I'd like to know how to insert data from a tep_input_field into the mysql database I'm currently using the AJAX Attribute Manager Addon and added another input field to it for EAN/GTIN input. How can I submit the entered ean to my database ? See the Code and attached screenshot below I've already added a column for ean and tried to add ean as input value. The Field is being shown, but inserting doesn't work. Thanks for any help in advance. Have a nice day. <?php echo tep_draw_input_field("ean_$optionValueId",$optionValueInfo['ean'],' style="margin:3px 0px 3px 0px;" id="ean_'.$optionValueId.'" size="7" onfocus="amF(this)" onblur="amB(this)" onChange="return amUpdate(\''.$optionId.'\',\''.$optionValueId.'\',\'ean\');"'); ?>
  2. From MySQL to MariaDB

    I'm running Cpanel 66.0.23 and currently using MySQL 5.6, but support for MySQL 5.6 in Feb 2018 from what I understand. I think Cpanel will still let it run since they let MySQL 5.5 run on current version. However, from there, the only choice is Maria for upgrading on Cpanel. One thing on Cpanel is they don't have a way to downgrade, so if go to Maria and it doesn't work, then that's a problem. I know Harald has mentioned Maria, but is anyone else using it or tried it? I haven't really explored Maria, but I guess in the next few weeks I'll download a copy to my local test server and see how it works. Anyone have any thoughts?
  3. Hi there, It has been a little while since I last posted and I feel guilty that my first post is a request for help not the other way around... My website has been functioning perfectly for several months. Just 2 days or so ago the following error popped up at the top of the screen. I have not made any changes to my website for some time so this error is quite unexpected. As a result of this error you cannot even add something to the cart. Can anyone point me in the right direction? Is it possible that my hosting providers in their infinite wisdom have upgraded their mysql version without advising me and if so, how would I go about fixing it? Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50545 Library:50635 in /home/[username]/public_html/includes/functions/database.php on line 20Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/[username]/public_html/includes/functions/database.php:20) in /home/anc10699/public_html/includes/functions/sessions.php on line 95Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/[username]/public_html/includes/functions/database.php:20) in /home/anc10699/public_html/includes/functions/sessions.php on line 95 Thanks! Peter
  4. 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
  5. 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); }
  6. 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
  7. 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.
  8. 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